From oracle-l-bounce@freelists.org Thu Nov 11 00:51:02 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAB6p2s12598 for ; Thu, 11 Nov 2004 00:51:02 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAB6p2a12593 for ; Thu, 11 Nov 2004 00:51:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E150972D2C8; Thu, 11 Nov 2004 01:57:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25290-80; Thu, 11 Nov 2004 01:57:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 960CB72CBDE; Thu, 11 Nov 2004 01:57:16 -0500 (EST) Message-ID: <41930CD7.9060400@miracleas.dk> Date: Thu, 11 Nov 2004 07:55:19 +0100 From: Peter Gram Organization: Miracle A/S User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: restomi_w@yahoo.com Cc: oracle-l@freelists.org Subject: Re: backup backupset over multiple channels in RAC References: <20041111063022.57050.qmail@web52010.mail.yahoo.com> In-Reply-To: <20041111063022.57050.qmail@web52010.mail.yahoo.com> Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 12116 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.gram@miracleas.dk Precedence: normal Reply-To: peter.gram@miracleas.dk X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Tomi The problem is not in Rman, bur in the software from the tapestation, it will register the IP or Node name the Rman backupset was generated and wh= en Rman then try to restore the backupset from the other node it will fail. The way to fix this is to use a virtual IP / node when you backup and=20 restore with Rman, the virtual node is normaly configered in a env varible or a=20 config file for the backup software. /peter tomi wijanto wrote: >Hi All, > >I have procedure to backup RAC database using multiple >channels to disk (each channel for different >instance). >Now, i try to backup backupset to tape, but failed. >If i connect to first instance, rman said that it >cannot find backupset that actually located in second >instance's node. >I'm using oracle 9.2.0.3, ibm tivoli. > >The rman backup backupset command is like this: > >run { >allocate channel sbt_tape_1 type 'sbt_tape' >connect=3D'user/pwd@node1' parms >'ENV=3D(TDPO_OPTFILE=3D/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; >allocate channel sbt_tape_2 type 'sbt_tape' >connect=3D'user/pwd@node2' parms >'ENV=3D(TDPO_OPTFILE=3D/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; >backup backupset completed after 'sysdate-1'; >} > >The questions are: >- Is there any limitation of 'backup backupset' to >spread over multiple instances in RAC? >- If so, should i only backup from one node to disk? >(i spread them because backup of database from >multiple instances is faster than single instance) > >regards, >tomi > > > > =09 >__________________________________=20 >Do you Yahoo!?=20 >Check out the new Yahoo! Front Page.=20 >www.yahoo.com=20 >=20 > >-- >http://www.freelists.org/webpage/oracle-l > > =20 > --=20 Best regards / Venlig hilsen /*Peter Gram*/ Miracle A/S Kratvej 2 DK - 2760 M=E5l=F8v Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Skype: peter_gram Email: peter.gram@miracleas.dk 22-24 Nov 2004 RMAN-kursus med Tuomas Pystynen=20 17-19 Jan 2005 Miracle Master Class with Tim Gorman=20 28 feb - 2.mar 2005 Database Master Class with Chris Date=20 2-4 May 2005 SQL Server Master Class with Kimberly Tripp=20 -- http://www.freelists.org/webpage/oracle-l