rman系列之BBED破坏，BlockRecover恢复的案例演示(三)
ring blocks of datafile 00004
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/EMREP/backupset/2012_12_17/o1_mf_nnndf_
TAG20121217T205237_8dy5dor3_.bkp
TAG20121217T205237_8dy5dor3_.bkp
channel ORA_DISK_1: restored block(s) from backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/EMREP/backupset/2012_12_17/o1_mf_
nnndf_TAG20121217T205237_8dy5dor3_.bkp tag=TAG20121217T205237
nnndf_TAG20121217T205237_8dy5dor3_.bkp tag=TAG20121217T205237
channel ORA_DISK_1: block restore complete, elapsed time: 00:00:02
starting media recovery
media recovery complete, elapsed time: 00:00:07
Finished blockrecover at 17-DEC-12
⑥ 数据验证： www.2cto.com
[sql]
sys@EMREP> conn u1/u1
Connected.
u1@EMREP> select * from t2;
B
----------
1
3
⑦ 注意事项：
BLOCKRECOVER DATAFILE 9 BLOCK 13 DATAFILE 2 BLOCK 19 RESTORE UNTIL
SCN 100;
BLOCKRECOVER语句中的UNTIL关键字不是表示不完全恢复
UNTIL的意思是指从特定的日期或SCN之前生成的备份中还原数据块（restore）
还原完成后还会应用与数据块相关的重做日志（recover）
⑧ 附上OCP-043考题
