nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • B
    80% (20)
  • C
    4% (1)
  • D
    12% (3)
  • E
    4% (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.

Acurrent redo log and inactive 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.

Bcheckpoint position to end of redo logCorrect

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.

Cbeginning of redo log to end of redo log

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.

Dall redo logs before the point of last commit

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.

Ebeginning of redo log to checkpoint position

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

#instance recovery#checkpoint position#redo log#crash recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice