archived redo logs in fra not deleted
840045Sep 20 2012 — edited Sep 20 2012I have the following script that runs daily that worked in 10g. After migrating to 11g the archived redo logs in the FRA are no longer deleted even though I want them deleted. I want to have a large FRA but keep the total percent used at about 50% which gives me plenty of breathing room if issues occur. I know oracle can manage the FRA just fine but it will allow the FRA to fill more than 50%. Anyways I just want to be able to delete the archived logs from the FRA following my retention policy instead of a run-out-of-space policy managed by oracle.
Here is the script along with my configuration settings. I am excpecting to see the backed up archive logs deleted after the 14 day window.
run {
show all;
backup incremental level 1 cumulative database tag='bkup_ND_incr';
backup archivelog all not backed up 2 times;
}
run {
crosscheck archivelog all;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired archivelog all;
delete noprompt expired backup;
}
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ND are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
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 '%F'; # default
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 BACKED UP 2 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/product/11.2.0/dbs/snapcf_ND.f'; # default