Gunther Oracle APEX und Datenbank Wiki

Siehe auch ⇒ Oracle 11g RMAN - Data Recovery Advisor

Passende Oracle Enterprise Manager Incident - Metric zum dem Feature ist: ⇒ „Checker run found %% new persistent data failures“

column name format a40

select name 
   from v$hm_check
where  internal_check='N'
/   

NAME
--------------------------------------
DB Structure Integrity Check
CF Block Integrity Check
Data Block Integrity Check
Redo Integrity Check
Transaction Integrity Check
Undo Segment Integrity Check
Dictionary Integrity Check
ASM Allocation Check

SET pages 300 LINES 300
 
COLUMN check_name format a40
COLUMN parameter_name format a20
COLUMN description format a40
COLUMN TYPE format a15
COLUMN default_value format a20 heading "Default|value"
 
SELECT c.name check_name
     , p.name parameter_name
     , p.type
     , p.default_value
     , p.description
 FROM v$hm_check_param p, v$hm_check c
WHERE p.check_id = c.id 
  AND c.internal_check = 'N'
ORDER BY c.name
/
 
 
 
                                                                              DEFAULT
CHECK_NAME                               PARAMETER_NAME       TYPE            VALUE                DESCRIPTION
---------------------------------------- -------------------- --------------- -------------------- ----------------------------------------
ASM Allocation CHECK                     ASM_DISK_GRP_NAME    DBKH_PARAM_TEXT                      ASM GROUP name
CF Block Integrity CHECK                 CF_BL_NUM            DBKH_PARAM_UB4                       Control file block NUMBER
DATA Block Integrity CHECK               BLC_DF_NUM           DBKH_PARAM_UB4                       File NUMBER
DATA Block Integrity CHECK               BLC_BL_NUM           DBKH_PARAM_UB4                       Block NUMBER
Dictionary Integrity CHECK               CHECK_MASK           DBKH_PARAM_TEXT ALL                  CHECK mask
Dictionary Integrity CHECK               TABLE_NAME           DBKH_PARAM_TEXT ALL_CORE_TABLES      TABLE name
Redo Integrity CHECK                     SCN_TEXT             DBKH_PARAM_TEXT 0                    SCN OF the latest good redo (IF known)
TRANSACTION Integrity CHECK              TXN_ID               DBKH_PARAM_TEXT                      TRANSACTION ID
Undo Segment Integrity CHECK             USN_NUMBER           DBKH_PARAM_TEXT                      Undo segment NUMBER
 
9 ROWS selected.

Mit DBMS_HM.run_check kann ein Check durchgeführt werden, über den Parameter „input_params“ können die obigen Parameter im „Paramter=Wert“ Stil übergeben werden.

Die Integrität der Datenbank prüfen:

sql>BEGIN
  DBMS_HM.run_check (
    check_name   => 'DB Structure Integrity Check',
    run_name     => 'GPI_RUN_23_21_2014_v3');
END;
/
 
sql>SET long 62000
 
SELECT DBMS_HM.get_run_report('GPI_RUN_23_21_2014_v3')  AS report
  FROM dual
/

Die Ergebnisse eines Checks werden auch als Text Datei in der ADRCI Struktur der Datenbank abgelegt.

adrci> set home diag\rdbms\gpi\gpi
 
adrci> show hm_run
 
adrci> create report hm_run GPI_RUN_23_21_2014_v3
 
adrci> show report hm_run GPI_RUN_23_21_2014_v3

DB Views für den Health Monitor:

• V$HM_RUN
• V$HM_FINDING
• V$HM_RECOMMENDATION

Oracle:

• https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag007.htm#ADMIN11269
• 11g R2 Package DBMS_HM ⇒ https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_hm.htm

Im Netz:

• http://oracle-base.com/articles/11g/data-recovery-advisor-11gr1.php