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

Problem :-ORA-00392 log 5 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 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:-

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

2 comments:

Exclusiveinn said...

yeah I am agree with your points you discussed. I know the importance of oracle that is the reason I am getting Oracle online training

Aamir said...

Awesome, save my a lot of time

Post a Comment

Thanks for reading till end. I hope this will help you more to improve your knowledge.

Now it's your turn!

What do you think? Share your experience in the comments box and subscribe for more interesting post.