Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump
USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?
A. /u01/app/oracle/product/11.1.0/db_1
B. /u01/app/oracle
C. $ORACLE_HOME/bdump
D. $ORACLE_HOME/log
Answer: B
Explanation:
Oracle Database 11g的FDI(Fault Diagnosability Infrastructure)是自动化诊断方面的又一增强。FDI的一个关键组件是自动诊断库(Automatic Diagnostic Repository-ADR)。
在Oracle Database 11g之前,Oracle的各类跟踪文件、日志文件等诊断文件的存储位置并不统一,现在在FDI的基础架构之上,Oracle开始统一规划这些文件的存储,ADR之于诊断文件,就类似于OFA(Optimal Flexible Architecture )之于数据库文件,FRA(Flash Recovery Area)之于备份文件。
ADR的路径被称为ADR BASE,这个位置由一个新的初始化参数DIAGNOSTIC_DEST决定。
SQL> show parameter DIAGNOSTIC_DEST;
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------------------------
diagnostic_dest string /u01/app/oracle
这个参数的缺省值和环境变量ORACLE_BASE有关:
如果设置了 ORACLE_BASE 则 DIAGNOSTIC_DEST = ORACLE_BASE
如果未设置 ORACLE_BASE ,则 DIAGNOSTIC_DEST = ORACLE_HOME/log
查看diag目录结构
[oracle@oel11g oracle]$ tree -d diag/
diag/
|-- rdbms
| `-- oracle11g
| `-- oracle11g
| |-- alert
| |-- cdump
| |-- hm
| |-- incident
| |-- incpkg
| |-- ir
| |-- lck
| |-- metadata
| |-- stage
| |-- sweep
| `-- trace
`-- tnslsnr
|-- oel11g
| `-- listener
| |-- alert
| |-- cdump
| |-- incident
| |-- incpkg
| |-- lck
| |-- metadata
| |-- stage
| |-- sweep
| `-- trace
`-- oel_11g
`-- listener
|-- alert
|-- cdump
|-- incident
|-- incpkg
|-- lck
|-- metadata
|-- stage
|-- sweep
`-- trace
一目了然,包括ASM、CRS等组件日志都被ADR囊括其中
Oracle可以通过一个新的视图v$diag_info来查询自动诊断库的信息:
SQL> select * from v$diag_info
INST_ID NAME VALUE
---------- ------------------------------ ------------------------------
1 Diag Enabled TRUE
1 ADR Base /u01/app/oracle
1 ADR Home /u01/app/oacle/diag/rdbms/oracle11g/
oracle11g
1 Diag Trace /u01/app/oracle/diag/rdbms/oracle11g/
oracle11g/trace
1 Diag Alert /u01/app/oracle/diag/rdbms/oracle11g/
oracle11g/alert
1 Diag Incident /u01/app/oracle/diag/rdbms/oracle11g/
oracle11g/incident
1 Diag Cdump /u01/app/oracle/diag/rdbms/oracle11g/
oracle11g/cdump
1 Health Monitor /u01/app/oracle/diag/rdbms/oracle11g/
oracle11g/hm
1 Default Trace File /u01/app/oracle/diag/rdbms/oracle11g/
oracle11g/trace/oracle11g_ora_
26773.trc
1 Active Problem Count 0
1 Active Incident Count 0
11 rows selected.
所以选择B
Thanks
Onepice
2012-09-22
转载于:http://blog.itpub.net/26474945/viewspace-744785/