Cannot delete obsolete backups
Recently we changed our backup strategy and MML and now we seem to be have a little issue with our archivelog backups. Originally we were using TSM/TDPO to backup archivelogs and the database. We switched to using Avamar for Oracle backups and NFS for archivelog backups. The RMAN catalog database is 11.1.0.6 and most of the targets are 10.2.0.x on AIX. I notice that when we try to delete obsolete backups the physical pieces are not being deleted. In fact, it appears that the backupsets on disk are not being recognized as being obsolete.
<h5> Here is my RMAN configuration: </h5>
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/archivelogs/db1prod/prod1/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/archivelogs/db1prod/prod1/%U', '/archivelogs2/db1prod/lawprod1/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/10.2.0.3/dbs/snapcf_lawprod1.f'; # default
<h5>This is the script for the archivelog backups: </h5>
connect target /;
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
set backup copies=2;
backup
FILESPERSET=10 as compressed backupset
(archivelog all delete input
format '/archivelogs/db1prod/prod1/ARCH_%d_%s_%t',
'/archivelogs2/db1prod/prod1/ARCH_%d_%s_%t');
}
<h5> Script to delete obsolete backups </h5>
allocate channel for delete type 'sbt_tape'
parms "SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,
ENV=(PATH=/bin:/usr/bin:/usr/local/avamar/bin)";
send '"--flagfile=/home/oracle/scripts/backup/my-avtar-flags.txt"';
allocate channel for delete type disk;
CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 14 days;
If I list the contents of the /archivelogs and /archivelogs2 I can see the physical backup pieces going back as far as March 29,2011, and if I list backups of the database and archivelogs I still see the backup pieces. However, a report obsolete using a recovery window of 14 days shows no results for the archivelogs on disk except for controlfile autobackup pieces. A list backup with the backup piece name does show results.
For example:
ls -lt /archivelogs/db1prod/prod1 <--(output truncated for brevity)
-rw-rw---- 1 oracle dba 107030528 Mar 29 12:46 ARCH_PROD_202799_747060341
-rw-rw---- 1 oracle dba 61365760 Mar 29 12:45 ARCH_PROD_202800_747060341
-rw-rw---- 1 oracle dba 142418432 Mar 29 11:46 ARCH_PROD_202796_747056744
-rw-rw---- 1 oracle dba 135881216 Mar 29 11:46 ARCH_PROD_202797_747056744
-rw-rw---- 1 oracle dba 141996544 Mar 29 10:51 ARCH_PROD_202793_747053451
-rw-rw---- 1 oracle dba 134661120 Mar 29 10:51 ARCH_PROD_202794_747053451
-rw-rw---- 1 oracle dba 59075584 Mar 29 10:01 ARCH_PROD_202790_747050468
-rw-rw---- 1 oracle dba 42359296 Mar 29 10:01 ARCH_PROD_202791_747050468
-rw-rw---- 1 oracle dba 41699840 Mar 29 08:57 0um8e1oc_1_1
-rw-rw---- 1 oracle dba 4436480 Mar 29 08:57 0vm8e1oc_1_1
RMAN> allocate channel for maintenance type 'sbt_tape'
parms "SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,
ENV=(PATH=/bin:/usr/bin:/usr/local/avamar/bin)";2> 3>
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=1034 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: EMC|Avamar (avtar backup)
RMAN> crosscheck backuppiece '/archivelogs/db1prod/prod1/ARCH_PROD_202791_747050468';
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/archivelogs/db1prod/prod1/ARCH_PROD_202791_747050468 recid=207516 stamp=750176264
Crosschecked 1 objects
RMAN> list backuppiece '/archivelogs/db1prod/prod1/ARCH_PROD_202791_747050468';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
56357215 54835665 1 1 AVAILABLE DISK /archivelogs/db1prod/prod1/ARCH_PROD_202791_747050468
RMAN> report obsolete recovery window of 14 days;
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 416967 05-NOV-08
Backup Piece 420773 05-NOV-08 /u01/oracle/10.2.0.3/dbs/c-255040390-20081105-0b
Backup Set 417055 06-NOV-08
Backup Piece 420774 06-NOV-08 /u01/oracle/10.2.0.3/dbs/c-255040390-20081106-0b
Backup Set 418283 20-NOV-08
Backup Piece 421142 20-NOV-08 /u01/oracle/10.2.0.3/dbs/c-255040390-20081120-0a
Backup Set 418298 20-NOV-08
Backup Piece 421157 20-NOV-08 /u01/oracle/10.2.0.3/dbs/c-255040390-20081120-0f
Backup Set 418299 20-NOV-08
Backup Piece 421158 20-NOV-08 /u01/oracle/10.2.0.3/dbs/c-255040390-20081120-10
Backup Set 3865992 29-JAN-09
Backup Piece 3869537 29-JAN-09 /u01/oracle/10.2.0.3/dbs/c-255040390-20090129-0b
Backup Set 3865996 29-JAN-09
Backup Piece 3869538 29-JAN-09 /u01/oracle/10.2.0.3/dbs/c-255040390-20090129-0c
Backup Set 3867039 10-FEB-09
Backup Piece 3869936 10-FEB-09 /u01/oracle/10.2.0.3/dbs/c-255040390-20090210-0b
Backup Set 3867040 10-FEB-09
Backup Piece 3869937 10-FEB-09 /u01/oracle/10.2.0.3/dbs/c-255040390-20090210-0c
Backup Set 3867676 17-FEB-09
Backup Piece 3870573 17-FEB-09 /u01/oracle/10.2.0.3/dbs/c-255040390-20090217-0b
Backup Set 3867677 17-FEB-09
Backup Piece 3870574 17-FEB-09 /u01/oracle/10.2.0.3/dbs/c-255040390-20090217-0c
Backup Set 55870996 17-APR-11
Backup Piece 55871000 17-APR-11 /archivelogs/db1prod/prod1/c-255040390-20110417-18
Backup Set 55873383 18-APR-11
Backup Piece 55873386 18-APR-11 /archivelogs/db1prod/prod1/c-255040390-20110418-00
Backup Set 55875939 18-APR-11
Backup Piece 55875942 18-APR-11 /archivelogs/db1prod/prod1/c-255040390-20110418-01
Backup Set 55879775 18-APR-11
Backup Piece 55879778 18-APR-11 /archivelogs/db1prod/prod1/c-255040390-20110418-02
<--Truncated for brevity.
You will notice that all the obsolete backups are controlfile autobackups and not database or archivelog backups.
Has anyone else seen this before? Am I missing something?
Thanks,
Leighton