ORA-00392: log 1 of thread 1 is being cleared

0

Database recovery issue

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
SQL> select group#,thread#,status from v$log;

GROUP# THREAD# STATUS
——- ——— —————-
1 1 CLEARING_CURRENT
3 1 CLEARING
2 1 CLEARING

alter database clear unarchived logfile group 1;

Share.

About Author

Leave A Reply

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.