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

by

In this post we will cover how to fix ORA-00392 log of thread is being cleared, operation not allowed.

How to fix ORA-00392 log of thread is being cleared

ORA-00392 log of thread is being cleared
ORA-00392 log of thread is being cleared

Problem:-

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:

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

ORA-00312: online log 5 thread 1:

'/ORACLE/ORA_27_Datafiles/redotempfiles/log05a.dbf'

ORA-00312: online log 5 thread 1:

'/ORACLE/ORA_27_Datafiles/redotempfiles/log05b.dbf'

Solution:-

Check current status of logfile. We can see here redo logfile group 3,4 & 5 is showing as clearing. So we need to clear the unarchived logfile.
 
SQL> select group#, status from v$log;
 
    GROUP# STATUS
———- —————-
         3 CLEARING
         5 CLEARING_CURRENT
         4 CLEARING
 
SQL> alter database clear unarchived logfile group 3;
 
Database altered.
 
SQL>  alter database clear unarchived logfile group 5;
 
Database altered.
 
SQL>  alter database clear unarchived logfile group 4;
 
Database altered.
 
SQL>  select group#, status from v$log;
 
    GROUP# STATUS
———- —————-
         3 UNUSED
         5 CURRENT
         4 UNUSED
 
SQL> alter database open resetlogs;
 
Database altered.
 
SQL> select name ,open_mode from v$database;
 
NAME      OPEN_MODE
——— ——————–
PROD      READ WRITE
 
 

Useful Post: –

How to resolve ORA-19809 limit exceeded for recovery files 

ORA-00257 archiver error Connect internal only until freed fixed in best way. 

3 thoughts on “ORA-00392 log of thread is being cleared, operation not allowed.”

Leave a Comment