Oracle 11g Health Monitor Checks

2)SQLPLUS中查看报告

SQL> SET LONG 100000
SQL> SET LONGCHUNKSIZE 1000
SQL> SET PAGESIZE 1000
SQL> SET LINESIZE 512
SQL> SELECT DBMS_HM.GET_RUN_REPORT(‘Dict_Check‘) FROM DUAL;

DBMS_HM.GET_RUN_REPORT(‘DICTCHECK‘)
---------------------------------------------------------
Basic Run Information
 Run Name                     : Dict Check
 Run Id                       : 55001
 Check Name                   : Dictionary Integrity Check
 Mode                         : MANUAL
 Status                       : COMPLETED
 Start Time                   : 2019-07-03 09:49:44.365864 +08:00
 End Time                     : 2019-07-03 09:50:04.668621 +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
v
Run Findings And Recommendations
 Finding
 Finding Name  : Dictionary Inconsistency
 Finding ID    : 55002
 Type          : FAILURE
 Status        : OPEN
 Priority      : CRITICAL
 Message       : SQL dictionary health check: analyzetime for object new than
               sysdate 12 on object TAB$ failed
 Message       : Damaged rowid is AAAAACAABAAAACRAAC - description: Object
               SYS.UNDO$ is referenced
 Finding
 Finding Name  : Dictionary Inconsistency
 Finding ID    : 55005
 Type          : FAILURE
 Status        : OPEN
 Priority      : CRITICAL
 Message       : SQL dictionary health check: analyzetime for object new than
               sysdate 12 on object TAB$ failed
 Message       : Damaged rowid is AAAAACAABAAAACVAAA - description: Object
               SYS.SEQ$ is referenced

3)adrci中查看报告

ADRCI: Release 11.2.0.4.0 - Production on Wed Jul 3 09:52:43 2019

Copyright (c) 1982,2011,Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/oracle"
adrci> show hm_run

ADR Home = /u01/app/oracle/diag/tnslsnr/prodb/listener:
*************************************************************************
...
**********************************************************
HM RUN RECORD 130
**********************************************************
   RUN_ID                        56581
   RUN_NAME                      Dict_Check
   CHECK_NAME                    Dictionary Integrity Check
   NAME_ID                       24
   MODE                          0
   START_TIME                    2019-07-03 09:58:40.350313 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2019-07-03 09:58:56.425829 +08:00
   MODIFIED_TIME                 2019-07-03 09:58:56.425829 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

adrci> create report hm_run Dict_Check
adrci> show report hm_run Dict_Check
...
adrci> show hm_run
**********************************************************
HM RUN RECORD 130
**********************************************************
   RUN_ID                        56581
   RUN_NAME                      Dict_Check
   CHECK_NAME                    Dictionary Integrity Check
   NAME_ID                       24
   MODE                          0
   START_TIME                    2019-07-03 09:58:40.350313 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2019-07-03 09:58:56.425829 +08:00
   MODIFIED_TIME                 2019-07-03 09:59:40.845354 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   /u01/app/oracle/diag/rdbms/PROD/PROD/hm/HMREPORT_Dict_Check.hm

   已生成REPORT_FILE，xml格式。

其他：

（编辑：安卓应用网_福州站长网）

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