Oracle
1Z0-067 · Question #64
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is…
The correct answer is C. 2, 3, 4, 5. If the group is Current Then it is the log that the database is currently writing to And you should Attempt to clear the log; if impossible, then you must restore a backup and perform incomplete recovery up to the most recent available redo log.
New Features for Availability
Question
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location. 1.Restore the corrupted redo log group. 2.Restore the database from the most recent database backup. 3.Perform an incomplete recovery. 4.Relocate the member of the damaged online redo log group to a new location. 5.Open the database with the resetlogs option. 6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.
Options
- A1, 3, 4, 5
- B6, 3, 4, 5
- C2, 3, 4, 5
- D6, 4, 3, 5
How the community answered
(29 responses)- A7% (2)
- B3% (1)
- C72% (21)
- D17% (5)
Explanation
If the group is Current Then it is the log that the database is currently writing to And you should Attempt to clear the log; if impossible, then you must restore a backup and perform incomplete recovery up to the most recent available redo log.
Topics
#online redo log recovery#incomplete recovery#archivelog mode#resetlogs
Community Discussion
No community discussion yet for this question.