Skip to Main Content

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!

archived redo logs in fra not deleted

840045Sep 20 2012 — edited Sep 20 2012
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2012
Added on Sep 20 2012
8 comments
648 views