Oracle DUPLICATE复制数据库(七)
LDUP\GGTBS.DBF
channel ORA_AUX_DISK_1: reading from backup piece F:\BACKUP_4BNI4IV3_1_1
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=F:\BACKUP_4BNI4IV3_1_1 tag=TAG20120808T121323
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:06:16
Finished restore at 09-AUG-12
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLDUP" RESETLOGS ARCHIVE
LOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\REDO01.LOG' ) SIZE 50 M
REUSE,
GROUP 2 ( 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\REDO02.LOG' ) SIZE 50 M
REUSE,
GROUP 3 ( 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\REDO03.LOG' ) SIZE 50 M
REUSE
DATAFILE www.2cto.com
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM01.DBF'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=790863609 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\UNDOTBS2.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=790863609 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=790863610 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=790863610 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=790863611 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\ORADATA1.DBF www.2cto.com
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=790863611 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\ORADATA2.DBF
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=790863611 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\SYSTEM02.DBF
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=790863611 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\MYIDX01.DBF
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=790863611 filename=F:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCLDUP\UNDOTBS02.DBF
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=790863612 filename=F:\ORACLE\PRODUCT\10.2.0\O
RADATA\ORCLDUP\ASM_LMT.DBF
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=790863612 filename=F:\ORACLE\PRODUCT\10.2.0\O
RADATA\ORCLDUP\PERFSTAT.DBF
datafile 13 switched to datafile copy
input datafile copy recid=12 stamp=790863612 filename=F:\ORACLE\PRODUCT\10.2.0\O
RADATA\ORCLDUP\ORADATA3.DBF
datafile 14 switched to datafile copy
input datafile copy recid=13 stamp=790863612 filename=F:\ORACLE\PRODUCT\10.2.0\O
RADATA\ORCLDUP\STREAMS_TBS.DBF
datafile 15 switched to datafile copy
input datafile copy recid=14 stamp=790863612 filename=F:\ORACLE\PRODUCT\10.2.0\O
RADATA\ORCLDUP\ORCL\DATAFILE\O1_MF_USER123_81MTG1GN_.DBF
datafile 16