ADR - Automatic Diagnostic Repository (introduced in Oracle 11g) is a system managed repository for storing database alert logs, trace files, and any other diagnostic data previously controlled by any other init.ora parameters.
init.ora parameter DIAGNOSTIC_DEST is the base location for all diagnostic directories. There are seperate directories for the ASM database and the database (rdbms) instance.
init.ora parameter DIAGNOSTIC_DEST is the base location for all diagnostic directories. There are seperate directories for the ASM database and the database (rdbms) instance.
SQL> show parameter diag NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string /u01/app/oracle SQL> SQL> show parameter dump_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/tes tdb/DB11G/trace core_dump_dest string /u01/app/oracle/diag/rdbms/tes tdb/DB11G/cdump user_dump_dest string /u01/app/oracle/diag/rdbms/tes tdb/DB11G/trace SQL> SQL> desc v$diag_info; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ INST_ID NUMBER NAME VARCHAR2(64) VALUE VARCHAR2(512) SQL> col value format a60 SQL> col name format a32 SQL> select name,value from v$diag_info; NAME VALUE -------------------------------- ------------------------------------------------------------ Diag Enabled TRUE ADR Base /u01/app/oracle ADR Home /u01/app/oracle/diag/rdbms/testdb/DB11G Diag Trace /u01/app/oracle/diag/rdbms/testdb/DB11G/trace Diag Alert /u01/app/oracle/diag/rdbms/testdb/DB11G/alert Diag Incident /u01/app/oracle/diag/rdbms/testdb/DB11G/incident Diag Cdump /u01/app/oracle/diag/rdbms/testdb/DB11G/cdump Health Monitor /u01/app/oracle/diag/rdbms/testdb/DB11G/hm Default Trace File /u01/app/oracle/diag/rdbms/testdb/DB11G/trace/DB11G_ora_2215 8.trc Active Problem Count 0 Active Incident Count 0 11 rows selected. SQL> SQL> host [oracle@usha dbs]$ cd /u01/app/oracle [oracle@usha oracle]$ ls -ltr total 32 drwxrwxr-x. 3 oracle oinstall 4096 Nov 19 17:19 product drwxr-x---. 3 oracle oinstall 4096 Nov 19 18:05 admin drwxr-x---. 3 oracle oinstall 4096 Nov 19 18:05 oradata drwxrwxr-x. 4 oracle oinstall 4096 Nov 19 18:05 diag drwxr-x---. 4 oracle oinstall 4096 Nov 19 18:07 flash_recovery_area drwxr-xr-x. 5 oracle oinstall 4096 Nov 19 18:12 cfgtoollogs drwxr-x---. 3 oracle oinstall 4096 Nov 19 18:13 oradiag_oracle drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 18:16 checkpoints [oracle@usha oracle]$ cd diag [oracle@usha diag]$ ls -ltr total 8 drwxr-xr-x. 3 oracle oinstall 4096 Nov 19 18:03 tnslsnr drwxr-x---. 3 oracle oinstall 4096 Nov 19 18:05 rdbms [oracle@usha diag]$ cd rdbms [oracle@usha rdbms]$ ls -ltr total 4 drwxr-x---. 4 oracle oinstall 4096 Nov 19 19:48 testdb [oracle@usha rdbms]$ cd testdb [oracle@usha testdb]$ ls -ltr total 8 drwxr-x---. 13 oracle oinstall 4096 Nov 19 18:05 testdb -rw-r-----. 1 oracle oinstall 0 Nov 19 18:05 i_1.mif drwxr-xr-x. 13 oracle oinstall 4096 Nov 19 19:48 DB11G [oracle@usha testdb]$ cd DB11G [oracle@usha DB11G]$ ls -ltr total 52 drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:48 incident drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:48 hm drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:48 sweep drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:48 stage drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:48 incpkg drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:48 cdump drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 19:49 alert drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 20:50 metadata drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 20:50 lck drwxr-xr-x. 2 oracle oinstall 4096 Nov 19 20:50 ir drwxr-xr-x. 2 oracle oinstall 12288 Feb 4 02:02 trace [oracle@usha DB11G]$ cd ../testdb [oracle@usha testdb]$ ls -ltr total 44 drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 sweep drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 stage drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 ir drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 incpkg drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 incident drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 hm drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 cdump drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:05 alert drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:07 metadata drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:07 lck drwxr-x---. 2 oracle oinstall 4096 Nov 19 18:14 trace [oracle@usha testdb]$ |