Oracle Error ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)

Oracle Error Message

ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)

Reason for the Error

Dropping all the logs specified would leave fewer than the required two log files per enabled thread.

Solution

Either drop fewer logs or disable the thread before deleting the logs. It may be possible to clear the log rather than drop it.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...