Overview of Oracle 11g Automatic Diagnostic Information Base of Automatic Diagnostic Repository ADR

The Automatic Diagnostic Information Base (ADR) is introduced in Oracle 11g, which provides a unified mechanism for storing, formatting and locating all database diagnostic information (an easy-to-use file structure). ADR correlates errors of various components (such as Oracle RAC, Oracle Clusterware, OCI, Net, processes, etc.), and automatically generates and provides incident management functions for serious errors. Therefore, ADR can significantly reduce the time to solve accidents and problems.

Usually, when using traditional initialization parameters, such as BACKGROUND_DUMP_DEST, CORE_DUMP_ DEST, USER_DUMP_DEST, etc., if you want the file cleaning process to be automated, you must use custom procedures to clean it manually. With the command-line interface of ADR and ADR (ADRCI), you can set policies that control how long these files are saved:

adrci> set control (SHORTP_POLICY = 360 )
adrci> set control (LONGP_POLICY = 4380 )

When ADR is used, the traditional positions of CORE_DUMP_DEST, BACKGROUND_DUMP_DEST and USER_DUMP_DEST are changed to DIAGNOSTIC_DEST. Therefore, if the parameter DIAGNOSTIC_DEST is specified, the position set by the original parameter is ignored.

The position changes when using ADR are as follows:

Original location new location
CORE_DUMP_DEST DIAGNOSTIC_DEST/diag/rdbms/ < DBNAME > / < INSTANCENAME > /cdump
BACKGROUND_DUMP_DEST
(Alert Log text)
(Alert Log XML) DIAGNOSTIC_DEST/diag/rdbms/ < DBNAME > / < INSTANCENAME > /trace
DIAGNOSTIC_DEST/diag/rdbms/ < DBNAME > / < INSTANCENAME > /alert
BACKGROUND_DUMP_DEST DIAGNOSTIC_DEST/diag/rdbms/ < DBNAME > / < INSTANCENAME > /trace
USER_DUMP_DEST DIAGNOSTIC_DEST/diag/rdbms/ < DBNAME > / < INSTANCENAME > /trace

The following is an abbreviated list of ADR file locations:

DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/trace
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/alert
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/cdump
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/incident
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/hm
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/incpkg
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/ir
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/lck
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/metadata
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/sweep
DIAGNOSTIC_DEST/diag/rdbms/<DBNAME>/<INSTANCENAME>/stage

By default, the location of DIAGNOSTIC_DEST is $ORACLE_HOME/log

However, if ORACLE_BASE is set in the environment variable, DIAGNOSTIC_DEST is set to $ORACLE_BASE.