代码改变世界

1Z0-053 争议题目解析607

2016-03-15 10:22  AlfredZhao  阅读(692)  评论(0编辑  收藏  举报

1Z0-053 争议题目解析607

考试科目:1Z0-053
题库版本:V13.02

题库中原题为:

607.Examine the following scenario:
-Database is running in ARCHIVELOG mode.
-Complete consistent backup is taken every Sunday.
-On Tuesday the instance terminates abnormally because the disk on which control files are located gets
corrupted
The disk having active online redo log files is also corrupted.
The hardware is repaired and the paths for online redo log files and control files are still valid. Which
option would you use to perform the recovery of database till the point of failure?
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the
RESETLOGS option.
C. Restore the latest backups control file, perform complete recovery, and open the database with the
RESETLOGS option.
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open
the database with the RESETLOG option.
Answer: D

争议点:
网上有人说选择B,
比如:
LuiseDalian的解析:http://blog.itpub.net/17013648/viewspace-1326753/

如果是控制文件和active online redo文件损坏,那么oracle只能做不完全恢复,
做不完全恢复就必须把最近备份的整个数据库转储出来,然后做recovery,恢复的失败的那一点。

也有遵循题库的答案解析,选择D:
比如:
Riveore的解析:http://blog.csdn.net/rlhua/article/details/14649045

戴总整理的题库此题也是D选项。

争议点在于,做不完全恢复,是否一定需要把最近的整个数据库转储出来;

初步结论:
保留争议,暂时选择B。