Skip to Main Content

Oracle Database Discussions

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!

Flash Recovery Area - File Manipulation and Retention Policy

524692Nov 3 2006 — edited Nov 6 2006
Hi 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....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2006
Added on Nov 3 2006
18 comments
1,166 views