The status of a redo log group can be ____ if it is needed for crash recovery,but not currently in use by LGWR.
A) CURRENT
B) ACTIVE
C) CLEARING_CURRENT
D) CLEARING

Question

Quizplus · Accepted Answer

The status of a redo log group is marked as "ACTIVE" when it is needed for crash recovery but is not currently being written to by the Log Writer (LGWR). This indicates that the redo log contains information that is necessary to recover transactions in the event of a system crash, but it is not the current target for new redo entries.

The Status of a Redo Log Group Can Be ____