A database has three online redo log groups with 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 using 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.
Explanation:
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.
Recovering After the Loss of an Online Redo Log Group
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.