Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: backup backupset over multiple channels in RAC
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
>
> 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
>
> --- Peter Gram <peter.gram_at_miracleas.dk> 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_at_node1'
> > >parms
> >
> >'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
> >'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';> > >The questions are:
> > >backup backupset completed after 'sysdate-1';
> > >}
> > >
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 11 2004 - 22:09:49 CST