1Z0-052 · Question #236
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?
The correct answer is B. checkpoint position to end of redo log. After an instance failure, Oracle's automatic crash recovery applies redo starting from the last checkpoint position and rolls forward to the end of the redo log.
Question
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?
Options
- Acurrent redo log and inactive redo log
- Bcheckpoint position to end of redo log
- Cbeginning of redo log to end of redo log
- Dall redo logs before the point of last commit
- Ebeginning of redo log to checkpoint position
How the community answered
(25 responses)- B80% (20)
- C4% (1)
- D12% (3)
- E4% (1)
Why each option
After an instance failure, Oracle's automatic crash recovery applies redo starting from the last checkpoint position and rolls forward to the end of the redo log.
Describing recovery as spanning from the current redo log to an inactive redo log confuses redo log file activity states with the actual recovery range, which is defined by the checkpoint SCN position.
During crash recovery, Oracle uses the checkpoint position - the SCN at which all prior committed changes are guaranteed to be written to the datafiles - as the starting point for redo application. Recovery then rolls forward through all redo log entries up to the last record written before the failure, restoring all in-memory changes that had not yet been written to the datafiles at the time of the outage.
Beginning recovery from the very start of the redo log is incorrect because all changes before the checkpoint position are already safely persisted to the datafiles and do not need to be reapplied.
Recovery does not stop at the last committed transaction - Oracle rolls forward all redo including uncommitted changes, then performs a separate rollback phase to undo uncommitted transactions using undo segments.
This reverses the correct direction: recovery proceeds from the checkpoint position forward to the end of the redo log, not from the beginning of the redo log backward to the checkpoint position.
Concept tested: Oracle instance crash recovery - checkpoint position to end of redo log
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/oracle-database-instance.html
Topics
Community Discussion
No community discussion yet for this question.