Flash Recovery Area - File Manipulation and Retention Policy
524692Nov 3 2006 — edited Nov 6 2006Hi All,
I am having the 10g database (Infrastructure) of Oracle Collaboration Suite 10g in Linux (RHEL Release 3 (Taroon Update 4)
I used to face the problem of Database getting into a state that it wont shutdown at times.
I come to know later that it was the issue with the
1. Flash Recovery Area (FRA) files and Space Usage and
2. Retention Policy
The following is the information of the FRA in the database server
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/d01/oracle/product/10.1.2/ocs_1/infra/flash_recovery_area
2147483648 1166971904 0 123
Now., How can I make a Retention Policy, so that the Archived Files in the FRA, once it is about to get occupy completely the available space, the old files has to be marked as OBSOLETE and get deleted automatically..
Many Thanks in Advance.......
Best Regards....