ORA-00392: log 1 of thread 1 is being cleared, operation not allowed | Oracle Database

The following opinions expressed in this post are my own and in no way connected to my employer. 

Issue:

While opening a Database if you run into below error, you can check and perform the following to overcome the error.

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

Solution:

Check the status of files:

select group#,thread#,status from v$log;

GROUP# THREAD# STATUS

 ---------- ---------- ----------------

 1 1 CLEARING_CURRENT

 2 1 CLEARING

 5 1 CLEARING

 4 1 CLEARING

 3 1 CLEARING

Run the below command to clear the logfile :

 alter database clear unarchived logfile group 1;