How to fix the Oracle error ORA-01623: log string is current log for instance string (thread string) – cannot drop?

In this post, you’ll learn more about the Oracle ErrorORA-01623: log string is current log for instance string (thread string) – cannot drop with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01623: log string is current log for instance string (thread string) – cannot drop

Reason for the Error ORA-01623: log string is current log for instance string (thread string) – cannot drop

A thread’s current log cannot be dropped even if the thread is closed. A disabled thread usually does not have a current log, but a half completed disable may need to be disabled again.

How to fix the Error ORA-01623: log string is current log for instance string (thread string) – cannot drop ?

You can fix this error in Oracle by following the below steps

If the database is not open then disable the thread. If the database is open and an instance has the thread open, then the instance can be requested to switch logs. If the database is closed the log can be archived or cleared to force a switch.