The Automated diagnostics information Base (ADR) is introduced in Oracle 11g, which provides a uniform and consistent mechanism for storing, formatting, and locating all database diagnostics (EASY-TO-USE file structures). ADR associates errors with various components such as Oracle RAC, Oracle Clusterware, OCI, Net, processes, and so on, and automatically generates accidents and provides incident management capabilities for serious errors. Therefore, ADR can significantly reduce the time to solve accidents and problems.
Typically, when you use traditional initialization parameters, such as Background_dump_dest, Core_dump_ DEST, and user_dump_dest, you must use a custom procedure to manually clean the process if you want to automate the cleanup of files. Using the ADR and ADR command line interface (ADRCI), you can set up policies that control how long these files are saved:
Adrci> Set Control (shortp_policy = 360)
adrci> Set Control (Longp_policy = 4380)
When using ADR, the traditional core_dump_dest, background_dump_dest and user_dump_dest positions were changed to Diagnostic_dest. Therefore, if the parameter diagnostic_dest is specified, the position set by the original parameter is ignored.
The change in location when using ADR is 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 the diagnostic_dest is $ORACLE _home/log
However, if Oracle_base is set in the environment variable, then diagnostic_dest is set to $oracle_base.