ITPub博客

首页 > 数据库 > Oracle > 11g_Automatic_Diagnostic_Repository

11g_Automatic_Diagnostic_Repository

原创 Oracle 作者:zhyuh 时间:2009-09-28 11:37:24 0 删除 编辑
Oracle 11g的目录结构有一些变化,增加了自动诊断库(Automatic Diagnostic Repository)。ADR实际上是个目录,位置由11g的新参数diagnostic_dest确定。如果设置了ORACLE_BASE环境变量,则diagnostic_dest的值就是$ORACLE_BASE,否则为$ORACLE_HOME/log。有了diagnostic_dest参数后,原先的bdump/cdump/udump等参数都失效, 此外ASM, CRS等的trace/log信息,Health Monitor报告等也都放在这里。[@more@]

察看ADR信息:
SQL> select * from v$diag_info;

INST_ID NAME VALUE
---------- ------------------------- --------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base d:apphz00540
1 ADR Home d:apphz00540diagrdbmsorclorcl
1 Diag Trace d:apphz00540diagrdbmsorclorcltrace
1 Diag Alert d:apphz00540diagrdbmsorclorclalert
1 Diag Incident d:apphz00540diagrdbmsorclorclincident
1 Diag Cdump d:apphz00540diagrdbmsorclorclcdump
1 Health Monitor d:apphz00540diagrdbmsorclorclhm
1 Default Trace File d:apphz00540diagrdbmsorclorcltraceorcl_ora_3868.trc
1 Active Problem Count 0
1 Active Incident Count 0

11 rows selected

其中:
ADR Base => Directory path for the ADR base.
ADR Home => Directory path for the ADR home for a specific database instance.
Diag Trace => The text-based alert file is stored here in addition to trace files. This directory corresponds to the old bdump directory.
Diag Alert => The XML-version alert log is found here.
Diag Incident => Location for the incident packages.
Diag Cdump => Core dump directory corresponding to cdump.
Default Trace File => Path to the session trace files (SQL trace files).


11g中引入adrci工具,方便用户和ADR交互。

C:Documents and Settingshz00540>adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期四 2月 12 14:30:31 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ADR base = "d:apphz00540"
adrci>

比较常用的命令如:
-help
-show home
-host
-set ...

个人感觉这个工具用处不是太大。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/207/viewspace-1027421/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 11g_DB_Replay
请登录后发表评论 登录
全部评论
  • 博文量
    233
  • 访问量
    2009568