Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't delete obsolete and expired backups.

851543Nov 1 2011 — edited Nov 28 2011
Every Sundays I create 0 level backup.
Every Thuesdays I create 1 level comulative backup.
Every other days I create 1 level incremental backup.
Sometimes I need a free space for new backups and I try clean old backups.
As I can understand, rman remove backups from 'list backup', but doens't delete physically from disk storage.

-----
SQL> select banner from v$version;

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
-----

0 level backup

CONNECT TARGET / ;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u06/backup/df_%d_%s_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u06/backup/cf_%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u06/backup/snapcf.f';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE MAXSETSIZE TO 20G;

BACKUP CURRENT CONTROLFILE;
BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 100 ;
BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

RESTORE VALIDATE DATABASE;
RESTORE VALIDATE CONTROLFILE TO '$ORACLE_BASE/admin/rman_scripts/cf_tmp.ctl';
RESTORE VALIDATE SPFILE TO '$ORACLE_BASE/admin/rman_scripts/spf_tmp.ora';
RESTORE VALIDATE ARCHIVELOG FROM TIME 'SYSDATE-4';

REPORT NEED BACKUP;
DELETE OBSOLETE;
LIST BACKUP;
LIST BACKUP SUMMARY;
-----


1 level comulative backup

CONNECT TARGET / ;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u06/backup/df_%d_%s_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u06/backup/cf_%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u06/backup/snapcf.f';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE MAXSETSIZE TO 20G;

BACKUP CURRENT CONTROLFILE;
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE FILESPERSET 100;
BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

RESTORE VALIDATE DATABASE;
RESTORE VALIDATE CONTROLFILE TO '$ORACLE_BASE/admin/rman_scripts/cf_tmp.ctl';
RESTORE VALIDATE SPFILE TO '$ORACLE_BASE/admin/rman_scripts/spf_tmp.ora';
RESTORE VALIDATE ARCHIVELOG FROM TIME 'SYSDATE-4';

REPORT NEED BACKUP;
DELETE OBSOLETE;
LIST BACKUP;
LIST BACKUP SUMMARY;
-----

1 level incremental backup

CONNECT TARGET / ;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u06/backup/df_%d_%s_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u06/backup/cf_%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u06/backup/snapcf.f';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE MAXSETSIZE TO 20G;

BACKUP CURRENT CONTROLFILE;
BACKUP INCREMENTAL LEVEL 1 DATABASE FILESPERSET 100;
BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

RESTORE VALIDATE DATABASE;
RESTORE VALIDATE CONTROLFILE TO '$ORACLE_BASE/admin/rman_scripts/cf_tmp.ctl';
RESTORE VALIDATE SPFILE TO '$ORACLE_BASE/admin/rman_scripts/spf_tmp.ora';
RESTORE VALIDATE ARCHIVELOG FROM TIME 'SYSDATE-4';

REPORT NEED BACKUP;
DELETE OBSOLETE;
LIST BACKUP;
LIST BACKUP SUMMARY;
-----


Try delete old backups:

CONNECT TARGET / ;

RMAN> CROSSCHECK BACKUP;
...
Crosschecked 173 objects

RMAN> DELETE EXPIRED BACKUP;

using channel ORA_DISK_1
specification does not match any backup in the repository

RMAN> DELETE OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 3 days
using channel ORA_DISK_1
no obsolete backups found

RMAN>

Edited by: 848540 on 31.10.2011 23:15
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2011
Added on Nov 1 2011
#performance-availability, #recovery-manager-rman
6 comments
1,388 views