Oracle 11g Health Monitor Checks

说明：
Health Monitor是11g引入的用于检查数据库的各个组件（包括文件、内存、事务处理完整性、
元数据和进程使用情况）。这些检查器将生成检查结果报表以及解决问题的建议。
可在数据库脱机（nomount）和联机（open或mount）的情况下执行,运行状况检查都可以在DB-online模式下运行。只有redo完整性检查和db结构完整性检查需要在数据库脱机模式下进行。


支持的检查条目：

SQL> select name,offline_capable,description,internal_check from v$hm_check;

NAME                                O DESCRIPTION                                                       I
----------------------------------- - ----------------------------------------------------------------- -
HM Test Check                       Y Check for health monitor functionality                            Y
DB Structure Integrity Check        Y Checks integrity of all database files                            N
CF Block Integrity Check            Y Checks integrity of a control file block                          N
Data Block Integrity Check          Y Checks integrity of a data file block                             N
Redo Integrity Check                Y Checks integrity of redo log content                              N
Logical Block Check                 N Checks logical content of a block                                 Y
Transaction Integrity Check         N Checks a transaction for corruptions                              N
Undo Segment Integrity Check        N Checks integrity of an undo segment                               N
No Mount CF Check                   Y Checks control file in NOMOUNT mode                               Y
Mount CF Check                      Y Checks control file in mount mode                                 Y
CF Member Check                     Y Checks a multiplexed copy of the control file                     Y
All Datafiles Check                 Y Checks all datafiles in the database                              Y
Single Datafile Check               Y Checks a data file                                                Y
Tablespace Check Check              Y Checks a tablespace                                               Y
Log Group Check                     Y Checks all members of a log group                                 Y
Log Group Member Check              Y Checks a particular member of a log group                         Y
Archived Log Check                  Y Checks an archived log                                            Y
Redo Revalidation Check             Y Checks redo log content                                           Y
IO Revalidation Check               Y Checks file accessibility                                         Y
Block IO Revalidation Check         Y Checks file accessibility                                         Y
Txn Revalidation Check              N Revalidate corrupted transaction                                  Y
Failure Simulation Check            Y Creates dummy failures                                            Y
Dictionary Integrity Check          N Checks dictionary integrity                                       N
ASM Mount Check                     Y Diagnose mount failure                                            Y
ASM Allocation Check                Y Diagnose allocation failure                                       N
ASM Disk Visibility Check           Y Diagnose add disk failure                                         Y
ASM File Busy Check                 Y Diagnose file drop failure                                        Y
ASM Toomanyoff Check                Y Diagnose mount failed because there were too many offline disks   Y
ASM Insufficient Disks Check        Y Diagnose mount failed because there were insufficient disks       Y
ASM Insufficient Mem Check          Y Check to adjust memory on allocation failure                      Y
30 rows selected.

健康检查的类型:

1.DB Structure Integrity Check—This check verifies the integrity of database files and reports failures if these files are inaccessible,corrupt or inconsistent. If the database is in mount or open mode,this check examines the log files and data files listed in the control file. If the database is in NOMOUNT mode,only the control file is checked.

--mountopen
模式检查控制文件中列出的日志文件和数据文件。NOMOUNT模式，则仅检查控制文件。

2.Data Block Integrity Check—This check detects disk image block corruptions such as checksum failures,head/tail mismatch,and logical inconsistencies within the block. Most corruptions can be repaired using Block Media Recovery. Corrupted block information is also captured in the V$DATABASE_BLOCK_CORRUPTION view. This check does not detect inter-block or inter-segment corruption.

--会捕获损坏的块信息记录在V$DATABASE_BLOCK_CORRUPTION视图中，不会检测块间或段间损坏。

（编辑：核心网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!