How to check flash recovery area USAGE for oracle(10g, 11g) database?

There are two dictionary views to monitor the flash recovery area usage.
1.       V$RECOVER_FILE_DEST can be used to find out the physical location, allocated space, space reclaimable, number of files present in the directory.
SQL> l
  1* SELECT * FROM V$RECOVERY_FILE_DEST
SQL> /


NAME                                     SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
---------------------------------------- ----------- ---------- ----------------- ---------------
/apps/oracle/oradata/FRA                  2.1475E+11 9.3252E+10                 0              20

2.       V$flash_recovery_area_usage can be used to find out percentage of the total disk quota used by different types of files, and how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape.
SQL> set pages 100
SQL> set lines 120
SQL> l
  1* SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE
SQL> /

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               0
BACKUP PIECE                      43.42                         0              20
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0

7 rows selected.
How to add Flash Recovery Area to an Existing Database?
How to disable flash recovery area?
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-14 All Rights Reserved | Site Map | Contact | Disclaimer | Google