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

Last updated on APRIL 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
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

Yet 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 B:\BACKUPS_RECOVERY\FULL\MYDB\MYDB_FULL_1068296036_20130430_2928_1.BAK
Backup Set 726317 30-APR-13 
Backup Piece 726319 01-MAY-13 B:\BACKUPS_RECOVERY\ARCH\MYDB\C-1068296036-20130430-00
Backup Set 726462 30-APR-13 
Backup Piece 726464 01-MAY-13 B:\BACKUPS_RECOVERY\ARCH\MYDB\C-1068296036-20130430-01
Backup Set 727706 30-APR-13 
Backup Piece 727708 01-MAY-13 B:\BACKUPS_RECOVERY\ARCH\MYDB\C-1068296036-20130430-02

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