1 2 Previous Next 21 Replies Latest reply: Aug 18, 2014 4:14 AM by Renu-Oracle RSS

    RMAN is not deleting expire/obsolete/unused backups

    greddy09sc

      Our Database is roughly 300G.  We have scheduled one Sunday full backup and daily incremental backup.

       

      Our rman storage is at 5 TB.  Rman is not deleting any backups.  Why?

      I had retention policy set to recovery windows of 2 days.  Then I recently change to redundancy of 2.  Still, ther's backups from 3 months ago stored.  How do i delete these backups to free up storage?

       

      I did a crosscheck and delete obsolete/ delete expired without any success.

       

      Here's my show all:

       

      using target database control file instead of recovery catalog

      RMAN configuration parameters for database with db_unique_name PROD are:

      CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

      CONFIGURE BACKUP OPTIMIZATION OFF; # default

      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

      CONFIGURE CONTROLFILE AUTOBACKUP ON;

      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/backup/rman/PROD/%F';

      CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

      CONFIGURE MAXSETSIZE TO UNLIMITED; # default

      CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

      CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

      CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11202/dbs/snapcf_PROD.f'; # default

       

      Any help appreciated!

       

       

      2.  Setting redundancy of 2 means that it will keep 2 backups.  Does it include incremental backups or it mean 2 FULL backups?

        1 2 Previous Next