DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, April 13, 2015

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

ORA-00392 This Error may occur when you attemp to drop the current redo logfile after cloning.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '/d01/TEST/db/apps_st/data/log1a'
ORA-00312: online log 1 thread 1: '/d01/TEST/db/apps_st/data/log1b'

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

    GROUP#  SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
         1          0 NO  CLEARING_CURRENT
         3          0 YES CLEARING
         2          0 YES CLEARING

SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database open resetlogs;

Database altered.





No comments: