Oracle Database 12c: Advanced Administration — Question 104

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.

Answer options

Correct answer: C

Explanation

The correct answer is C because you must first restore the database from the latest backup to have a consistent state before performing an incomplete recovery, which allows you to apply any necessary changes up to the point of failure. Steps 1, 4, 5, and 6 are not relevant at this stage as they do not follow the correct recovery sequence needed to address the media failure.