adrci日志管理工具

来源：互联网发布：数据集成工程师编辑：程序博客网时间：2024/06/05 17:59

不同的产品和组件都有自己的日志文件，如操作系统日志、数据库告警日志、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

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

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

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是不同的。

0 0