oracle alert下的文件,oracle 11g中 alert文件的变化

最近安装个11g rac，准备学习下。

想看一下log日志，找了半天才找到，原来11g的alert log做了变动，从Oracle 11g 开始，oracle以xml和文本两种格式提供Alert日志。

日志位置由Automatic Diagnostic Repository (ADR) 决定，并提供ADRCI Command-Line Utility命令行工具

可以通过新的初始化参数 DIAGNOSTIC_DEST控制ADR BASE的位置，注：一个存放数据库诊断日志、跟踪文件的目录，称作ADR base，对应初始化参数DIAGNOSTIC_DEST，如果设置了ORACLE_BASE环境变量，

DIAGNOSTIC_DEST等于ORACLE_BASE，如果没有设置ORACLE_BASE，则等与ORACLE_HOME/log

SQL> show parameter dia

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

diagnostic_dest                      string      /u01/app/oracle

SQL> select * from v$diag_info;

INST_ID NAME                      VALUE

---------- ------------------------- ------------------------------------------------------------------------------------------

2 Diag Enabled              TRUE

2 ADR Base                  /u01/app/oracle

2 ADR Home                  /u01/app/oracle/diag/rdbms/sykdb/sykdb2

2 Diag Trace                /u01/app/oracle/diag/rdbms/sykdb/sykdb2/trace

2 Diag Alert                /u01/app/oracle/diag/rdbms/sykdb/sykdb2/alert

2 Diag Incident             /u01/app/oracle/diag/rdbms/sykdb/sykdb2/incident

2 Diag Cdump                /u01/app/oracle/diag/rdbms/sykdb/sykdb2/cdump

2 Health Monitor            /u01/app/oracle/diag/rdbms/sykdb/sykdb2/hm

2 Default Trace File        /u01/app/oracle/diag/rdbms/sykdb/sykdb2/trace/sykdb2_ora_10081.trc

2 Active Problem Count      0

2 Active Incident Count     0

11 rows selected.

SQL>

命令行工具adrci

[oracle@syk1 ~]$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Wed May 2 16:33:23 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/oracle" adrci> help