Starting restore at 2013/07/25 14:33:29 --->开始restore
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=134 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file --->首先restore controlfile
channel ORA_AUX_DISK_1: reading from backup piece /u01/database/sybo3/flash_recovery_area/SYBO3/autobackup/2013_07_25/
o1_mf_s_821695291_8z0x1vsf_.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/database/sybo3/flash_recovery_area/SYBO3/autobackup/2013_07_25/
o1_mf_s_821695291_8z0x1vsf_.bkp tag=TAG20130725T084131
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 -->controlfile restore完成
output file name=/u01/database/sybo5/controlf/control01.ctl -->output到的位置
output file name=/u01/database/sybo5/controlf/control02.ctl -->注意此时的控制文件中记录的信息依旧是sybo3的,即target db
Finished restore at 2013/07/25 14:33:30
database mounted -->数据库切换到mount状态,对应语句alter clone database mount
contents of Memory Script: -->这些SQL语句用于设置auxiliary db 数据文件位置
{
set until scn 886687; -->Oracle自动设定了相应的scn
set newname for datafile 1 to
"/u01/database/sybo5/oradata/system01.dbf";
set newname for datafile 2 to
"/u01/database/sybo5/oradata/sysaux01.dbf";
set newname for datafile 3 to
"/u01/database/sybo5/oradata/undotbs01.dbf";
set newname for datafile 4 to
"/u01/database/sybo5/oradata/users01.dbf";
set newname for datafile 5 to
"/u01/database/sybo5/oradata/example01.dbf";


热门课程培训
热门培训机构
