本文探讨了当数据库运行过程中一个包含单一成员的在线重做日志组成员处于活动状态并遭到破坏时的处理步骤。文章指出首先应尝试发出检查点指令，并详细解释了在不同情况下针对受损日志的不同恢复策略。
QUESTION 169
A database has three online redo log groups with one member each. A redo log member with the status
ACTIVE is damaged 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 using the Resetlogs Option.
C. Drop the redo log member and create it in a different location.
Section: (none)
Explanation
Explanation/Reference:
Recovering After the Loss of 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 : 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.
A database has three online redo log groups with one member each. A redo log member with the status
ACTIVE is damaged 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 using the Resetlogs Option.
C. Drop the redo log member and create it in a different location.
D. Perform an Incomplete recovery up to the most recent available redo log
Section: (none)
Explanation
Explanation/Reference:
Recovering After the Loss of 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 : 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.
扫一扫
805
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
