1Z0-053 争议题目解析502
2016-03-14 16:46 AlfredZhao 阅读(587) 评论(0) 编辑 收藏 举报1Z0-053 争议题目解析502
考试科目:1Z0-053
题库版本:V13.02
题库中原题为:
502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group
has one member.
A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log
file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a
current redo log group member in the random order are as follow.
- Restore the corrupted redo log group.
- Restore from a whole database backup.
- Perform incomplete recovery.
- Relocate by renaming the member of the damaged online redo log group to a new location.
- Open the database with the RESETLOGS option.
- Restart the database instance.
- Issue a checkpoint and clear the log.
Identify the option with the correct sequential steps to accomplish the task efficiently.
A. 1, 3, 4, and 5
B. 7, 3, 4. and 5
C. 2, 3, 4, and 5
D. 7, 4, 3. and 5
E. Only 6 is required
Answer: B
争议点:
网上有人说应该选择C,可以看到两个选项的区别就是第一个步骤;
如果说当发生redo日志损坏,首先应该考虑做的操作是
7) Issue a checkpoint and clear the log.
还是
2) Restore from a whole database backup.
那无疑是7. 如果执行7能成功,就只需要做一次备份就好了。
但是如果7不成功,即已经无法执行检查点,清空日志的话,那么不完全恢复就得需要先恢复一份备份,再进行不完全恢复。
而这里,给出的选项都是最终resetlogs了,那么应该选择C选项更合适。
Riveore给的解析是B选项,
http://blog.csdn.net/rlhua/article/details/19603095
戴总整理的题库是C选项。
初步结论:
保留争议,暂时选择C。