Oracle DUPLICATE复制数据库(六)
RODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA2.DBF";
set newname for datafile 8 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM02.DBF";
set newname for datafile 9 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\MYIDX01.DBF";
set newname for datafile 10 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\UNDOTBS02.DBF";
set newname for datafile 11 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ASM_LMT.DBF";
set newname for datafile 12 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\PERFSTAT.DBF";
set newname for datafile 13 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA3.DBF";
set newname for datafile 14 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\STREAMS_TBS.DBF";
set newname for datafile 15 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORCL\DATAFILE\O1_MF_USER123_81MTG1GN_
.DBF";
set newname for datafile 16 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\GGTBS.DBF";
restore
check readonly
clone database
;
} www.2cto.com
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 09-AUG-12
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM01.DBF
restoring datafile 00002 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\UNDOTBS2.DBF
restoring datafile 00003 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSAUX01.DBF
restoring datafile 00004 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\USERS01.DBF
restoring datafile 00005 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\EXAMPLE01.DBF
restoring datafile 00006 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA1.DBF
restoring datafile 00007 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA2.DBF
restoring datafile 00008 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM02.DBF
restoring datafile 00009 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\MYIDX01.DBF
restoring datafile 00010 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\UNDOTBS02.DBF
restoring datafile 00011 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ASM_LMT.DBF
restoring datafile 00012 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\PERFSTAT.DBF
restoring datafile 00013 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA3.DBF
restoring datafile 00014 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\STREAMS_TBS.DBF
restoring datafile 00015 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORCL\DATAFI
LE\O1_MF_USER123_81MTG1GN_.DBF www.2cto.com
restoring datafile 00016 to F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC