RMAN Delete Obsolete Command Deletes Archivelog Backups Inside Retention Policy (Doc ID 734323.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.4 to 11.1.0.6 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 17-May-2013***


Symptoms

RMAN report/delete obsolete command if run in NOCATALOG mode will report some archivelog backups that are INSIDE the
retention policy as obsolete if :

No catalog being used
Control_file_record_keep_time is < configured retention policy
Records in V$backup_redolog have aged out of the controlfile leaving corresponding entries in v$backup_set and v$backup_piece

If a recovery catalog is used then as expected, only backups that are outside the retention policy are
reported as obsolete.

To confirm that you have hit this problem:

Take one of the backuppieces that is erroneously reported as being obsolete and run the following
commands with and without a catalog connection:

list backuppiece 'X';
Note the backup_set key and run: list backupset n;

The catalog connection will return details of the contents of the backupset whilst the nocatalog
connection will not:

RMAN> list backuppiece '69jb5qev_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
271489 271485 1 1 AVAILABLE SBT_TAPE 69jb5qev_1_1

RMAN> list backupset 271485;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
271485 199M SBT_TAPE 00:00:13 13-MAR-08
BP Key: 271489 Status: AVAILABLE Compressed: NO Tag: TAG20080313T1
35126
Handle: 69jb5qev_1_1 Media: SP_DISK_ORACLEDB

List of Archived Logs in backup set 271485
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 47156 7060286012 13-MAR-08 7060338127 13-MAR-08
1 47157 7060338127 13-MAR-08 7060349586 13-MAR-08
2 43019 7060286044 13-MAR-08 7060349562 13-MAR-08

Nocatalog:

RMAN> list backuppiece '69jb5qev_1_1';


List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
50184 50184 1 1 AVAILABLE SBT_TAPE 69jb5qev_1_1

RMAN> list backupset 50184;
List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
50184 0 SBT_TAPE 00:00:13 13-MAR-08
BP Key: 50184 Status: AVAILABLE Compressed: NO Tag: TAG
20080313T135126
Handle: 69jb5qev_1_1 Media: SP_DISK_ORACLEDB


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