FreeLists / oracle-l / Re: rman script to backup on both instances in a RAC env.

["Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>]

Nizar,

You need to worry about the archivelog backups. You can run the backup from
any node.
However, how did you configure your archive location of different nodes? Is
it on ASM, sharable by all nodes?

Jaffar


On 5/2/07, Nizar Ahmed <gnahmed.c@xxxxxxxxxx> wrote:
>  Currently my RMAN script runs on one instance of a two node RAC.
>
>
>
>
>
> I want to modify it to run on both instances. I have tried but no luck in
> allocation of channels or connection to both instance. How can I modify this
> please?
>
>
>
> Thanks.
>
>
>
> Nizar
>
>
>
>
>
> connect target rmanbk/123@odsprod
>
> connect catalog rman_ods/123@rmancat
>
>
>
> CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 4;
>
> run
>
> {
>
> set command id to 'odsprod1';
>
> allocate channel t1 type SBT_TAPE  parms
> 'ENV=(NSR_SERVER=nwsriy01,NSR_CLIENT=ods-app)';
>
>
>
> allocate channel t2 type SBT_TAPE  parms
> 'ENV=(NSR_SERVER=nwsriy01,NSR_CLIENT=ods-app)';
>
>
>
> allocate channel t3 type SBT_TAPE  parms
> 'ENV=(NSR_SERVER=nwsriy01,NSR_CLIENT=ods-app)';
>
>
>
> allocate channel t4 type SBT_TAPE  parms
> 'ENV=(NSR_SERVER=nwsriy01,NSR_CLIENT=ods-app)';
>
>
>
>
>
> sql 'alter database backup controlfile to trace';
>
> backup archivelog  all delete input
>
> format 'odsprod_arc_%T_%s.bak';
>
>
>
>  backup incremental level=2 cumulative
>
>  filesperset 50
>
>  tag 'Level 2 Backup'
>
> format 'odsprod_db_%T_%s.bak'
>
> (database include current controlfile);
>
>
>
> release channel t1;
>
> release channel t2;
>
> release channel t3;
>
> release channel t4;
>
> }
>
>
>
>
>
>
>
>
>   Disclaimer: The information in this email and in any files transmitted
> with it,
> is intended only for the addressee and may contain confidential and/or
> privileged material.
> Access to this email by anyone else is unauthorized. If you receive this
> in error,
> please contact the sender immediately and delete the material from any
> computer.
> If you are not the intended recipient, any disclosure, copying,
> distribution or
> any action taken or omitted to be taken in reliance on it, is strictly
> prohibited.
> Statement and opinions expressed in this e-mail are those of the sender,
> and do not
> necessarily reflect those of STC.


--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."