ANKUSH THAVALI21 Dec, 20230 Comments43 Secs ReadORA-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 Oracle DBAShare: ORA-00350: Log 4 Of Instance Needs To Be ArchivedORA-01536: Space Quota Exceeded For Tablespace