nerdexam
Oracle

1Z0-062 · Question #202

Which statement is true about redo log files during instance recovery?

The correct answer is C. All redo log entries in the current log are applied to data files until the checkpoint position is. During Oracle instance recovery, only online redo log entries from the last checkpoint position forward through the current log are applied - archived logs and inactive logs are not required.

Managing the Database Instance

Question

Which statement is true about redo log files during instance recovery?

Options

  • AAll current, active, and inactive redo logs are required to complete instance recovery.
  • BAll redo log entries in the current and active logs are applied to the data files to reconstruct
  • CAll redo log entries in the current log are applied to data files until the checkpoint position is
  • DAll current, online, and archived redo logs are required to complete instance recovery.

How the community answered

(26 responses)
  • A
    4% (1)
  • C
    88% (23)
  • D
    8% (2)

Why each option

During Oracle instance recovery, only online redo log entries from the last checkpoint position forward through the current log are applied - archived logs and inactive logs are not required.

AAll current, active, and inactive redo logs are required to complete instance recovery.

Inactive redo logs contain changes that have already been written past the checkpoint to data files, making them unnecessary for instance recovery; only current and active online redo logs are required.

BAll redo log entries in the current and active logs are applied to the data files to reconstruct

Applying all entries in both current and active logs regardless of checkpoint would be incorrect - only entries at or after the most recent checkpoint SCN are needed, as earlier changes are already durably reflected in the data files.

CAll redo log entries in the current log are applied to data files until the checkpoint position isCorrect

Instance recovery applies redo log entries starting from the last recorded checkpoint SCN and rolls forward through the current online redo log to reconstruct committed but unflushed changes. The checkpoint position defines exactly where recovery must begin, and because all changes prior to that point are already written to data files, only the current (and active) online redo logs are needed - archived redo logs are not required for crash recovery.

DAll current, online, and archived redo logs are required to complete instance recovery.

Archived redo logs are used for media recovery when restoring from a backup, not for instance (crash) recovery, which is entirely handled by the online redo log groups.

Concept tested: Oracle instance recovery using online redo logs and checkpoint position

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/oracle-database-instance.html

Topics

#redo log files#instance recovery#checkpoint position

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice