Oracle DUPLICATE复制数据库(八)
switched to datafile copy
input datafile copy recid=15 stamp=790863613 filename=F:\ORACLE\PRODUCT\10.2.0\O
RADATA\ORCLDUP\GGTBS.DBF
contents of Memory Script:
{
set until scn 9085645;
recover
clone database
delete archivelog
; www.2cto.com
}
executing Memory Script
executing command: SET until clause
Starting recover at 09-AUG-12
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=35 devtype=DISK
starting media recovery
archive log thread 1 sequence 266 is already on disk as file C:\DATAGUARD\DEMO\O
RCL\ARCHIVELOG\LOG1_266_784480114.ARC
archive log thread 1 sequence 267 is already on disk as file C:\DATAGUARD\DEMO\O
RCL\ARCHIVELOG\LOG1_267_784480114.ARC
archive log thread 1 sequence 268 is already on disk as file C:\DATAGUARD\DEMO\O
RCL\ARCHIVELOG\LOG1_268_784480114.ARC
archive log filename=C:\DATAGUARD\DEMO\ORCL\ARCHIVELOG\LOG1_266_784480114.ARC th
read=1 sequence=266
archive log filename=C:\DATAGUARD\DEMO\ORCL\ARCHIVELOG\LOG1_267_784480114.ARC th
read=1 sequence=267
archive log filename=C:\DATAGUARD\DEMO\ORCL\ARCHIVELOG\LOG1_268_784480114.ARC th
read=1 sequence=268
media recovery complete, elapsed time: 00:00:28
Finished recover at 09-AUG-12
contents of Memory Script:
{ www.2cto.com
shutdown clone;
startup clone nomount ;
}
executing Memory Script
最后以OPEN RESETLOGS方式打开数据库，复制完成。
contents of Memory Script:
{
Alter clone database open;
}
executing Memory Script
database opened
5.验证结果
SQL>CONN SYSTEM/LYN@ORCLDUP
ORCLDUP>select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
EXAMPLE
MYSPACE
MYINDEX
UNDOTBS2
ASM_LMT_TS
PERFSTAT
STREAMS_TBS
NAME
------------------------------
USER123
GG_TBS
TEMP
14 rows selected.
ORCLDUP>select name from v$datafile;
NAME www.2cto.com
--------------------------------------------------------------------------------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\UNDOTBS2.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSAUX01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\USERS01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\EXAMPLE01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA1.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA2.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM02.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\MYIDX01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\UNDOTBS02.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ASM_LMT.DBF
NAME
--------------------------------------------------------------------------------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\PERFSTAT.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA3.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\STREAMS_TBS.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORCL\DATAFILE\O1_MF_USER123_81MTG1GN_.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\GGTBS.DBF
16 rows selected.
OK,表空间和数据文件都有了，创建成功。
四、复制过程中的一些高级选项
1.跳过表空间：跳过只读表空间，只需要在DUPLICATE梦里时指定SKIP READONLY子句，