My Oracle Support Banner

Report/Delete obsolete not reporting/deleting obsolete backups of Archivelog Files (Doc ID 1553261.1)

Last updated on APRIL 30, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Archivelog backups are not reported as obsolete and cannot be deleted

The list of backups show plenty of old archivelog backups:

RMAN> List backup of archivelog all summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
669493  B  A  A DISK        28-APR-13       1       1       YES        TAG20130428T080550
669494  B  A  A DISK        28-APR-13       1       1       YES        TAG20130428T080550
669495  B  A  A DISK        28-APR-13       1       1       YES        TAG20130428T080550
671019  B  A  A DISK        28-APR-13       1       1       YES        TAG20130428T090452
671020  B  A  A DISK        28-APR-13       1       1       YES        TAG20130428T090452
671021  B  A  A DISK        28-APR-13       1       1       YES        TAG20130428T090452

 

The retention policy has been set for a recovery window of 1 day:

RMAN> show retention policy;

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

There is registry of recent full backup:

RMAN> list backup of database summary;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
713567 B F A DISK 30-APR-13 1 1 YES TAG20130430T094101
726405 B F A DISK 01-MAY-13 1 1 YES TAG20130501T012110
738540 B F A DISK 02-MAY-13 1 1 YES TAG20130502T012043

REPORT OBSOLETE does not bring the list of archivelog backups prior to the recent database backups

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 713567 30-APR-13
Backup Piece 713584 30-APR-13 <path>\<backuppiece_name>
Backup Set 726317 30-APR-13 
Backup Piece 726319 01-MAY-13 <path>\<backuppiece_name>
Backup Set 726462 30-APR-13 
Backup Piece 726464 01-MAY-13 <path>\<backuppiece_name>
Backup Set 727706 30-APR-13 
Backup Piece 727708 01-MAY-13 <path>\<backuppiece_name>

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.