New Feature of Oracle11g-Description of automatic diagnosis Data Warehouse (ADR)

From OracleDatabase11gR1, the traditional hellip; _ DUMP_DEST initialization parameters are ignored. The ADR root directory is also called the ADR base Directory, which is located by DIAGNOSTIC _

Starting from Oracle Database11g R1, the traditional hellip; _ DUMP_DEST initialization parameters are ignored. The ADR root directory is also called the ADR base Directory, which is located by DIAGNOSTIC _

I. automatic diagnosis of Data Archives (ADR)

1.1 ADR description

ADR (AutomaticDiagnostic Repository), medium. Each instance of each product stores diagnostic data in its own ADR home directory. For example, in a Real Application Clusters environment with shared storage and ASM, each database instance and each ASM instance have a main directory in ADR. The unified directory structure of ADR uses the same diagnostic data format for various products and instances, as well as a set of unified tools, enables the customer and Oracle technical support to associate and analyze the diagnostic data of multiple instances.

From Oracle Database11g R1, the traditional... _ DUMP_DEST initialization parameter. The ADR root directory is also called the ADR base directory. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left blank, the database sets DIAGNOSTIC_DEST as follows during startup:

If you have set the environment variable ORACLE_BASE, set DIAGNOSTIC_DEST to $ ORACLE_BASE.

If the environment variable ORACLE_BASE is not set, set DIAGNOSTIC_DEST to $ ORACLE_HOME/log.

-- Verification:

[18:02 oracle @ dave ~] $ Echo $ ORACLE_BASE

/U01/app/oracle

[18:03 oracle @ dave ~] $ Ora param diag

Session altered.

NAME ISDEFAULTSESMO SYSMOD VALUE

----------------------------------------------------------------------------------------

Diagnostic_dest false immediate/u01/app/oracle

I set the environment variable of ORACLE_BASE here, so the diagnostic_dest parameter here uses the value of ORACLE_BASE.

The ADR base directory can contain multiple ADR home directories, each of which is a root directory, used to store all the diagnostic data for specific Oracle products or components of a specific instance. The figure on the previous slide shows the location of the database's ADR home directory.

In addition, two alert files are generated. One is a text warning file (similar to the warning file used in earlier versions of Oracle DB), which is located in the TRACE directory of the main directory of each ADR. An XML-compliant warning message file is stored in the ALERT subdirectory of the ADR home directory. You can use the EnterpriseManager and ADRCI utilities to view warning logs in text format (XML tags have been deleted ).

The INCIDENT directory contains multiple subdirectories, each of which is named after a specific accident and only contains dump related to the accident.

The HM directory contains the Health Check Run report generated by the health monitor.

There is also a METADATA directory that contains important files of the data file library. You can compare this directory to a database dictionary. You can use ADRCI to query this dictionary.

The ADR command interpreter (ADRCI) is a utility that can be used to execute all tasks allowed by the workbench (but only in the command line environment ). Using the ADRCI utility, you can also view the name of the trace file in the ADR and delete warning logs with and without the XML tag.

You can also use V $ DIAG_INFO to list important ADR locations.

Use the tree Command to view the directory structure:

[18:11 oracle @ dave/u01/app/oracle/diag] $ tree

.

| -- Asm

| -- Clients

| -- Crs

| -- Diagtool

| -- Lsnrctl

| -- Netcman

| -- Ofm

| -- Rdbms

| '-- Dave

| -- Dave

| -- Alert

| '-- Log. xml

| -- Cdump

| -- Core_16650

| -- Core_18804

| '-- Core_6039

| -- Hm

| -- Incident

| -- Incdir_13378

| -- Dave_cjq0_161__i13378.trc

| '-- Dave_cjq0_161__i13378.trm

| -- Incdir_13458

| -- Dave_ora_18804_i13458.trc

| '-- Dave_ora_18804_i13458.trm

| '-- Incdir_8529

| -- Dave_mmnl_6039_i8529.trc

| '-- Dave_mmnl_6039_i8529.trm

| -- Incpkg

| -- Ir

| -- Lck

| -- AM_53417_1688101061.lck

| -- AM_53417_2985279723.lck

| -- AM_53419_3606358678.lck

| -- AM_53421_2401899358.lck

| -- Am_581741__241_60518.lck

| '-- Am_994187642_328766771_lck

| -- Metadata

| -- ADR_CONTROL.ams

| -- ADR_INTERNAL.mif

| -- ADR_INVALIDATION.ams

| -- AMS_XACTION.ams

| -- DDE_USER_ACTION.ams

| -- DDE_USER_ACTION_DEF.ams

| -- DDE_USER_ACTION_PARAMETER.ams

| -- DDE_USER_ACTION_PARAMETER_DEF.ams

| -- DDE_USER_INCIDENT_ACTION_MAP.ams

| -- DDE_USER_INCIDENT_TYPE.ams

| -- DFW_CONFIG_CAPTURE.ams

| -- DFW_CONFIG_ITEM.ams

| -- EM_DIAG_JOB.ams

| -- EM_TARGET_INFO.ams

| -- EM_USER_ACTIVITY.ams

| -- HM_FDG_SET.ams

| -- HM_FINDING.ams

| -- HM_INFO.ams

| -- HM_MESSAGE.ams

| -- HM_RECOMMENDATION.ams

| -- HM_RUN.ams

| -- Iney ey. ams

| -- INCIDENT. ams

| -- INCIDENT_FILE.ams

| -- INC_METER_CONFIG.ams

| -- INC_METER_IMPT_DEF.ams

| -- INC_METER_INFO.ams

| -- INC_METER_PK_IMPTS.ams

| -- INC_METER_SUMMARY.ams

| -- IPS_CONFIGURATION.ams

| -- IPS_FILE_COPY_LOG.ams

| -- IPS_FILE_METADATA.ams

| -- IPS_PACKAGE.ams

| -- IPS_PACKAGE_FILE.ams

| -- IPS_PACKAGE_HISTORY.ams

| -- IPS_PACKAGE_INCIDENT.ams

| -- IPS_PACKAGE_UNPACK_HISTORY.ams

| -- IPS_PROGRESS_LOG.ams

| -- IPS_REMOTE_PACKAGE.ams

| -- PICKLEERR. ams

| -- PROBLEM. ams

| -- SWEEPERR. ams

| -- VIEW. ams

| '-- VIEWCOL. ams

| -- Metadata_dgif

| -- Metadata_pv

| -- Stage

| -- Stg3_131__inc2.stg

| -- Stg3_131__inc.stg

| -- Stg3_13458_inc2.stg

| -- Stg3_13458_inc.stg

| -- Stg3_8529_inc2.stg

| '-- Stg3_8529_inc.stg

| -- Sweep

| '-- Trace

| -- Alert_dave.log

| -- Cdmp_20120912042233

| -- Cdmp_20121011174004

| '-- Cdmp_20121011174010

| '-- I _1.mif

'-- Tnslsnr

'-- Dave

'-- Listener

| -- Alert

| '-- Log. xml

| -- Cdump

| -- Incident

| -- Incpkg

| -- Lck

| -- AM_1096102193_3488045378.lck

| -- AM_1096102262_3454819329.lck

| -- Am_1744845641_20171997533.lck

| '-- AM_3216668543_3129272988.lck

| -- Metadata

| -- ADR_CONTROL.ams

| -- ADR_INVALIDATION.ams

| -- INC_METER_IMPT_DEF.ams

| '-- INC_METER_PK_IMPTS.ams

| -- Metadata_dgif

| -- Metadata_pv

| -- Stage

| -- Sweep

'-- Trace

'-- Listener. log

46 directories, 75 files

[18:11 oracle @ dave/u01/app/oracle/diag] $