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.
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)- A14% (3)
- B9% (2)
- C73% (16)
- D5% (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.
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.
Instance recovery uses only online redo log files, not archived redo logs - archived logs are needed for media recovery, not instance (crash) recovery.
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.
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
Community Discussion
No community discussion yet for this question.