Oracle Database 12c: Advanced Administration — Question 107

Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

Answer options

• A. from the last complete checkpoint position
• B. from the beginning of the current redo log file until the instance failure
• C. from the last committed transaction
• D. from the beginning of the current redo log file to the checkpoint position
• E. from the most recent incremental checkpoint

Correct answer: A

Explanation

The recovery process begins from the last complete checkpoint position to ensure that all committed transactions are recovered without any data loss. The other options either start recovery from points that do not guarantee consistency or do not align with how databases manage redo logs during recovery.