High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Flashback log management

 Hi,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center