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


Error:

While cloning the database and opening in reset log we might encounter below error.

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/TEST/redo4.log’


Solution :


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




If you like please follow and comment