ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed.
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.
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 selectedNow no group is in clearing_current mode. Lets do resetlog again.
RMAN> alter database open resetlogs; Database altered