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.
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)- A93% (27)
- C3% (1)
- D3% (1)
Why each option
This question focuses on the role of redo log files during the instance recovery process in an Oracle database.
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.
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.
Inactive redo logs are already archived and are typically not directly required for instance recovery; instance recovery primarily relies on the online redo logs.
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
Community Discussion
No community discussion yet for this question.