nerdexam
Oracle

1Z0-052 · Question #1

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

The correct answer is C. All redo log entries after the last checkpoint are applied from redo log files to data files. During Oracle instance recovery after a crash, the database rolls forward by applying all redo entries recorded after the last checkpoint to bring data files to a consistent state.

Performing Backup and Recovery

Question

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

Options

  • AInactive and current redo log files are required to accomplish recovery
  • BOnline and archived redo files are required to accomplish instance recovery
  • CAll redo log entries after the last checkpoint are applied from redo log files to data files
  • DAll redo log entries recorded in the current log file until the checkpoint position are applied to data files

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    9% (2)
  • C
    73% (16)
  • D
    5% (1)

Why each option

During Oracle instance recovery after a crash, the database rolls forward by applying all redo entries recorded after the last checkpoint to bring data files to a consistent state.

AInactive and current redo log files are required to accomplish recovery

Only the current redo log file and any online redo log groups written after the last checkpoint are needed for instance recovery, not all inactive redo log files indiscriminately.

BOnline and archived redo files are required to accomplish instance recovery

Instance recovery uses only online redo log files, not archived redo logs - archived logs are needed for media recovery, not instance (crash) recovery.

CAll redo log entries after the last checkpoint are applied from redo log files to data filesCorrect

When an instance crashes, Oracle performs automatic instance recovery using the online redo logs. The recovery process applies all redo log entries generated after the last checkpoint - these are changes that were in the buffer cache but not yet flushed to data files - to roll the data files forward to the crash point, then rolls back any uncommitted transactions.

DAll redo log entries recorded in the current log file until the checkpoint position are applied to data files

Redo entries before the checkpoint position have already been written to data files by the checkpoint process, so only entries AFTER the checkpoint must be applied, not entries up to it.

Concept tested: Oracle instance crash recovery using redo logs and checkpoints

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

Topics

#instance recovery#redo log files#checkpoint#crash recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice