Re: RMAN Duplicate Fails - Suggestions?
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Mon, 17 Mar 2008 12:58:32 +0000 (GMT)
Message-ID: <450252.93146.qm@web27809.mail.ukl.yahoo.com>
Rise to the challenge for Sport Relief with Yahoo! For Good
Date: Mon, 17 Mar 2008 12:58:32 +0000 (GMT)
Message-ID: <450252.93146.qm@web27809.mail.ukl.yahoo.com>
Hi
How about slight modification to the Metalink script with a connection to the catalog ?
[code]
$ export ORACLE_SID=<auxiliary>
$ rman target / catalog rmanadmin/<password>@rcat
RMAN> run {
set until scn 1412841;
set newname for datafile n to '<newfilename_n>';
set newname for datafile n2 to '<newfilename_n2>';
….etc
restore datafile n,n2…etc;
}
[/code]
Rise to the challenge for Sport Relief with Yahoo! For Good
http://uk.promotions.yahoo.com/forgood/
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 17 2008 - 07:58:32 CDT