We go to bdump and access the alert.log
file whenever we have to analyze an issue in the database.
However In
11g, RDBMS diagnostic data has been reorganized and is stored inside a common
directory structure, the Automatic Diagnostic Repository (ADR). An ADR is a
centralized directory structure where one can find trace files, alert messages,
incident dumps, core files, etc. This parameter is set by DIAGNOSTIC_DEST
initialization parameter.
You will find the following directories under ADR HOME -
Alert : The alert directory contains the XML alert log
Cdump : core dumps are stored in this directory
Trace : Process trace files and Alert.log are stored in the trace directory. 'Background_dump_dest' and 'user_dump_dest' are now ignored in 11g. Now all the trace files will be generated in 'trace' directory.
Incident : The incident directory stores dump files created when critical errors are encountered.
Each occurrence of a critical error( incident ) is given its own incident directory, with the incident ID used to form the directory name.
Metadata : The metadata directory stores a series of files that contain diagnostic metadata.
HM : The hm directory stores reports for health checks
Incpkg, ir, lck, sweep : These directories contain internal diagnosability framework state.
Alert : The alert directory contains the XML alert log
Cdump : core dumps are stored in this directory
Trace : Process trace files and Alert.log are stored in the trace directory. 'Background_dump_dest' and 'user_dump_dest' are now ignored in 11g. Now all the trace files will be generated in 'trace' directory.
Incident : The incident directory stores dump files created when critical errors are encountered.
Each occurrence of a critical error( incident ) is given its own incident directory, with the incident ID used to form the directory name.
Metadata : The metadata directory stores a series of files that contain diagnostic metadata.
HM : The hm directory stores reports for health checks
Incpkg, ir, lck, sweep : These directories contain internal diagnosability framework state.
ADRCI is the command line utility using which ADR is
accessed.
---- To view the alert log file:
Example
$ adrci
ADRCI:
Release 11.2.0.2.0 - Production on Wed Aug 1 12:02
Copyright
(c) 1982, 2009, Oracle and/or its affiliates. All rights reserved
ADR base = “/d01/app/oracle”
ADRCI > show alert –tail –f
---- ADRCI can also be used to
track a problem and an incident:
Example: Whenever there is a problem recorded in the alert
log file, we also get a message stating: Use ADRCI or Support Workbench to package the incident.
Adrci can be used to know more about the problem and the incident:
ADRCI > show problem
ADRCI > show incident
ADRCI > show incident -mode detail -p "incident_id="
---- ADRCI can also be used for :
- Incident Packaging Service (IPS): To send details of the problem to oracle support through a package or a zip file.
- Purge trace files. Example: ADRCI> purge –age 1440 –type trace (1440 is minutes, ie, one day. So all trace files older than 1 day will be purged).
