Re: rman script to backup on both instances in a RAC env.
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: gnahmed.c@xxxxxxxxxx
- Date: Wed, 2 May 2007 15:07:11 +0300
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."
Other related posts:
