Re: backup backupset over multiple channels in RAC

  • From: tomi wijanto <restomi_w@xxxxxxxxx>
  • To: ORACLE-L@xxxxxxxxxxxxx
  • Date: Wed, 10 Nov 2004 23:36:08 -0800 (PST)

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

--- Peter Gram <peter.gram@xxxxxxxxxxxx> wrote:

> 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@node1' parms
>
>'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
> >allocate channel sbt_tape_2 type 'sbt_tape'
> >connect='user/pwd@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 
 

--
//www.freelists.org/webpage/oracle-l

Other related posts: