Automatic Deletion of Files in FRA
Ok, I am about fired up right now. I have read over and over how Oracle will reclaim space in the FRA if it is running low yet I can't reproduce this behavior to save my life.
- I have archive logging enabled.
- I am using the FRA.
- I have a recovery window of 1 day set.
- I have full incremental (level 0) backups for the past three days.
- I am also backing up archivelogs and have "all not backed up" specified as well.
"report obsolete" does indeed report the backups that fall outside of my recovery window correctly. When I run another backup I receive the following:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 9163505664 bytes disk space from 16106127360 limit
All I have at this moment is a strong desire to repeat the word "derp" over and over. Can someone explain what I am missing (or perhaps misconstruing) or point me at some docs that clearly spell this out for me?
Or is it simply that what is being stated implies that I run the following to cause Oracle to "automatically delete files" to create space for new FRA additions:
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;
Cheers!
Edited by: 909736 on Feb 14, 2013 11:10 AM