Diagnostic Destination in 11g

Introduced in 11g, DIAGNOSTIC_DEST initialization parameter can be used to set user, core, background dump destination. These had to be individually set or would default to $ORACLE_HOME/dbs.

DIAGNOSTIC_DEST now contains all the ADR (Automatic Diagnostic Repository) files which includes alerts, trace, core dumps etc.

It follows the following structure.

{diagnostic_dest}/diag/rdbms/{dbname}/{instname}

and breaks down further into

{diagnostic_dest}/diag/rdbms/{dbname}/{instname}/alert
{diagnostic_dest}/diag/rdbms/{dbname}/{instname}/incident
{diagnostic_dest}/diag/rdbms/{dbname}/{instname}/trace
and so on...


Alert : Contains XML LOG (alert)
Incident : Core dumps and other incident dumps
Trace : Background (bdump) and alert_$ORACLE_SID.log