Beginning with Release 11g, Oracle Database includes an advanced fault diagnosability infrastructure for preventing, detecting, diagnosing, and resolving problems. This note helps to understandthenew11g infrastructure known as Automatic Diagnostic Repository.
Audience: Oracle 11g Users and DBAs who want to know about ADR.
11g Understanding Automatic Diagnostic Repository.
What is New in 11g?
In 11g, RDBMS diagnostic data has been reorganized and is stored inside a common directory structure, the Automatic Diagnostic Repository (ADR). An ADR is a centralized directory structure where one can find trace files, alert messages, incident dumps, core files, etc.
Automatic Diagnostic Repository ( ADR ) :
All trace files, core files, and the alert files are now organized into a directory structure comprising the Automatic Diagnostic Repository (ADR).
The ADR is a file-based repository for database diagnostic data. It has a unified directory structure across multiple instances and multiple products.
Beginning with Release 11g, the database, Automatic Storage Management (ASM), Cluster Ready Services (CRS), and other Oracle products or components store all diagnostic data in the ADR. Each instance of each product stores diagnostic data underneath its own ADR home directory.
For example, in an Oracle Real Application Clusters environment with shared storage and ASM, each database instance and each ASM instance has a home directory within the ADR. ADR's unified directory structure, consistent diagnostic data formats across products and instances, and a unified set of tools enable customers and Oracle Support to correlate and analyze diagnostic data across multiple instances.
Problems and Incidents :
Problem : is a critical error in the database
Eg : ora-600 , ora-7445 , ora-4031 etc.
Problem key : Every problem has a problem key, which is a text string that includes an error code (such as ORA 600) and in some cases, one or more error parameters.
Eg: ‘ORA 4030’ , ‘ORA 600 [ktfacht1-0]’
Incident : is a single occurance of a problem . Each incident has a numeric incident id.
Where is ADR located :
The location of the ADR is controlled by the Oracle "diagnostic_dest" parameter.
Path specified in the 'diagnostic_dest' parameter defines the ADR root directory,ADR BASE.
The first subdirectory inside an ADR (under the <adr_base> directory) is always named "diag"
For example, if the 'diagnostic_dest' and thus the <adr_base> is specified as "$ORACLE_HOME/log", then expect to find the subdirectory "$ORACLE_HOME/log/diag". Below this will be <adr_home> .
Any number of instances/components can share same ADR BASE. Under ADR BASE there will be individual ADR HOMES.
Under ADR BASE ,the address of an <adr_home> will be similar to :
diag/<product_type>/<prod_id>/<instance_id>.
Inside each ADR home, you can find several subdirectories, each for storing a specific type of diagnostic data. Among the subdirectories, you should be able to find TRACE, ALERT, INCIDENT, CDUMP etc.
ADR HOME contents :
You will find the following directories under ADR HOME -
Alert : The alert directory contains the XML alert log
Cdump : core dumps are stored in this directory
Trace : Process trace files and Alert.log are stored in the trace directory. 'Background_dump_dest' and 'user_dump_dest' are now ignored in 11g. Now all the trace files will be generated in 'trace' directory.
Incident: The incident directory stores dump files created when critical errors are encountered.
Each occurrence of a critical error( incident ) is given its own incident directory, with the incident ID used to form the directory name.
Metadata : The metadata directory stores a series of files that contain diagnostic metadata.
HM : The hm directory stores reports for health checks
Incpkg, ir, lck, sweep : These directories contain internal diagnosability framework state.
DIAGNOSTIC_DEST - Default value :
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log
V$DIAG_INFO :
For each database , you can query v$diag_info to check its ADR locations.
This shows us the ADR BASE , ADR home , trace file locations , XML Alert location , incident dump locations , core dump and health monitor reports.
Also gives us the default session trace ( for the current session ) and number of problems , incidents reported in the database.
ADR Command Interpreter (ADRCI) :
ADRCI is the command line utility using which ADR is accessed.
Enter the following command at the operating system command prompt:
%]ADRCI
The utility starts and displays the following prompt:
adrci>
There are various commands that can be executed from 'adrci' to view Alert log , trace files , incidents reported , etc.
There is no need to log in to ADRCI, because the data in ADR is just for diagnostic purposes and not intended to be secure. ADR data is secured only by operating system permissions on the ADR directories.
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
你查看CD-R、CD-RW以及DVD光盘中的文件结构完整性与信息显示。对于读取不顺畅的CD-RW它也可以恢复资料的完整。支援ATAPI/IDE与SCSI界面。 注:此软件为多语言版,如发现安装简体中文版不能正常运行,请卸载后重新...
主要介绍了Oracle11g的自动诊断信息库,需要的朋友可以参考下
新增 Wonders语言水平测试工具 Wonders Placement and Diagnostic Assessment.pdf
Bao Steel Lean Manufacturing Diagnostic Storyline.doc
CANoe.DiVa_ Fully-automated diagnostic validation.rar
CANoe.DiVa_ Fully-automated diagnostic validation.mp4
下载下来在客户端执行一下可以检测你客户端计算机连接WSUS的状态, 测试连接的过程zd中如果有错误会有红色的字符提醒。
Clinical prediction model to aid emergency doctors managing febrile children at risk of serious bacterial infections_ diagnostic study.pdf
UCI机器学习数据集,Breast Cancer Wisconsin (Diagnostic) Data Set,已整理,有Excel格式文件
IPC diagnostic设置
芯烨打印机设置工具
利用Oracle Automatic Diagnostic Repository和Oracle Repair Advisor更高效地对故障情况做出响应 使用Oracle Recovery Manager、Oracle Data Pump Export和Oracle Data Pump Import备份和恢复表、表空间和...
利用Oracle Automatic Diagnostic Repository和Oracle Repair Advisor更高效地对故障情况做出响应 使用Oracle Recovery Manager、Oracle Data Pump Export和Oracle Data Pump Import备份和恢复表、表空间和...
02 Create a New Diagnostic Specification
02 Create a New Diagnostic Specification
1_Intro_04 Diagnostic Services
软件介绍: 芯烨打印机专用的调试工具,用于设定打印机功能,可校正感应器、设定网络参数、设定RTC信息、初始化打印机、设定密码、开启除错模式等等。有些黑标打印纸出现无法检测问题时,可以使用这个工具进行调整...
PDF文档资源下载