Multiple choice technology databases

Redo log buffer data is used for recovery.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The redo log buffer is a volatile memory area in the SGA that holds redo entries temporarily before they are written to disk. On instance failure, the contents of the redo log buffer are lost. Recovery uses the online redo log FILES (on disk) and archived redo logs, not the buffer contents. The buffer is just a staging area, not a recovery source.