Rman-08137: Warning: Archive Log Not Deleted As It Is Still Needed Rman-08137 (Doc ID 374421.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-May-2015***

Symptoms

RMAN command 'backup archivelog all delete input' does not delete archivelogs after they have been backed up and issues a warning instead:

RMAN-08137: WARNING: archive log not deleted as it is still needed
archive log filename=/ora03/oraflsh/RMANCCB/1_3740_580667843.dbf thread=1
sequence=3740


The database is part of  a Data Guard configuration and the backup is being run at the Primary database site.  Atlhough the archivelogs are backed up they are not deleted so the archivelog directory is in danger of filling up - if this happens the database will hang as it will not be able to archive any more logs.

New or 'current' archivelogs are being shipped to the Standby site successfully.

If you query v$archived_log on the primary , you will find at least one archivelog with APPLIED=NO:

alter session set nls_date_format='dd-mon-rr hh24:mi:ss';
select recid, dest_id, thread#, sequence#, first_time, completion_time, creator, registrar, archived, applied, deleted, status from v$archived_log where standby_dest='YES' and status='A';

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms