• [bbk5392] 第92集 第11章 数据库诊断 08


    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>
    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.
    通过动态性能视图查看ADR info

    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
    ADR parameter after 11g 

     在11g以前的版本,有很多dump参数信息需要特别指定(background_core_dump,background_dump_dest等),11g以后有关ADR相关的参数信息,只要配置diagnostic_dest这一个参数即可,其他相关的dump参数信息,oracle会自动配置到该参数指定的目录下.

  • 相关阅读:
    今天解决了一个很郁闷的问题!
    解决了安装golive后html文件图标显示错误的问题
    [转载]Asp.Net 2.0 发布问题
    使用 Visual Studio 2005 构建“WPFE”项目
    Ajax学习网址备忘录
    [原创首发]深圳博客问测系统正式发布啦!
    如何在用户控件里联动Dropdownlist
    [转载]在ASP.NET中值得注意的两个地方
    [转]Prototype 1.5 Ajax 使用教程
    1038 Recover the Smallest Number (30 分)(贪心)
  • 原文地址:https://www.cnblogs.com/arcer/p/3120856.html
Copyright © 2020-2023  润新知