欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入 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 back
欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入
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;
restore                                                         --> 发布restore命令
clone database
;
}
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
starting restore at 2013/07/25 14:33:35                            -->开始数据文件的restore
using channel ora_aux_disk_1                                       -->根据控制文件的信息读取备份集并还原到set newname位置
channel ora_aux_disk_1: starting datafile backup set restore
channel ora_aux_disk_1: specifying datafile（s） to restore from backup set
channel ora_aux_disk_1: restoring datafile 00001 to /u01/database/sybo5/oradata/system01.dbf
channel ora_aux_disk_1: restoring datafile 00002 to /u01/database/sybo5/oradata/sysaux01.dbf
channel ora_aux_disk_1: restoring datafile 00003 to /u01/database/sybo5/oradata/undotbs01.dbf
channel ora_aux_disk_1: restoring datafile 00004 to /u01/database/sybo5/oradata/users01.dbf
channel ora_aux_disk_1: restoring datafile 00005 to /u01/database/sybo5/oradata/example01.dbf
channel ora_aux_disk_1: reading from backup piece /u01/database/sybo3/flash_recovery_area/sybo3/backupset/2013_07_25/
o1_mf_nnndf_tag20130725t083959_8z0wz06c_.bkp
channel ora_aux_disk_1: piece handle=/u01/database/sybo3/flash_recovery_area/sybo3/backupset/2013_07_25/
o1_mf_nnndf_tag20130725t083959_8z0wz06c_.bkp tag=tag20130725t083959
channel ora_aux_disk_1: restored backup piece 1
channel ora_aux_disk_1: restore complete, elapsed time: 00:01:15     -->完成数据文件restore
finished restore at 2013/07/25 14:34:50
contents of memory script:                                           -->下面的脚本将新的数据文件全部更新到控制文件
{
switch clone datafile all;
}
executing memory script
datafile 1 switched to datafile copy
input datafile copy recid=7 stamp=821716490 file name=/u01/database/sybo5/oradata/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=8 stamp=821716491 file name=/u01/database/sybo5/oradata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=9 stamp=821716491 file name=/u01/database/sybo5/oradata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=10 stamp=821716491 file name=/u01/database/sybo5/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=11 stamp=821716491 file name=/u01/database/sybo5/oradata/example01.dbf
contents of memory script:                                          -->下面的脚本oracle自动设置了scn后发布recover命令
{
set until scn  886687;
recover
clone database
delete archivelog
;
}
executing memory script
executing command: set until clause
starting recover at 2013/07/25 14:34:51    -->下面使用archivelog进行recover
using channel ora_aux_disk_1
starting media recovery
archived log for thread 1 with sequence 16 is already on disk as file /u01/database/sybo3/flash_recovery_area/sybo3/
archivelog/2013_07_25/o1_mf_1_16_8z16rk6o_.arc       -->此时运用到了一个sybo3已经存在的归档日志，sequence 为16
channel ora_aux_disk_1: starting archived log restore to default destination  -->接下来还原归档日志到缺省位置
channel ora_aux_disk_1: restoring archived log
archived log thread=1 sequence=15                      -->从备份的归档日志中读取 sequence为15 的
channel ora_aux_disk_1: reading from backup piece /u01/database/sybo3/flash_recovery_area/sybo3/backupset/2013_07_25/
o1_mf_annnn_tag20130725t084129_8z0x1syh_.bkp
channel ora_aux_disk_1: piece handle=/u01/database/sybo3/flash_recovery_area/sybo3/backupset/2013_07_25/
o1_mf_annnn_tag20130725t084129_8z0x1syh_.bkp tag=tag20130725t084129
channel ora_aux_disk_1: restored backup piece 1
channel ora_aux_disk_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/database/sybo5/flash_recovery_area/sybo5/archivelog/2013_07_25/o1_mf_1_15_8z1krh5x_.arc thread=1 sequence=15
channel clone_default: deleting archived log（s）      -->删除归档日志
[1] [2] [3] [4]