监控flash_recovery_area空间

监控flash_recovery_area空间的使用,及降低使用空间（通过rman删除备份数据）

可以通过2个视图来监控flash_recovery_area空间的使用

1,v$flash_recovery_area_usage;

2,v$recovery_dest_size

 监控flash_recovery_area空间的使用可以避免ora-19809错误的出现

SQL> show parameter db_recovery;

 

NAME                                 TYPE

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

VALUE

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

db_recovery_file_dest                string

F:\oracle\product\10.2.0/flash

_recovery_area

db_recovery_file_dest_size           big integer

10G

SQL> col name for a20

SQL> col type for a9

SQL> col value fro a10

SP2-0158: 未知的 COLUMN 选项"fro"

SQL> col value for a10

SQL> set linesize 120

SQL> show parameter db_recovery;

 

NAME                                 TYPE      VALUE

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

db_recovery_file_dest                string    F:\oracle\product\10.2.0/flash

                                              _recovery_area

db_recovery_file_dest_size           big integ 10G

                                     er

SQL> col name for a15

SQL> show parameter db_recovery;

 

NAME                                 TYPE      VALUE

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

db_recovery_file_dest                string    F:\oracle\product\10.2.0/flash

                                              _recovery_area

db_recovery_file_dest_size           big integ 10G

                                     er

SQL> select * fromv$flash_recovery_area_usage;

 

FILE_TYPE                PERCENT_SPACE_USEDPERCENT_SPACE_RECLAIMABLE NUMBER_OF_

FILES

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

-----

CONTROLFILE                               0                         0

    0

ONLINELOG                                 0                         0

    0

ARCHIVELOG                             6.89