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

Got the below error during cloning. To fix this issue, need to “clear unarchived logfile group”

Solution :

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 4 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 4 thread 1: ‘/u02/oracle/oradata/PROD/redo04.log’

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

GROUP# THREAD# STATUS
——- ——— —————-
1 1 CLEARING
3 1 CLEARING
2 1 CLEARING
4 1 CLEARING_CURRENT

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> alter database open resetlogs;

Database altered