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

Home -> Community -> Mailing Lists -> Oracle-L -> rman script to backup on both instances in a RAC env.

rman script to backup on both instances in a RAC env.

From: Nizar Ahmed <gnahmed.c_at_stc.com.sa>
Date: Wed, 2 May 2007 12:50:59 +0300
Message-ID: <1CEF5E157E52CC4BAFC7AA5549364E6A04A9C6BB@ednriymsg04.stc.corp>

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_at_odsprod

connect catalog rman_ods/123_at_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.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 02 2007 - 04:50:59 CDT

Original text of this message

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