ORACLE Error “log X of thread X is being cleared, operation not allowed”

If you are getting an error message like “log X of thread X is being cleared, operation not allowed” while trying to reset your database logs especially after database copy operations then you can use the “clear unarchived logfile group” option to solve the issue..

You can follow the example situation below ;

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: ‘E:\ORACLE\SID\ORIGLOGA\LOG_G13M1.DBF’
ORA-00312: online log 3 thread 1: ‘Y:\ORACLE\SID\MIRRLOGA\LOG_G13M2.DBF’

clearloggroup_01

SQL> select status from v$log where GROUP#=3
2  ;

STATUS
—————-
CLEARING_CURRENT

clearloggroup_02

SQL> alter database clear unarchived logfile group 3;

Database altered.

clearloggroup_03

SQL> alter database open resetlogs;

Database altered.

clearloggroup_04

 

 

Leave a Reply


eight − = 5

Blogroll

  • SAP Basis TURKEY