Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can you select a Different RMAN backup for DUPLICATE?

Re: Can you select a Different RMAN backup for DUPLICATE?

From: Avadhani mys <avadhanimys_at_gmail.com>
Date: Thu, 21 Jun 2007 12:52:49 +0530
Message-ID: <8b53b96c0706210022vc8c161dj7d69e2591609d519@mail.gmail.com>


Hi David,

If you want to use the other night backup you have to copy the the backup to the the machine where you are duplicating,

You can use the DB move option, that is set in init.ora (parameter file of the target instance)

In the target database parameter file add this at the last

                        SOURCE PATH                TARGET
PATH                    SOURCE PATH     TARGET PATH
db_file_name_convert='/u01/<SID>/oradata','/opt1/app/oracle9i/SID/oradata','/u02/SID/oradata','/opt2/app/oracle9i/SID/oradata' log_file_name_convert='/u01/oradata/SID/','/opt2/app/oracle9i/SID/oradata','/u02/oradata/SID/','/opt2/app/oracle9i/SID/oradata'

prepare script like this

connect catalog rman/manager@<catalouge Database> connect target sys/xxxxxxxxx@<PROD DBNAME> connect auxiliary /
run {
set until time "to_date('JUN 21 2007 22:00:00','Mon DD YYYY HH24:MI:SS')"; For Eg in the script..

save this file scripts.sql and run it like shown below rman @scrips.sql

and run the script in nohup mode

Let me know if you have doubt in setting set until time you have to login to rman repository database to check the data and time of completion of backup,

Regards,
Avadhani Mysoru,
Oracle Apps DBA.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 21 2007 - 02:22:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US