Oracle Database 12c: Installation and Administration — Question 18

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

Answer options

• A. All current, online, and archived redo logs are required to complete instance recovery.
• B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
• C. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
• D. All current, active, and inactive redo logs are required to complete instance recovery.

Correct answer: B

Explanation

Option B is correct because it accurately describes that during instance recovery, the redo log entries in the current and active logs are used to apply changes made after the last checkpoint. Options A and D are incorrect as they mention archived or inactive logs, which are not needed for this specific recovery. Option C is also incorrect because it does not include active logs, which are crucial for applying changes post-checkpoint.