[每日一题] 11gOCP 1z0-053 :2013-10-14 普通文件损的最佳恢复步骤(二)

2014-11-24 16:24:37 · 作者: · 浏览: 2
to restore from backup set
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ocm/gyj02.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0/dbs/1eomgj63_1_1
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/11.2.0/dbs/1eomgj63_1_1 tag=TAG20131015T231619
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 15-OCT-13
(6) 开始恢复7号文件
[html]
RMAN> recover datafile 7;
Starting recover at 15-OCT-13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 15-OCT-13
(7) 正常打开数据库
[html]
RMAN> alter database open;
database opened
答案D不正确,在归档模式下,某一个文件坏了,归档日志、在线重做日志都是好的,那做完全恢复就可以了,做完全恢复,只要还原那一个损坏的文件和恢复它就Ok了,无须还原全部数据文件和恢复全部文件。