基于RMAN的同机数据库克隆(五)
Oracle instance started
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 260049588 bytes
Database Buffers 109051904 bytes
Redo Buffers 6197248 bytes
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