How to fix the error ORA-00390: log string of thread string is being cleared, cannot become current log?

In this post, you’ll learn more about the Oracle ErrorORA-00390: log string of thread string is being cleared, cannot become current log with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00390: log string of thread string is being cleared, cannot become current log

Reason for the Error ORA-00390: log string of thread string is being cleared, cannot become current log

An attempt to switch to a new online log for the redo thread failed because no reusable log could be found. This log is being cleared and will be useable when the clearing completes. The command that began the clearing may have terminated without completing the clearing.

How to fix the Error ORA-00390: log string of thread string is being cleared, cannot become current log ?

You can fix this error in Oracle by following the below steps

If the clear command is still executing then wait for its completion. If it terminated then reissue the clear command, or drop the log.