rman target sys/abc123@ibpausa1 catalog rman/rman_oncdbmp@rmanmna2 auxiliary /
run
{
set until time "to_date('30-APR-2010 05:30','DD-MON-YYYY hh24:MI')";
allocate auxiliary channel C1 device type disk;
SET NEWNAME FOR DATAFILE 1 to '/oracle/data/dbpa/usa1/vol30/dbpausa1.system.a001.dbf';
SET NEWNAME FOR DATAFILE 2 to '/oracle/data/dbpa/usa1/vol40/dbpausa1.undo.a001.dbf';
SET NEWNAME FOR DATAFILE 3 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.sbpa0001.a001.dbf';
SET NEWNAME FOR DATAFILE 4 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.users.a001.dbf';
SET NEWNAME FOR DATAFILE 5 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.tools.a001.dbf';
SET NEWNAME FOR DATAFILE 6 to '/oracle/data/dbpa/usa1/vol11/dbpausa1.sbpa0002.a001.dbf';
SET NEWNAME FOR DATAFILE 7 to '/oracle/data/dbpa/usa1/vol20/dbpausa1.xbpa0001.a001.dbf';
SET NEWNAME FOR DATAFILE 9 to '/oracle/data/dbpa/usa1/vol11/dbpausa1.sbpa0002.a002.dbf';
SET NEWNAME FOR DATAFILE 10 to '/oracle/data/dbpa/usa1/vol11/dbpausa1.sbpa0002.a003.dbf';
SET NEWNAME FOR DATAFILE 11 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.sysaux.a001.dbf';
SET NEWNAME FOR TEMPFILE 1 to '/oracle/data/dbpa/usa1/vol50/dbpausa1.tps00001.a001.dbf';
duplicate target database to dbpausa1;
}
log_file_name_convert =("/oracle/data/ibpa/usa1/", "/oracle/data/dbpa/usa1/")
db_file_name_convert =("/oracle/data/ibpa/usa1/", "/oracle/data/dbpa/usa1/")
ORACLE noteid's:
Note 228257.1 - RMAN 'Duplicate Database' Feature in Oracle9i / Oracle 10G
Note 259694.1 - Oracle10G RMAN Database Duplication
Bug 5327865 - CLONING THE DB USING 10G OEM "SEARCH FOR HOST" RESULTS IN (NO ITEMS FOUND)
run
{
set until time "to_date('30-APR-2010 05:30','DD-MON-YYYY hh24:MI')";
allocate auxiliary channel C1 device type disk;
SET NEWNAME FOR DATAFILE 1 to '/oracle/data/dbpa/usa1/vol30/dbpausa1.system.a001.dbf';
SET NEWNAME FOR DATAFILE 2 to '/oracle/data/dbpa/usa1/vol40/dbpausa1.undo.a001.dbf';
SET NEWNAME FOR DATAFILE 3 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.sbpa0001.a001.dbf';
SET NEWNAME FOR DATAFILE 4 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.users.a001.dbf';
SET NEWNAME FOR DATAFILE 5 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.tools.a001.dbf';
SET NEWNAME FOR DATAFILE 6 to '/oracle/data/dbpa/usa1/vol11/dbpausa1.sbpa0002.a001.dbf';
SET NEWNAME FOR DATAFILE 7 to '/oracle/data/dbpa/usa1/vol20/dbpausa1.xbpa0001.a001.dbf';
SET NEWNAME FOR DATAFILE 9 to '/oracle/data/dbpa/usa1/vol11/dbpausa1.sbpa0002.a002.dbf';
SET NEWNAME FOR DATAFILE 10 to '/oracle/data/dbpa/usa1/vol11/dbpausa1.sbpa0002.a003.dbf';
SET NEWNAME FOR DATAFILE 11 to '/oracle/data/dbpa/usa1/vol10/dbpausa1.sysaux.a001.dbf';
SET NEWNAME FOR TEMPFILE 1 to '/oracle/data/dbpa/usa1/vol50/dbpausa1.tps00001.a001.dbf';
duplicate target database to dbpausa1;
}
log_file_name_convert =("/oracle/data/ibpa/usa1/", "/oracle/data/dbpa/usa1/")
db_file_name_convert =("/oracle/data/ibpa/usa1/", "/oracle/data/dbpa/usa1/")
ORACLE noteid's:
Note 228257.1 - RMAN 'Duplicate Database' Feature in Oracle9i / Oracle 10G
Note 259694.1 - Oracle10G RMAN Database Duplication
Bug 5327865 - CLONING THE DB USING 10G OEM "SEARCH FOR HOST" RESULTS IN (NO ITEMS FOUND)
No comments:
Post a Comment