Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 | RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process |
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.
1 2 3 4 5 | SQL> select CAPTURE_NAME, CAPTURE_TYPE, STATUS from DBA_CAPTURE; CAPTURE_NAME CAPTURE_TY STATUS ------------------------------ ---------- -------- AV$CAPTURE_1 LOCAL DISABLED |
It should then be deleted using the existing capture name as follows.
1 2 3 | SQL> exec dbms_capture_adm.drop_capture('AV$CAPTURE_1'); PL/SQL procedure successfully completed. |
The archive log will be deleted in the normal way after the drop.
