how to clean out FRA?
cayenneNov 8 2010 — edited Nov 8 2010I'm missing something here and could use a little advice.
My FRA is getting clogged up with arch. logs. I don't have any more disk space, so can't add that. I've found the retention window was for 8 days, and I've reduced it to 4.
I look at this:
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 99.24 90.73 56
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
Now...I've done RMAN jobs:
backup device type sbt filesperset = 1024 tag 'FRA_11_08_10' recovery area;
I also did :
backup device type sbt filesperset=1024 tag='manual_arch_11_08_2010' archivelog all delete input;
However, when I go back to look at the FRA above...the percent space used and reclaimable haven't changed???
How do I get the files out of the FRA??
Thanks in advance,
cayenne