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’

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

STATUS
—————-
CLEARING_CURRENT

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database open resetlogs;

Database altered.