RMAN-08137 archived log not deleted, needed for standby or upstream capture process

 

When the “AVDF transaction log audit trail” is created and deleted, the archive logs cannot be deleted normally, depending on bug 23217905. The problem is corrected in version 12.2.0.0.

When trying to delete archivelog with RMAN, it gives warning as follows.

In this case, you must find the available capture process information from the DBA_CAPTURE view and delete these capture.

You can find the capture processes in the database as follows.

It should then be deleted using the existing capture name as follows.

The archive log will be deleted in the normal way after the drop.

dbtut
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 *