Database Backup and Recovery (MOSC)

MOSC Banner

recovery_file_dest full?

edited May 1, 2014 12:00PM in Database Backup and Recovery (MOSC) 3 commentsAnswered

Hey, I have this:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Then I do this:

select

        name,

        round(space_limit/power(2,30)) as limit_gb,

        round(space_used/power(2,30)) as used_gb,

        round(space_reclaimable/power(2,30)) as reclaimable_gb,

        round((space_used-space_reclaimable) / power(2,30))as  real_used,

        round((space_used-space_reclaimable) / space_limit * 100) as pct_real_used,

        number_of_files

     from v$recovery_file_dest;

NAME

------------------------------------------------------------------------------------------------------------------------------------

  LIMIT_GB    USED_GB RECLAIMABLE_GB  REAL_USED PCT_REAL_USED NUMBER_OF_FILES

---------- ---------- -------------- ---------- ------------- ---------------

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