Friday, June 5, 2015

Database open resetlogs fails with ORA-00392: log X of thread Y is being cleared, operation not allowed

I encountered this error when during point in time recovery the server i run out of space.

When i freed up some space and tried to pen the database with the resetlogs clause i got ORA-00392:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 3 thread 1:
'/aux/AUX/onlinelog/o1_mf_3_%u_.log'
ORA-00312: online log 3 thread 1:
'/aux/fra/AUX/onlinelog/o1_mf_3_%u_.log'

This happened because at the time that DB was trying to clear and archive the online logs (after the open resetlogs command) the server run out of space and operation did not completed successfully.

After releasing space on the server the solution is the following :

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database open resetlogs;

Database altered.


No comments:

Post a Comment