Hi all,
I have a dataguard environment with a physical standby databases, recently we had a several incremented activity on primary generating a lot of redo, due for this the FRA almost filled up in both DB's, the first time we incremented the db_recovery_file_dest_size to the maximum physical space in both DB's (primary and standby), but seen that the redo activity continue we had to modify the retention parameter from 24hrs to 12 hrs, this resolved the issue but, in this moment we have in the flash recovery FS archives very old occupying space, my question is, how can remove , physically to release space in the FS, this old files??
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/flashct1 245.38 34.06 87% 16112 1% /flashback/ct1
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------------------------------------- ----------- ---------- ----------------- ---------------
/flashback/ct1 2.5770E+11 2.5101E+11 1.6705E+11 2182
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0 0 3
BACKUP PIECE .19 0 3
IMAGE COPY 0 0 0
FLASHBACK LOG 97.22 65.05 2176
FOREIGN ARCHIVED LOG 0 0 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /flashback/ct1
db_recovery_file_dest_size big integer 240G
thanks!