RMAN "delete obsolete" question

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 11 Apr 2007 14:28:06 GMT
Message-ID: <Wf6Th.1456$ok6.974@trnddc07>

Target DB is 9.2.0.1
Catalog is 10.2.0.2

I have my retention policy configured to "recovery window of 30 days" on one of my databases but report/delete obsolete are listing backups that are < 30 days old. Also, there are many archived log backups > 30 days old that are not being picked up by report/delete obsolete. I can query them in the catalog with sqlplus and as far as I can tell, rman should be recognizing them as obsolete but it's not. What would cause this?

TIA

===============RMAN output====================================

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS; CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F'; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpoc.opt)';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/oracle2/app/oracle/product/9.2.0/dbs/snapcf_PRD14.f'; # default

RMAN> report obsolete;

RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 30 days Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           4632524 06-APR-07
  Backup Piece       4632526 06-APR-07          PRD142007040673iefaoi
Backup Set           4659580 10-APR-07
  Backup Piece       4659582 10-APR-07          PRD14200704107oieps4r
Backup Set           4663153 10-APR-07
  Backup Piece       4663154 10-APR-07          c-1453689907-20070410-00


=============SQLPLUS Output============================================

admin00:SQL>select db_key from rman.rc_database where name = 'PRD14';

DB_KEY

968946

admin00:SQL>r
  1 select backup_type, keep, count(*) from rman.rc_backup_set   2 where db_key = 968946
  3 and completion_time < sysdate-31
  4* group by backup_type, keep

BACKUP_TYPE KEEP COUNT(*)
----------- ---- ----------

L           NO          323
D           NO            2

Received on Wed Apr 11 2007 - 09:28:06 CDT