- 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 :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | RMAN> select group#,thread#,status from v$log;GROUP# THREAD# STATUS---------- ---------- ----------------5 1 CLEARING6 1 CLEARING7 1 CLEARING_CURRENT ---------->>>8 1 CLEARING9 2 CLEARING_CURRENT 10 2 CLEARING11 2 CLEARING12 2 CLEARING[php]Group 7 and 9 have status CLEARING_CURRENT. So clear them manually.[php]RMAN> alter database clear logfile group 7;Statement processedRMAN> alter database clear logfile group 9;Statement processedRMAN> select group#,thread#,status from v$log;GROUP# THREAD# STATUS---------- ---------- ----------------5 1 CLEARING6 1 CLEARING7 1 CURRENT8 1 CLEARING9 2 CURRENT10 2 CLEARING11 2 CLEARING12 2 CLEARING8 rows selected |
1 2 3 | RMAN> alter database open resetlogs;Database altered |