Multiple choice technology databases

Which of the following is the most serious type of redo log file failure?

  1. The loss of an entire redo log file group, but no loss in any other group

  2. The loss of one member of each redo log file group

  3. The failure of the ARC0 background process

  4. The failure of the LGWR background process
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Losing an entire redo log group means complete loss of that redo log data, which is the most serious failure. Losing one member from each group reduces redundancy but preserves data as long as at least one member per group remains.

Keep practicing — related questions