不同的产品和组件都有自己的日志文件,如操作系统日志、数据库告警日志、Clusterware日志、监听日志、安装日志、执行命令的日志等。
11g推出的ADR(自动诊断资料库)是一个基于文件的资料库,不同的产品和组件都具有相同的目录结构。
Clusterware日志体系不属于ADR的管理范围,ASM、监听日志和Database日志都属于ADR的管理范围。
ADR提供了统一的命令行工具ADRCI,通过它可以方便地查看日志、跟踪信息和健康报告等。
在Grid Infrastructure和Database的安装目录下都有adrci命令,直接执行该命令就可以进入adrci的交互界面。
[grid@rac11g2 ~]$ which adrci
/u01/app/11.2.0/grid/bin/adrci
[grid@rac11g2 ~]$ adrci
ADRCI: Release 11.2.0.4.0 - Production on Fri Feb 27 02:20:46 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/grid"
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> HELP EXTENDED
HELP [topic]
Available Topics:
BEGIN BACKUP
CD
CREATE STAGING XMLSCHEMA
CREATE VIEW
DDE
DEFINE
DELETE
DESCRIBE
DROP VIEW
END BACKUP
INSERT
LIST DEFINE
MERGE ALERT
MERGE FILE
MIGRATE
QUERY
REPAIR
SELECT
SET COLUMN
SHOW CATALOG
SHOW DUMP
SHOW SECTION
SHOW TRACE
SHOW TRACEMAP
SWEEP
UNDEFINE
UPDATE
VIEW
显示当前ADR base目录:
adrci> show base
ADR base is "/u01/app/grid"
显示当前的ADR home目录:
adrci> show home
ADR Homes:
diag/asm/+asm/+ASM2
diag/tnslsnr/rac11g2/listener
设置ADR home目录:
adrci> set home diag/tnslsnr/rac11g2/listener
adrci> show home
ADR Homes:
diag/tnslsnr/rac11g2/listener
切换到Database的ADR base目录:
adrci> set base /u01/app/oracle
adrci> show base
ADR base is "/u01/app/oracle"
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl2
显示结果为数据库的ADR home目录
查看ADR home目录下的告警日志:
adrci> show alert
ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl2:
*************************************************************************
Output the results to file: /tmp/alert_2656_14052_orcl2_1.ado
查看ADR home目录下的incident事件:
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl2:
*************************************************************************
0 rows fetched
查看ADR home目录下的问题:
adrci> SHOW PROBLEM
ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl2:
*************************************************************************
0 rows fetched
显示所有的trace文件:
adrci> SHOW TRACEFILE
diag/rdbms/orcl/orcl2/trace/orcl2_vkrm_11407.trc
diag/rdbms/orcl/orcl2/trace/orcl2_ping_7978.trc
diag/rdbms/orcl/orcl2/trace/orcl2_vktm_7968.trc
... ...
adrci> SHOW TRACEFILE [-rt|-t]
-t表示按照文件修改时间正序显示,-rt表示按文件修改时间倒序显示。
adrci> SHOW TRACEFILE %mmon% -rt
获得查看trace文件更详细的帮助信息:
adrci> help show tracefile
Usage: SHOW TRACEFILE [file1 file2 ...] [-rt | -t]
[-i inc1 inc2 ...] [-path path1 path2 ...]
跟踪告警日志
adrci> show alert -tail -f
2015-02-26 22:00:37.849000 +08:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2015-02-26 22:05:49.234000 +08:00
Clusterware日志文件
除了SCAN监听器日志和用于存储OCR和表决磁盘的ASM实例日志符合ADR结构,其他Clusterware的进程和服务都不符合ADR的结构,默认存放在$GRID_HOME/log目录下。
ASM实例和监听日志文件
查看ASM实例和SCAN监听日志文件
[grid@rac11g1 ~]$ cd /u01/app/11.2.0/grid/log
[grid@rac11g1 log]$ adrci
ADRCI: Release 11.2.0.4.0 - Production on Fri Feb 27 04:38:09 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/11.2.0/grid/log"
adrci>
adrci> show alert
Choose the alert log from the following homes to view:
1: diag/tnslsnr/rac11g1/listener_scan1
2: diag/clients/user_root/host_768748950_80
Q: to quit
Please select option:
查看本地监听日志文件
[grid@rac11g1 ~]$ adrci
ADRCI: Release 11.2.0.4.0 - Production on Fri Feb 27 04:41:18 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/grid"
adrci> show alert
Choose the alert log from the following homes to view:
1: diag/asm/+asm/+ASM1
2: diag/tnslsnr/rac11g1/listener
Q: to quit
Please select option:
注意:登录ADRCI控制台的时候,一定注意提示中出现的ADR base所在位置。切换到不同的系统目录执行adrci命令进入的adrci环境的ADR base是不同的。