Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: backup backupset over multiple channels in RAC

RE: backup backupset over multiple channels in RAC

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 11 Nov 2004 10:59:11 -0500
Message-ID: <7B51890723365F4591B1B2319985D012BE914C@EXCHSERV2.Limited.brands.com>

 This is how we do it. We however use simple scripts that do the job for us and a sheduler runs it. We can simply change a parameter to change the amount of copies left on disk. Confirming it is successful to tape is what we wanted to control at a native level.

I think we backup in the terabyte range to disk then ship to tape. Just ask any thing specific you want about this.

Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of tomi wijanto
Sent: Thursday, November 11, 2004 2:36 AM To: ORACLE-L_at_freelists.org
Subject: Re: backup backupset over multiple channels in RAC

Hi Peter,

my problem is on backup, not restore..
I have successfully tried to backup directly to tape using multiple channels, but this is not what i want. (each node on RAC' instances have local tape)

I need to backup existing backupset in disk to tape. Because currently my backupset are located in each instances, command 'backup backupset' does not work as i post before.

regards,
tomi

> 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 when
> 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
> restore
> with Rman, the virtual node is normaly configered in
> a env varible or a
> 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='user/pwd_at_node1'
> >parms
>
>'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
> >allocate channel sbt_tape_2 type 'sbt_tape' connect='user/pwd_at_node2'
> >parms
>
>'ENV=(TDPO_OPTFILE=/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
                



Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com  
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 11 2004 - 10:02:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US