Skip to Main Content

Database Software

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!

how can I clean the flash recovery area on the standby Databases

2647996Apr 28 2015 — edited Apr 30 2015

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!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2015
Added on Apr 28 2015
4 comments
2,316 views