Re: RMAN Duplicate Fails - Suggestions?

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Mon, 17 Mar 2008 12:44:23 +0000 (GMT)
Message-ID: <311959.63127.qm@web27808.mail.ukl.yahoo.com>

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

Received on Mon Mar 17 2008 - 07:44:23 CDT