Re: RMAN Duplicate Fails - Suggestions?

From: hrishy <hrishys@xxxxxxxxxxx>
To: hrishy <hrishys@xxxxxxxxxxx>, david.barbour1@xxxxxxxxx, Oracle L <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 17 Mar 2008 12:44:23 +0000 (GMT)

Hi David

Does this work ?#

I have added duplicate target database to qa1 to your
script.

Its strange that your original script is trying to
retore it to the traget database when the duplicate
target database to qa1 is missing

[code]
rman <<EOF

connect target sys/<password>@pr1
connect catalog rmanadmin/<password>@rcat
connect auxiliary sys/<password>@qa1

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

run{
allocate auxiliary channel dupdb1 type 'sbt_tape';
allocate auxiliary channel dupdb2 type 'sbt_tape';
allocate channel reg1 type 'sbt_tape';
allocate channel reg2 type 'sbt_tape';
set until scn  3864716014;
set newname for datafile  400 to
"/oracle/QA1/sapdata4/zzsws1ai_6/zzsws1ai.data6";
set newname for datafile  401 to
"/oracle/QA1/sapdata3/undo_3/undo.data3";
set newname for datafile  402 to
"/oracle/QA1/sapdata2/zarixfi4i_5/zarixfi4i.data5";
restore datafile 400,401,402;
duplicate target database to qa1;
}
EOF
[/code]



      ___________________________________________________________ 
Rise to the challenge for Sport Relief with Yahoo! For Good  

http://uk.promotions.yahoo.com/forgood/
--
http://www.freelists.org/webpage/oracle-l

Re: RMAN Duplicate Fails - Suggestions?

Other related posts: