Flashback log management
We are using Flashback Database in one of our Databases (Data Guard Configuration) with below configuration.
db_recovery_file_dest_size : 5gb
db_recovery_file_dest= <<some location..>>
When I check the disk space used at the above location it shows more than 5gb. Pls check below the few details that may help to understand the settings.
I wanted to know (a) if this is a normal behaviour.
(b) shouldn't the used disk space be below 5gb always.
(c) how do I know if Oracle is reclaiming the reclaimable space with the recovery_file_area.
######################################################################################
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;