In this post, you’ll learn more about the Oracle ErrorORA-01567: dropping log string would leave less than 2 log files for instance string (thread string) with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)
Reason for the Error ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)
Dropping all the logs specified would leave fewer than the required two log files per enabled thread.
How to fix the Error ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string) ?
You can fix this error in Oracle by following the below steps
Either drop fewer logs or disable the thread before deleting the logs. It may be possible to clear the log rather than drop it.