Configuration

Check

SHOW PARAMETER db_recovery_file_dest

SHOW PARAMETER db_recovery_file_dest_size

Reporting

FRA Reclaimable Space

COLUMN deleted format a7

COLUMN reclaimable format a11

COLUMN last_time format a20

COLUMN first_time format a20

SET LINESIZE 120

SELECT applied,

       deleted,

       backup_count,

       DECODE(rectype,11,'YES','NO') reclaimable,

       COUNT(*),

       TO_CHAR(MIN(completion_time),'dd-Mon-YYYY hh24:mi') first_time,

       TO_CHAR(MAX(completion_time),'dd-Mon-YYYY hh24:mi') last_time,

       MIN(sequence#) first_seq,max(sequence#) last_seq

  FROM v$archived_log

  LEFT OUTER JOIN sys.x$kccagf USING(recid)

 WHERE is_recovery_dest_file='YES'

 GROUP BY applied,

          deleted,

          backup_count,

          DECODE(rectype,11,'YES','NO')

 ORDER BY MIN(sequence#)

/ 

Targets - Databases - MyDB - Oracle Database - Monitoring - All Metrics - Fast Recovery -Non-reclaimable Fast Recovery Area (%)

See Also

Bibliography