1.108 DIAGNOSTIC_DEST
As of Oracle Database 11g Release 1 (11.1), the diagnostics for each database instance are located in a dedicated directory that is specified by the DIAGNOSTIC_DEST
initialization parameter.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
Derived from the value of the |
Modifiable |
|
Modifiable in a PDB |
No |
Basic |
No |
Oracle RAC |
This parameter can be set on each instance. Oracle recommends that each instance in a cluster specify a |
The structure of the directory specified by DIAGNOSTIC_DEST
is as follows:
<diagnostic_dest>/diag/rdbms/<dbname>/<instname>
This location is known as the Automatic Diagnostic Repository (ADR) Home. For example, if the database name is proddb
and the instance name is proddb1
, the ADR home directory would be <diagnostic_dest>/diag/rdbms/proddb/proddb1
.
The following files are located under the ADR home directory:
-
Trace files - located in subdirectory
<adr-home>/trace
-
Alert logs - located in subdirectory
<adr-home>/alert
. In addition, thealert.log
file is now in XML format, which conforms to the Oracle ARB logging standard. -
Core files - located in the subdirectory
<adr-home>/cdump
-
Incident files - the occurrence of each serious error (for example, ORA-600, ORA-1578, ORA-7445) causes an incident to be created. Each incident is assigned an ID and dumping for each incident (error stack, call stack, block dumps, and so on) is stored in its own file, separated from process trace files. Incident dump files are located in
<adr-home>/incident/<incdir#>
. You can find the incident dump file location inside the process trace file.
See Also:
Oracle Automatic Storage Management Administrator's Guide for an example of the diagnostic directory for an Oracle ASM instance