OraFAQ Forum: Backup & Recovery » Delete Obsolete backup from RMAN

Home » RDBMS Server » Backup & Recovery » Delete Obsolete backup from RMAN (Oracle 10.2.0.4.0,Aix 6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Delete Obsolete backup from RMAN [message #590405]

Wed, 17 July 2013 14:45

rtjk
Messages: 33
Registered: February 2005

Member

Environment: 2 Node Oracle(10.2.0.4.0) RAC on Aix 6.1.

Backups using RMAN utility.Our system is configured to take backups on Tape library using TSM server.

We take incremental level 1 backup on all days and Level 0 backup on Wednesday.We would like to keep the RMAN retention period of 14 days.I delete the backups that are 7 days old from the disk to save space and 14 days older backup from Tape.

I am getting below error in my RMAN backup logfiles.Also attached

RMAN-06207: WARNING: 147 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------

The configuration of RMAN is:

 
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 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 'cf%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '+FRA_GRP01';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/ora10/dbs/snapcf_ospdoc1.f'; # default

Backup script:

run {
  allocate channel c1 type disk;
  allocate channel c2 type disk;
  allocate channel c3 type disk;
  allocate channel c4 type disk;
  allocate channel c5 type disk;
  allocate channel c6 type disk;
  allocate channel c7 type disk;
  allocate channel c8 type disk;
  allocate channel c9 type disk;
  allocate channel c10 type disk;

  backup
        as compressed backupset
        incremental level = 0
        tag = 'WEEKLY_DATABASE'
        database;
  backup
        as compressed backupset
        archivelog all;
}

  CROSSCHECK COPY;
  CROSSCHECK BACKUP;
  CROSSCHECK ARCHIVELOG ALL;
  DELETE NOPROMPT OBSOLETE;
  DELETE NOPROMPT EXPIRED COPY;
  ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
  DELETE NOPROMPT BACKUP COMPLETED BEFORE 'SYSDATE-7';
  RELEASE CHANNEL;
  DELETE NOPROMPT EXPIRED BACKUP;
  DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
  delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-2';

run {
  allocate channel c1 type sbt_tape parms
            'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate channel c2 type sbt_tape parms
            'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate channel c3 type sbt_tape parms
            'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate channel c4 type sbt_tape parms
            'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate channel c5 type sbt_tape parms
            'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

  backup recovery area;
}

My question is

How to avoid this error ?
Can we set "Retention period" as 14 days in RMAN level and delete the backups in disk which is older than 7 days?
Should the deletion of tape backup be handled in TSM level ?

Can you help me?