Re: RMAN Duplicate Fails - Suggestions?

From: hrishy <>
Date: Mon, 17 Mar 2008 12:44:23 +0000 (GMT)
Message-ID: <>

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

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)';

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
set newname for datafile 401 to
set newname for datafile 402 to
restore datafile 400,401,402;
duplicate target database to qa1;

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

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

Original text of this message