Monitoring Fast Recovery Area Space Usage - wykład

Monitoring Fast Recovery Area Space Usage
It is important to monitor space usage in the fast recovery area to ensure that it is large
enough to contain backups and other recovery-related files. Oracle Database provides
two views to monitor fast recovery area space usage, V$RECOVERY_FILE_DEST and
V$RECOVERY_AREA_USAGE.
Use the V$RECOVERY_FILE_DEST view to obtain the following information about the fast
recovery area: total number of files, current location, disk quota, space in use, and
space reclaimable by deleting files. The space details are in bytes. Querying
V$RECOVERY_FILE_DEST produces the following output.
SELECT * FROM V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------- ----------- ---------- ----------------- ---------------
/mydisk/rcva 5368709120 109240320 256000 28
The V$RECOVERY_AREA_USAGE view contains the percentage of disk quota used by
different type of files, and the percentage of space that can be reclaimed by deleting
files that are obsolete, redundant, or backed up to tape. Querying the V$RECOVER_
AREA_USAGE view produces the following output.
SELECT * FROM V$RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 2 0 22
ARCHIVELOG 4.05 2.01 31
BACKUPPIECE 3.94 3.86 8
IMAGECOPY 15.64 10.43 66
FLASHBACKLOG .08 0 1
... zobacz całą notatkę