What am I missing with my RMAN archivelog backups

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Fri, 2 May 2014 16:57:17 +0000
Message-ID: <1184E7EFAB1D1C47A5038D06F64BE9262C09286F_at_XM-MBX-02-PROD.ad.uchicago.edu>

Hello,

I am trying to figure out why my rman archivelog backups to tape are not getting removed. This worked correctly at some point, so I am not sure if it was when we changed scripts or version changes with oracle that I did not catch at the time. This example is for an 11.1.0.7 instance which was created recently, but we are running all versions from 10g to 11204. I have not looked into it enough to tie the behavior to a certain version yet. I am listing output of most of the information that I think is relevant.

RMAN> report obsolete; <--- This is showing nothing found as obsolete. I would expect my archivelog backups to show as obsolete based on the information below

RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 7 days no obsolete backups found

RMAN> list backup summary; <------ We have archivelog backups that are older than our oldest database backup. I would expect these to report as obsolete, or to at least get caught in the delete obsolete

List of Backups

---

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---
131     B  A  A SBT_TAPE    06-MAR-14       1       1       NO         TAG20140306T132627
132     B  A  A SBT_TAPE    06-MAR-14       1       1       NO         TAG20140306T132627
175     B  A  A SBT_TAPE    07-MAR-14       1       1       NO         TAG20140307T000012
283     B  A  A SBT_TAPE    07-MAR-14       1       1       NO         TAG20140307T080324
284     B  A  A SBT_TAPE    07-MAR-14       1       1       NO         TAG20140307T080324
335     B  A  A SBT_TAPE    07-MAR-14       1       1       NO         TAG20140307T090010
375     B  A  A SBT_TAPE    08-MAR-14       1       1       NO         TAG20140308T000013
...........................

RMAN> show all; <---- Retention is set to 7 days and default device type is tape

RMAN configuration parameters for database with db_unique_name XXXX are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default ........

• All of the database backups are full level 0 backups.
• Archivelogs are backed up with the following command " backup format 'XXXX_ARCH_%M%D_%u.bkp' archivelog all not backed up 3 times;"

Thanks in advance for any help

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 02 2014 - 18:57:17 CEST