Oracle 的 Alert 日志

从 Oracle 11g 开始，Oracle 数据库以XML与传统的文本两种格式提供 Alert 日志。
新的日志位置由 Automatic Diagnostic Repository (ADR) 决定。可以通过新的初始化
参数 DIAGNOSTIC_DEST 控制 ADR BASE 的位置。


sys@TICKET> show parameter dump;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      d:\app\administrator\diag\rdbm
                                                 s\ticket\ticket\trace
core_dump_dest                       string      D:\APP\ADMINISTRATOR\DIAG\RDBM
                                                 S\TICKET\TICKET\CDUMP
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      none
user_dump_dest                       string      d:\app\administrator\diag\rdbms\ticket\ticket\trace

默认在alert_log在background_dump_dest对应的目录

sys@TICKET> show parameter diagnostic_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest                      string      D:\APP\ADMINISTRATOR
如果没有设定这个初始化参数的位置，而设置 ORACLE_BASE 环境变量的话，那么，如果没有设定 ORACLE_BASE ,
 则 ORACLE_HOME/log 即为 DIAGNOSTIC_DEST。
一些都在这个目录下的日志列表：
D:/app/Administrator/diag>dir
2010/05/21  21:00    <DIR>          asm
2010/05/27  16:55    <DIR>          clients
2010/05/21  21:00    <DIR>          crs
2010/05/21  21:00    <DIR>          diagtool
2010/05/21  21:00    <DIR>          lsnrctl
2010/05/21  21:00    <DIR>          netcman
2010/05/21  21:00    <DIR>          ofm
2010/06/07  13:56    <DIR>          rdbms
2010/05/21  21:00    <DIR>          tnslsnr
               0 个文件              0 字节
              11 个目录 21,367,534,592 可用字节


sys@TICKET> desc v$diag_info;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 INST_ID                                            NUMBER
 NAME                                               VARCHAR2(64)
 VALUE                                              VARCHAR2(512)

sys@TICKET> col name for a50;
sys@TICKET> col value for a60;
sys@TICKET> select * from v$diag_info;

   INST_ID NAME
---------- --------------------------------------------------
VALUE
------------------------------------------------------------
         1 Diag Enabled
TRUE

         1 ADR Base
d:\app\administrator

         1 ADR Home
d:\app\administrator\diag\rdbms\ticket\ticket

         1 Diag Trace
d:\app\administrator\diag\rdbms\ticket\ticket\trace

         1 Diag Alert
d:\app\administrator\diag\rdbms\ticket\ticket\alert

         1 Diag Incident
d:\app\administrator\diag\rdbms\ticket\ticket\incident

         1 Diag Cdump
D:\APP\ADMINISTRATOR\DIAG\RDBMS\TICKET\TICKET\CDUMP

         1 Health Monitor
d:\app\administrator\diag\rdbms\ticket\ticket\hm

         1 Default Trace File
d:\app\administrator\diag\rdbms\ticket\ticket\trace\ticket_ora_64772.trc

         1 Active Problem Count
3

         1 Active Incident Count
8


已选择11行。

sys@TICKET> select value from v$diag_info where name ='Diag Alert';

VALUE
------------------------------------------------------------
d:\app\administrator\diag\rdbms\ticket\ticket\alert

sys@TICKET> select value from v$diag_info where name ='Diag Trace';

VALUE
------------------------------------------------------------
d:\app\administrator\diag\rdbms\ticket\ticket\trace

sys@TICKET> host

sys@TICKET> spool off;