Skip to Main Content

Oracle Database Discussions

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!

RMAN DELETE backup

562343Sep 11 2009 — edited Sep 12 2009
I configure my RETENTION POLICY TO RECOVERY to have 7 days, and i am running incremental backup every day, the first time the script run took 0 level backup and every day level 1, the first backup was spet 1st and today it is sept 11 and i still have those incremental bakcup from spet 2, 3, 4 avaiable and RMAN doenst delete any backup.
this is the script i am using:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/data/backup/RMAN_BACKUP/standby/octl%d_%u_%s_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/10.1.0/dbs/snapcf_octl.f'; # default


CROSSCHECK BACKUP;
DELETE FORCE NOPROMPT OBSOLETE;

backup tag 'octl_STBCONTROLFILE' format '/data/backup/RMAN_BACKUP/standby/DBCONTROLFILE_%U'(current controlfile);
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'octlincBK' DATABASE;
RECOVER COPY OF DATABASE WITH TAG 'octlincBK';

BACKUP BACKUPSET ALL;

}

run{
delete noprompt archivelog until time 'sysdate-1';
DELETE FORCE NOPROMPT OBSOLETE;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
}

LIST BACKUP;


RMAN> report obsolete;

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


this is part of the backup i have in the disk:
-rw-r----- 1 oracle oinstall 767M Sep 2 18:57 OCTL_9jko8k09_307_1
-rw-r----- 1 oracle oinstall 180M Sep 2 18:58 OCTL_9kko8k09_308_1
-rw-r----- 1 oracle oinstall 667M Sep 3 18:58 OCTL_9nkob8cn_311_1
-rw-r----- 1 oracle oinstall 201M Sep 3 18:59 OCTL_9okob8cn_312_1
-rw-r----- 1 oracle oinstall 642M Sep 4 18:56 OCTL_9rkodsof_315_1
-rw-r----- 1 oracle oinstall 185M Sep 4 18:57 OCTL_9skodsof_316_1

I was expecting RMAN to delete at least the backup from Sep 2:


from the log file i have from yesterday, this is what RMAN delete:

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 31276334 02-SEP-09
Backup Piece 31276340 02-SEP-09 /oracle/app/oracle/flash_recovery_area/OCTLSTANDBY/autobackup/2009_09_02/o1_mf_s_696536689_59y1y2w4_.bkp
deleted backup piece
backup piece handle=/oracle/app/oracle/flash_recovery_area/OCTLSTANDBY/autobackup/2009_09_02/o1_mf_s_696536689_59y1y2w4_.bkp recid=245 stamp=696538994
Deleted 1 objects


RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 31367037 03-SEP-09
Backup Piece 31367044 03-SEP-09 /data/backup/RMAN_BACKUP/standby/DBCONTROLFILE_9mkob8bm_1_1
deleted backup piece
backup piece handle=/data/backup/RMAN_BACKUP/standby/DBCONTROLFILE_9mkob8bm_1_1 recid=246 stamp=696623478
Deleted 1 objects


is there anything i missing here to delete the above BACKUP OCTL_9jko8k09_307_1 ........?

My oracle version is 10.1.5.0
OS: LINUX 64
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2009
Added on Sep 11 2009
10 comments
4,669 views