Shulou(Shulou.com)06/01 Report--

Monitor the use of space in the fast recovery area

It is important to monitor the use of fast recovery area space to ensure that there is enough space to store backup and other recovery-related files! The Oracle database provides two views to monitor the use of the fast recovery area, V$RECOVERY_FILE_DEST and V$RECOVERY_AREA_USAGE.

Use the view V$RECOVERY_FILE_DEST to get the following information about the quick recovery area: total number of files, current location, disk quota, space used, and space can be reclaimed by deleting files. The detailed units of space are bytes.

Sys@ORACLE11 > SELECT * FROM V$RECOVERY_FILE_DEST

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES

/ u01/app/oracle/fast_recovery_area 4385144832 9814016 01

The view V$RECOVERY_AREA_USAGE contains disk quota usage and number of files for different types of files (including control files, online redo log files, archive redo log files, backup slices, mirror copies, flashback logs, external archive log files) and the percentage of space reclaimed by deleting files that are obsolete, redundant, or backed up to tape.

SQL > SELECT * FROM V$RECOVERY_AREA_USAGE

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

--

CONTROL FILE 0 0 0

REDO LOG 0 0 0

ARCHIVED LOG 91.91 0 86

BACKUP PIECE 0 0 0

IMAGE COPY 0 0 0

FLASHBACK LOG 0 0 0

FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.

If the risk of downtime exceeds 90% at any time, you need to delete the archive or expand the disk. After deleting the archive file, you need to use the RMAN tool to release the space occupied by the archive. First connect the RMAN tool.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.