Shulou(Shulou.com)06/01 Report--

Health Monitor (Health Monitor)

A free database health monitor has been introduced in ORACLE 11G, which is done through the DBMS_HM package.

Check the project:

1.DB structural integrity check

two。 Block and integrity check

3. Do a log integrity check in

4.Undo segment integrity check

5. Thing integrity check

6. Data dictionary integrity check

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: database check name, which is a mandatory parameter that must be specified. You can query the value of this parameter in the view v$hm_check. A total of 21 values.

.run _ name: optional parameter to specify a check name.

.timeout: optional parameter that allows you to set the aging time.

.params: enter parameters to control the execution of the check. You can view it in the view v$hm_check_param view.

The following is an example of a check:

SQL > exec dbms_hm.run_check ('Dictionary Integrity Check','HM_TEST')

This health check stores the report in the home directory of the ADR database instance. This information can be displayed through the show hm_run command of adrci:

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 purl 58 purl 30.714167 + 08:00

RESUME_TIME

END_TIME 2015-09-28 08 purl 58 purl 30.742168 + 08:00

MODIFIED_TIME 2015-09-28 08 purl 58 purl 30.742168 + 08:00

TIMEOUT 0

FLAGS 0

STATUS 5

SRC_INCIDENT_ID 0

NUM_INCIDENTS 0

ERR_NUMBER 0

REPORT_FILE

* * *

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 purl 59 purl 30.209094 + 08:00

RESUME_TIME

END_TIME 2015-09-28 08 purl 59 purl 30.241902 + 08:00

MODIFIED_TIME 2015-09-28 08 purl 59 purl 30.241902 + 08:00

TIMEOUT 0

FLAGS 0

STATUS 5

SRC_INCIDENT_ID 0

NUM_INCIDENTS 0

ERR_NUMBER 0

REPORT_FILE

Adrci > show report hm_run testrun1

DIA-48614: HM run with name [testrun1] not found

Examples of other people online:

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 >

The above report shows that there are bad blocks on data file 2, which belongs to the sysaux tablespace.

All health check-up reports are stored in the v$hm_run view, and you can also get the reports through the dbms_hm package:

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 and HM_TEST are invoked manually by myself.

You can check what you just checked.

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 purl 1714 00.890101 + 08:00

End Time: 2015-10-15 1815 17purl 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.