11g新特性：Health Monitor Checks

来源：互联网发布：python线程间传递数据编辑：程序博客网时间：2024/06/04 18:39

11g新特性：Health Monitor Checks 这个功能挺好。

select name,name_nls from V$HM_CHECK order by 1;

ASM Allocation CheckASM 分配检查ASM Disk Visibility CheckASM 磁盘可见性检查ASM File Busy CheckASM 文件忙检查ASM Insufficient Disks Check检查装载失败, 因为磁盘不足ASM Insufficient Mem Check内存分配检查ASM Mount CheckASM 装载检查ASM Toomanyoff Check检查装载失败, 因为脱机磁盘太多All Datafiles Check所有数据文件检查Archived Log Check归档日志检查Block IO Revalidation Check块 IO 重新验证检查CF Block Integrity CheckCF 块完整性检查CF Member CheckCF 成员检查DB Structure Integrity Check数据库结构完整性检查Data Block Integrity Check数据块完整性检查Dictionary Integrity Check字典完整性检查Failure Simulation Check故障模拟检查HM Test CheckHM 测试检查IO Revalidation CheckIO 重新验证检查Log Group Check日志组检查Log Group Member Check日志组成员检查Logical Block Check逻辑块检查Mount CF Check装载 CF 检查No Mount CF Check不装载 CF 检查Redo Integrity Check重做完整性检查Redo Revalidation Check重做重新验证检查Single Datafile Check单个数据文件检查Tablespace Check Check表空间检查Transaction Integrity Check事务处理完整性检查Txn Revalidation CheckTxn 重新验证检查Undo Segment Integrity Check还原段完整性检查

--可以手动检查的项目
SELECT name,name_nls FROM V$HM_CHECK WHERE INTERNAL_CHECK = 'N' ;

DB Structure Integrity Check数据库结构完整性检查CF Block Integrity CheckCF 块完整性检查Data Block Integrity Check数据块完整性检查Redo Integrity Check重做完整性检查Transaction Integrity Check事务处理完整性检查Undo Segment Integrity Check还原段完整性检查Dictionary Integrity Check字典完整性检查ASM Allocation CheckASM 分配检查

SQL> exec dbms_hm.run_check(check_name => 'Redo Integrity Check',run_name=> 'db_check1');
PL/SQL procedure successfully completed.
SQL>

SQL> select to_char(dbms_hm.get_run_report(run_name => 'db_check1')) from dual;

TO_CHAR(DBMS_HM.GET_RUN_REPORT(RUN_NAME=>'DB_CHECK1'))
--------------------------------------------------------------------------------
Basic Run Information
Run Name : db_check1
Run Id : 1941
Check Name : Redo Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2016-09-22 11:26:16.582506 +08:00
End Time : 2016-09-22 11:26:17.230306 +08:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0

TO_CHAR(DBMS_HM.GET_RUN_REPORT(RUN_NAME=>'DB_CHECK1'))
--------------------------------------------------------------------------------

Input Paramters for the Run
SCN_TEXT=0

Run Findings And Recommendations
SQL>

--需要用到的程序包
DBMS_HM.RUN_CHECK (
check_name IN VARCHAR2, --检查的项目名，通过SELECT name FROM V$HM_CHECK WHERE INTERNAL_CHECK = 'N' 可以查到。
run_name IN VARCHAR2 := NULL, --用户自定义的该次运行检查的名称
timeout IN NUMBER := NULL, --超时时间。
input_params IN VARCHAR2 := NULL); --输入参数，多个参数用分号(;)隔开。具体制定检查项目。
                                         --具体参数可以从V$HM_CHECK_PARAM视图中找到。
                                         --例子，'BLC_DF_NUM=1;BLC_BL_NUM=23456'表示检查第1个数据文件的第23456个block。
                                         --通过下面的SQL，可以找出检查项目对应的参数。
                                      --找出Data Block Integrity Check项目对应的参数
                                            SELECT a.* FROM v$hm_check_param a, v$hm_check b
                                                WHERE a.check_id = b.id
                                            AND b.name = 'Data Block Integrity Check';

1 0