11gOCP精解 之 02

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE QUESTION NO: 2

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/