11g_Health_Monitor

健康监控检查(Health Monitor Check)也是Oracle11g中新出现的功能，用于对数据库作诊断性检查，主要包括以下检查项。[@more@]

SQL> select name,INTERNAL_CHECK, OFFLINE_CAPABLE, description from v$hm_check order by 2,3;

NAME INTERNAL_CHECK OFFLINE_CAPABLE DESCRIPTION
--------------------------------- -------------- --------------- ---------------------------------------------
Undo Segment Integrity Check N N Checks integrity of an undo segment
Transaction Integrity Check N N Checks a transaction for corruptions
Dictionary Integrity Check N N Checks dictionary integrity
Data Block Integrity Check N Y Checks integrity of a datafile block
Redo Integrity Check N Y Checks integrity of redo log content
DB Structure Integrity Check N Y Checks integrity of all database files
Y N
Logical Block Check Y N Checks logical content of a block
Txn Revalidation Check Y N Revalidate corrupted txn
Block IO Revalidation Check Y Y Checks file accessability
Failure Simulation Check Y Y Creates dummy failures
IO Revalidation Check Y Y Checks file accessability
Redo Revalidation Check Y Y Checks redo log content
Archived Log Check Y Y Checks an archived log
Log Group Member Check Y Y Checks a particular member of a log group
Log Group Check Y Y Checks all members of a log group
Single Datafile Check Y Y Checks a datafile
All Datafiles Check Y Y Check for all datafiles in the database
CF Member Check Y Y Checks a multiplexed copy of the control file
All Control Files Check Y Y Checks all control files in the database
HM Test Check Y Y Check for HM Functionality

21 rows selected

其中INTERNAL_CHECK为'N'的检查项表示用户能手动运行，而INTERNAL_CHECK='Y'表示系统内部检查，试图手动运行时会报ORA-51001错误--在HM目录中未找到检查[Single Datafile Check]。
手动运行检查，可以用OEM或者DBMS_HM.RUN_CHECK包。
DBMS_HM.RUN_CHECK的主要参数：
CHECK_NAME -> v$hm_check.name列的值。
RUN_NAME -> 用户指定或系统自动生成的名字，生成报告用到。
TIME_OUT -> 运行检查的时间限制。
INPUT_PARAMS -> 输入参数。

下面的SQL列出各个检查所需要的输入参数。
SQL> select c.name check_name, p.name parameter_name,
2 p.default_value, p.description
3 from v$hm_check_param p, v$hm_check c
4 where p.check_id = c.id and c.internal_check = 'N'
5 order by c.name;

CHECK_NAME PARAMETER_NAME DEFAULT_VALUE DESCRIPTION
------------------------------ ---------------- ---------------- ---------------------------------------
Data Block Integrity Check BLC_DF_NUM Block Data File number
Data Block Integrity Check BLC_BL_NUM Datablock number
Dictionary Integrity Check CHECK_MASK ALL Check Mask
Dictionary Integrity Check TABLE_NAME ALL_CORE_TABLES Table Name
Redo Integrity Check SCN_TEXT 0 SCN of the latest good redo (if known)
Transaction Integrity Check TXN_ID Transaction ID
Undo Segment Integrity Check USN NUMBER Undo Segment Number

7 rows selected

下面的例子，我们要做一个Transaction Integrity Check。
1. 新开一个窗口，制造一个transaction，注意不运行随后的commit或者rollback。
SQL> delete scott.temp1 where object_id=25;
64 rows deleted

2. 在原先窗口中找到这个transaction相关信息。
SQL> select * from v$transaction;
ADDR XIDUSN XIDSLOT XIDSQN
-------- ---------- ---------- ----------
2EBD5250 3 29 777

3. 运行检查（注意transaction_id/TXN_ID由XIDUSN.XIDSLOT.XIDSQN拼成。测试中如果TXN_ID给一个错误的值，则必发生ORA-00600或者ORA-03113错误，这个比较奇怪，估计11g R1版本这方面还是做的有些瑕疵）
SQL> exec dbms_hm.run_check (check_name => 'Transaction Integrity Check',run_name => 'test_tx_ck1',input_params => 'TXN_ID=3.29.777');
PL/SQL procedure successfully completed

4. 生成检查报告
SQL> set long 10000
SQL> select dbms_hm.get_run_report('test_tx_ck1') from dual;

DBMS_HM.GET_RUN_REPORT('TEST_T
--------------------------------------------------------------------------------
Basic Run Information
Run Name : test_tx_ck1
Run Id : 41
Check Name : Transaction Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2009-02-17 14:07:44.058000 +08:00
End Time : 2009-02-17 14:07:44.599000 +08:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0

Input Paramters for the Run
TXN_ID=3.29.777

Run Findings And Recommendations
Finding
Finding Name : TXN not corrupt
Finding ID : 42
Type : INFORMATIONAL
Status : OPEN
Priority : HIGH
Message : Transaction 3.29.777 is not corrupted

5. 在ADRCI工具中也可以查看Health Monitor运行的相关信息。
adrci> set home diagrdbmsorclorcl
adrci> show hm_run

ADR Home = d:apphz00540diagrdbmsorclorcl:
*************************************************************************

......
**********************************************************
HM RUN RECORD 2
**********************************************************
RUN_ID 21
RUN_NAME TestCheck1
CHECK_NAME Dictionary Integrity Check
NAME_ID 24
MODE 0
START_TIME 2009-02-16 13:37:37.099000 +08:00
RESUME_TIME
END_TIME 2009-02-16 13:37:44.329000 +08:00
MODIFIED_TIME 2009-02-17 14:08:49.045000 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE d:apphz00540diagrdbmsorclorclhmHMREPORT_TestCheck1.hm
......

Health Monitor相关的数据字典 V$HM_CHECK,V$HM_CHECK_PARAM,V$HM_FINDING,V$HM_INFO,V$HM_RECOMMENDATION,V$HM_RUN。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/207/viewspace-1027398/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/207/viewspace-1027398/