ARCHIVE DELETION POLICFY
Dear Oracle Community,
Flash Recovery Area could not reclaimed. Therefore, without intervention the FRA would eventually hit 100%
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE .01 0 1 0
REDO LOG 2.25 0 18 0
ARCHIVED LOG 51.7 51.69 18384 0
BACKUP PIECE 0 0 0 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 25.06 23.3 204 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
8 rows selected.
SQL> select * from v$recovery_file_dest;
NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
-------------------------- -------------------------- -------------------------- --------------- ----------
+FRA
858993459200 678715981824 645346212864 18607 0
Would you suggest to set the deletion policy on a dataguard configuration as: