健康監(jiān)控器(Health Monitor)
ORACLE 11G 中引入了免費(fèi)的數(shù)據(jù)庫健康監(jiān)控器，通過DBMS_HM程序包來完成。

檢查項(xiàng)目：
1.DB結(jié)構(gòu)完整性檢查

2.數(shù)據(jù)塊及完整性檢查

3.中做日志完整性檢查

4.Undo段完整性檢查

5.事物完整性檢查

6.數(shù)據(jù)字典完整性檢查

SQL> select name,description from v$hm_check;
NAME                           DESCRIPTION
------------------------------ -------------------------------------------------
HM Test Check                  Check for HM Functionality
DB Structure Integrity Check   Checks integrity of all database files
Data Block Integrity Check     Checks integrity of a datafile block
Redo Integrity Check           Checks integrity of redo log content
Logical Block Check            Checks logical content of a block
Transaction Integrity Check    Checks a transaction for corruptions
Undo Segment Integrity Check   Checks integrity of an undo segment
All Control Files Check        Checks all control files in the database
CF Member Check                Checks a multiplexed copy of the control file
All Datafiles Check            Check for all datafiles in the database
NAME                           DESCRIPTION
------------------------------ -------------------------------------------------
Single Datafile Check          Checks a datafile
Log Group Check                Checks all members of a log group
Log Group Member Check         Checks a particular member of a log group
Archived Log Check             Checks an archived log
Redo Revalidation Check        Checks redo log content
IO Revalidation Check          Checks file accessability
Block IO Revalidation Check    Checks file accessability
Txn Revalidation Check         Revalidate corrupted txn
Failure Simulation Check       Creates dummy failures
Dictionary Integrity Check     Checks dictionary integrity
21 rows selected.



PROCEDURE RUN_CHECK
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 CHECK_NAME                     VARCHAR2                IN
 RUN_NAME                       VARCHAR2                IN     DEFAULT
 TIMEOUT                        NUMBER                  IN     DEFAULT
 INPUT_PARAMS                   VARCHAR2                IN     DEFAULT
 
 
 
.check_name:數(shù)據(jù)庫檢查名，這是一個(gè)強(qiáng)制參數(shù)必須被指定。可以在視圖v$hm_check中查詢到該參數(shù)的值。共21個(gè)值。
.run_name:可選參數(shù)，指定一個(gè)檢查名。
.timeout:可選參數(shù)，可以設(shè)置老化時(shí)間。
.params:輸入?yún)?shù)，用于控制檢查的執(zhí)行?？梢栽谝晥Dv$hm_check_param視圖中查看。
以下是一個(gè)檢查的例子：
SQL>exec dbms_hm.run_check('Dictionary Integrity Check','HM_TEST');


這個(gè)健康檢查會存儲報(bào)告到ADR數(shù)據(jù)庫實(shí)例的home目錄中。通過adrci的show hm_run命令可以顯示這些信息：
adrci> show hm_run


.......
**********************************************************
HM RUN RECORD 2766
**********************************************************
   RUN_ID                        55361
   RUN_NAME                      HM_RUN_55361
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2015-09-28 08:58:30.714167 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2015-09-28 08:58:30.742168 +08:00
   MODIFIED_TIME                 2015-09-28 08:58:30.742168 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

**********************************************************
HM RUN RECORD 2767
**********************************************************
   RUN_ID                        55381
   RUN_NAME                      HM_RUN_55381
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2015-09-28 08:59:30.209094 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2015-09-28 08:59:30.241902 +08:00
   MODIFIED_TIME                 2015-09-28 08:59:30.241902 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>



adrci> show report hm_run testrun1
DIA-48614: HM run with name [testrun1] not found





網(wǎng)上其他人的例子：
adrci> show report hm_run testrun1
 
Data Block Check
Multiple corrupted blocks
datafile 2 contains corrupt blocks
tablespace SYSAUX is unavailable
block 66578 in datafile 2 is corrupt

adrci>
上面的報(bào)告顯示數(shù)據(jù)文件2上有壞塊，該文件屬于sysaux表空間。
所有的健康檢查報(bào)告存儲在v$hm_run視圖中，你也可以通過dbms_hm包來獲取報(bào)告：
SQL> /

NAME                             CHECK_NAME                       RUN_MODE STATUS
-------------------------------- -------------------------------- -------- -----------
HM_RUN_21                        DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_41                        DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_61                        DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_81                        DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_101                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_121                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_141                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_161                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_181                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_201                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_221                       DB Structure Integrity Check     REACTIVE COMPLETED

NAME                             CHECK_NAME                       RUN_MODE STATUS
-------------------------------- -------------------------------- -------- -----------
HM_RUN_241                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_261                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_281                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_301                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_321                       DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_341                       DB Structure Integrity Check     REACTIVE COMPLETED
.....
HM_RUN_55701                     DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_55721                     DB Structure Integrity Check     REACTIVE COMPLETED

NAME                             CHECK_NAME                       RUN_MODE STATUS
-------------------------------- -------------------------------- -------- -----------
HM_RUN_55741                     DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_55761                     DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_55781                     DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_55801                     DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_55821                     DB Structure Integrity Check     REACTIVE COMPLETED
HM_RUN_55841                     DB Structure Integrity Check     REACTIVE COMPLETED
my_run                           Dictionary Integrity Check       MANUAL   COMPLETED
HM_TEST                          Dictionary Integrity Check       MANUAL   COMPLETED
HM_RUN_1                         DB Structure Integrity Check     REACTIVE COMPLETED


my_run和HM_TEST就是我自己手動調(diào)用的。





可以查看剛剛檢查的
SQL> set long 100000
SQL> set longchunksize 1000
SQL> set pagesize 1000
SQL> set linesize 512
SQL> select DBMS_HM.GET_RUN_REPORT('HM_TEST') FROM DUAL;

DBMS_HM.GET_RUN_REPORT('HM_TEST')
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Basic Run Information
 Run Name                     : HM_TEST
 Run Id                       : 55901
 Check Name                   : Dictionary Integrity Check
 Mode                         : MANUAL
 Status                       : COMPLETED
 Start Time                   : 2015-10-15 18:17:00.890101 +08:00
 End Time                     : 2015-10-15 18:17:01.349346 +08:00
 Error Encountered            : 0
 Source Incident Id           : 0
 Number of Incidents Created  : 0

Input Paramters for the Run
 TABLE_NAME=ALL_CORE_TABLES
 CHECK_MASK=ALL

Run Findings And Recommendations

    

10余年的扎魯特旗網(wǎng)站建設(shè)經(jīng)驗(yàn)，針對設(shè)計(jì)、前端、開發(fā)、售后、文案、推廣等六對一服務(wù)，響應(yīng)快，48小時(shí)及時(shí)工作處理。全網(wǎng)營銷推廣的優(yōu)勢是能夠根據(jù)用戶設(shè)備顯示端的尺寸不同，自動調(diào)整扎魯特旗建站的顯示方式，使網(wǎng)站能夠適用不同顯示終端，在瀏覽器中調(diào)整網(wǎng)站的寬度，無論在任何一種瀏覽器上瀏覽網(wǎng)站，都能展現(xiàn)優(yōu)雅布局與設(shè)計(jì)，從而大程度地提升瀏覽體驗(yàn)。成都創(chuàng)新互聯(lián)公司從事“扎魯特旗網(wǎng)站設(shè)計(jì)”,“扎魯特旗網(wǎng)站推廣”以來，每個(gè)客戶項(xiàng)目都認(rèn)真落實(shí)執(zhí)行。

當(dāng)前題目：Oracle健康監(jiān)控器(HealthMonitor)
標(biāo)題URL：http://jinyejixie.com/article34/gdpise.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供企業(yè)建站、域名注冊、做網(wǎng)站、App設(shè)計(jì)、網(wǎng)站內(nèi)鏈、手機(jī)網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)