ORA-01567 Error During Redo Log Group Drop Operation


If we are trying to drop the redo log group created for a thread that is active and if the drop operation of redo log groups would leave less than 2 redo log files for instance, the drop process of the redo log groups will give an ORA-01567 error.

The possible error will be as follows.

After making sure that the instance in which redo log group is used is closed, the redo log group will be dropped when this thread is disabled.

Querying threads:

If the instance with thread number 4 is closed but the thread is still active, it can be seen from the query above.

In this case, we have to disable the thread of the instance we closed.

After that, the drop process of the redo log created for the relevant thread will be completed successfully.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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