The status of a redo log group can be CLEARING_CURRENT if it is in the process of being re-created after the ALTER DATABASE CLEAR LOGFILE command has been used.

Question

Quizplus · Accepted Answer

The status of a redo log group becomes "CLEARING_CURRENT" when Oracle is in the process of clearing (erasing) the redo log file contents to allow their reuse, not specifically due to being re-created after the ALTER DATABASE CLEAR LOGFILE command. This status typically occurs during a log switch when Oracle needs to clear the current log group before it can be reused. The ALTER DATABASE CLEAR LOGFILE command is used to clear a specific log file or group that is not currently in use, and the status you might see could be "CLEARING" or "UNUSED" depending on the situation, but "CLEARING_CURRENT" specifically refers to the automatic clearing process during normal database operation.

The Status of a Redo Log Group Can Be CLEARING_CURRENT