ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 21 Dec, 2023
  • 0 Comments
  • 43 Secs Read

ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed

ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed.

Problem :

I was cloning a database from RMAN backup. After completion of cloning, when I tried to open database with  RESETLOG it failed with ORA-00392 error.

Solution :

RMAN> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
5 1 CLEARING
6 1 CLEARING
7 1 CLEARING_CURRENT ---------->>>
8 1 CLEARING
9 2 CLEARING_CURRENT 
10 2 CLEARING
11 2 CLEARING
12 2 CLEARING
[php]
Group 7 and 9 have status CLEARING_CURRENT. So clear them manually.
[php]
RMAN> alter database clear logfile group 7;

Statement processed

RMAN> alter database clear logfile group 9;

Statement processed

RMAN> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
5 1 CLEARING
6 1 CLEARING
7 1 CURRENT
8 1 CLEARING
9 2 CURRENT
10 2 CLEARING
11 2 CLEARING
12 2 CLEARING

8 rows selected
Now no group is in clearing_current mode. Lets do resetlog again.
RMAN> alter database open resetlogs;

Database altered