Automatic Diagnostic Workflow
Automatic Diagnostic Repository
查看ADR(Automatic Diagnositc Repository)方法有三:
- 通过OEM support workbench
- ADRCI - ADR Command-Line(ADR命令行)
- V$DIAG_INFO(动态性能视图)
The ADR Command-Line Tool(ADRCI)
ADRCI procides interaction with ADR from an operating system prompt.
Using ADRCI,you can view diagnostic data within the Automatic Diagnostic Repository.
C:\Users\MaryHu>adrci ADRCI: Release 11.2.0.1.0 - Production on Thu Jun 6 11:26:46 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. ADR base = "d:\app\maryhu" adrci> show incident ADR Home = d:\app\maryhu\diag\clients\user_maryhu\host_4069264964_76: ************************************************************************* 0 rows fetched ADR Home = d:\app\maryhu\diag\clients\user_system\host_4069264964_76: ************************************************************************* 0 rows fetched ADR Home = d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb: ************************************************************************* INCIDENT_ID PROBLEM_KEY CREATE_TIME -------------------- ----------------------------------------------------------- ---------------------------------------- 119105 ORA 1578 2013-06-06 10:13:39.372000 +08:00 119106 ORA 1578 2013-06-06 10:20:13.896000 +08:00 119107 ORA 1578 2013-06-06 10:20:22.077000 +08:00 119108 ORA 1578 2013-06-06 10:20:32.162000 +08:00 4 rows fetched adrci>
The V$DIAG_INFO View
SQL> SELECT * FROM V$DIAG_INFO; INST_ID NAME VALUE ---------- ------------------------------ ------------------------------------------------------------------------------------------ 1 Diag Enabled TRUE 1 ADR Base d:\app\maryhu 1 ADR Home d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb 1 Diag Trace d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb\trace 1 Diag Alert d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb\alert 1 Diag Incident d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb\incident 1 Diag Cdump d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb\cdump 1 Health Monitor d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb\hm 1 Default Trace File d:\app\maryhu\diag\rdbms\arcerzhangdb\arcerzhangdb\trace\arcerzhangdb_ora_19196.trc 1 Active Problem Count 1 1 Active Incident Count 4 11 rows selected.
Location for Diagnostic Traces
| Diag Data | Previous Location | ADR Location |
| Foreground process traces | USER_DUMP_DEST | ADR_HOME/trace |
| Background process traces | BACKGROUND_DUMP_DEST | ADR_HOME/trace |
| Alert log data | BACKGROUND_DUMP_DEST |
ADR_HOME/alert ADR_HOME/trace |
| Core dumps | CORE_DUMP_DEST | ADR_HOME/cdump |
| Incident dumps | USER|BACKGROUND_DUMP_DEST | ADR_HOME/incident/incdir_n |
关于ADR参数配置信息说明
SQL> show parameter dump NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string d:\app\maryhu\diag\rdbms\arcer zhangdb\arcerzhangdb\trace core_dump_dest string d:\app\maryhu\diag\rdbms\arcer zhangdb\arcerzhangdb\cdump max_dump_file_size string unlimited shadow_core_dump string none user_dump_dest string d:\app\maryhu\diag\rdbms\arcer zhangdb\arcerzhangdb\trace SQL> show parameter diag NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string D:\APP\MARYHU
在11g以前的版本，有很多dump参数信息需要特别指定(background_core_dump,background_dump_dest等)，11g以后有关ADR相关的参数信息，只要配置diagnostic_dest这一个参数即可，其他相关的dump参数信息，oracle会自动配置到该参数指定的目录下.