ALTER DATABASE OPEN RESETLOGS fails with ORA-00392 (Doc ID 1352133.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Information in this document applies to any platform.


After a RESTORE/RECOVER for cloning a database, the following error appears while open the clone database:

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: '/data/oradata/clone/group_1.log'
ORA-00312: online log 1 thread 1: '/data/oradata/clone/group_12.log'


Cloned a database by RESTORE/RECOVER.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms