RE: backup backupset over multiple channels in RAC
- From: tomi wijanto <restomi_w@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Nov 2004 19:11:24 -0800 (PST)
Hi Brian,
in my current RAC env, i backup to disk using multiple
channels, each channel has connection to different
instance. So, disk backupset are located in different
server.
Now, i also need to backup to tape. Instead of running
again rman backup to tape directly, i only want to
move disk backupset to tape.
Do you use RMAN to move disk backupset to tape? or
just move it directly? I need to keep information
about tape backupset in rman repository.
Using RMAN 'backup backupset', i can move disk
backupset to tape (i try it for specific backupset,
for ex: backup backupset 1230).
But when i tried for all existing disk backupset, it
caused error because cannot find backupset in another
server.
So i guess, this is limitation of command 'backup
backupset' to doing multiple channels backup on
different instance.
regards,
tomi
--- "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx> wrote:
>
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of tomi wijanto
> Sent: Thursday, November 11, 2004 2:36 AM
> To: ORACLE-L@xxxxxxxxxxxxx
> 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
>
> --- 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:
