Re: RMAN Duplicate Fails - Suggestions?

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Mon, 17 Mar 2008 11:06:35 +0000 (GMT)
Message-ID: <300277.67034.qm@web27801.mail.ukl.yahoo.com>

Hi

I am not sure if you found a solution.
But before running the restore commands below you should restore the controlfile/pfile on to the auxillary db ,mount the the auxillary db and run the script below.

[code]
$ export ORACLE_SID=<auxiliary>
$ rman target /

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-l

Received on Mon Mar 17 2008 - 06:06:35 CDT