基于RMAN的同机数据库克隆(六)
/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) -->
删除归档日志
archived log file name=/u01/database/sybo5/flash_recovery_area/SYBO5/archivelog/2013_07_25/o1_mf_1_15_8z1krh5x_.arc RECID=12 STAMP=821716495
archived log file name=/u01/database/sybo3/flash_recovery_area/SYBO3/archivelog/2013_07_25/o1_mf_1_16_8z16rk6o_.arc thread=1 sequence=16
media recovery complete, elapsed time: 00:00:04 -->介质恢复完成
Finished recover at 2013/07/25 14:35:00
contents of Memory Script: -->下面的脚本用于还原恢复之后的后续工作
{ -->包括重新设置db_name,db_unique_name
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''SYBO5'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
database dismounted
Oracle instance shut down
--Author: Robinson
--Blog : http://blog.csdn.net/robinson_0612
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 376635392 bytes
Fixed Size 1336652 b