OCP-1Z0-053-V13.02-709题

最新推荐文章于 2018-09-30 11:44:54 发布

原创最新推荐文章于 2018-09-30 11:44:54 发布 · 7.9k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

OCP11g解析

OCP-1Z0-053

TK Errors

本文探讨了当Oracle数据库中一个活动状态的在线重做日志成员损坏时的首要应对措施。根据官方文档建议，首先应尝试发出检查点指令，并清除日志；如果无法实现，则需使用闪回数据库功能或恢复备份并进行不完整恢复。

709. A database has three online redo log groups wi th one member each. A redo log member with the

status ACTIVE is damages while the database is running.

What is the first step you should take to solve this problem?

A.Attempt to Issue a checkpoint.

B.Restart the database usi ng the RESETLOGS option.

C.Drop the redo log number and create it in a different location.

D.Perform and incomplete recovery up to the most recent available redo log.

Answer: C

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90049

根据官方文档，此题应该选A

Recovering After Losing All Members of an Online Redo Log Group

If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure and the archiving mode of the database.

If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not. Table 30-4 outlines the various recovery scenarios.

Table 30-4 Recovering After the Loss of an Online Redo Log Group

If the Group Is...	Then...	And You Should...
Inactive	It is not needed for crash recovery	Clear the archived or unarchived group.
Active	It is needed for crash recovery	Attempt to issue a checkpoint and clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.
Current	It is the redo log that the database is currently writing to	Attempt to clear the log; if impossible, then you must either use Flashback Database or restore a backup and perform incomplete recovery up to the most recent available redo log.