ORACLE Health Monitor.docxVIP

ORACLE Health Monitor1. Health Monitor简介??? Health Monitor是11g里新增加的特性，用于数据库的各层和各个组建的诊断检查。例如可以检查：文件损坏、物理逻辑块损坏、redo和undo故障、数据字典损坏等。HM可以根据检查的结果产生一个报表，并提供解决问题的建议。???1.1 运行方式：??? 1). Reactive???????? Fault diagnosability infrastructure能自动响应严重的错误（critical error）。???? 2). Manually???????? 可以通过DBMS_HM系统包或 Enterprise Manager来手工运行HM。????1.2 运行模式????? 1). DB-ONLINE????? 2). DB-OFFLINE????? 所有HM都能在online模式下运行，只有Redo Integrity Check 和 DB Structure Integrity Check能在offline模式下运行。????2. HM的类型??? 见附件详细说明??? 也可以通过视图来查询：???SQL SELECT name FROM v$hm_check WHERE internal_check=N;???? NAME???? ???? DB Structure Integrity Check?????Data?Block Integrity Check???? Redo Integrity Check???? Transaction Integrity Check???? Undo Segment Integrity Check???? Dictionary Integrity Check3. 手工运行HM???3.1 通过DBMS_HM系统包???? 例如：???? BEGIN???????? DBMS_HM.RUN_CHECK(Dictionary Integrity Check, my_run);???? END;???? 该程序允许有输入参数，可以通过如下方式查找：????SQLSELECT c.name check_name, p.name parameter_name, p.type,p.default_value, p.description?????????????? FROM v$hm_check_param p, v$hm_check c?????????????? WHERE p.check_id = c.id and c.internal_check = N?????????????? ORDER BY c.name;????? 带参数实例：???? BEGIN???????? DBMS_HM.RUN_CHECK (???????? check_name = Transaction Integrity Check,???????? run_name = my_run,???????? input_params = TXN_ID=7.33.2);???? END;????????3.2 通过OEM允许??????????Advisor Central －》Checkers －》 Run4. 查看HM报表???4.1 通过DBMS_HM系统包???? 实例：???SQLSET LONG 100000???SQLSET LONGCHUNKSIZE 1000???SQLSET PAGESIZE 1000???SQLSET LINESIZE 512???SQLSELECT DBMS_HM.GET_RUN_REPORT(HM_RUN_1061)? FROM??? DUAL;???? DBMS_HM.GET_RUN_REPORT(HM_RUN_1061)??? ???? Run Name???????????????????? : HM_RUN_1061???? Run Id?????????????????????? : 1061???? Check Name?????????????????? : Data Block Integrity Check???? Mode???????????????????????? : REACTIVE???? Status?????????????????????? : COMPLETED???? Start Time?????????????????? : 2007-05-12 22:11:02.032292 -07:00???? End Time???????????????????? : 2007-05-12 22:11:20.835135 -07:00??