从 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;