nerdexam
Oracle

1Z0-062 · Question #322

Which statement is true redo log files during instance recovery?

The correct answer is A. All redo log entries in the current log are applied to data files until the checkpoint position is. This question focuses on the role of redo log files during the instance recovery process in an Oracle database.

Performing Backup and Recovery

Question

Which statement is true redo log files during instance recovery?

Options

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

How the community answered

(29 responses)
  • A
    93% (27)
  • C
    3% (1)
  • D
    3% (1)

Why each option

This question focuses on the role of redo log files during the instance recovery process in an Oracle database.

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

During instance recovery, Oracle performs a 'roll forward' operation where it applies all redo log entries from the online redo log files starting from the last successful checkpoint position. This ensures that all committed changes, and even uncommitted changes, are restored to the data files, bringing the database to a consistent state from the point of failure.

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

While current and active logs are used, the statement is not as precise as option A regarding starting from the checkpoint position to apply changes.

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

Inactive redo logs are already archived and are typically not directly required for instance recovery; instance recovery primarily relies on the online redo logs.

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

Archived redo logs are used for media recovery (restoring from backups), not for instance recovery which uses online redo logs to roll forward changes since the last checkpoint.

Concept tested: Oracle instance recovery and redo logs

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/database-recovery.html#GUID-A915C9C8-C7B4-4D6F-97E5-680F08B9F28D

Topics

#Redo Log Files#Instance Recovery#Checkpoint

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice