Sunday, August 10, 2014

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


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:
'/u01/oracle/PROD/db/apps_st/data/log01a.dbf'
ORA-00312: online log 1 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log01b.dbf'

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

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

SQL> alter database clear logfile group 1;
          Database altered.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 2 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 2 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log02a.dbf'
ORA-00312: online log 2 thread 1:
'/u01/oracle/PROD/db/apps_st/data/log02b.dbf'

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

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

SQL> alter database clear logfile group 2;
          Database altered.

SQL> alter database open resetlogs;

No comments:

Post a Comment