11g automatic diagnostic repository

11G : Automatic Diagnostic Repository

Hello Everyone!!

Ebiz Apps team is working on 11g certification. Its time to get

accustomed to the changes/features introduced with 11g DB!!!

In my one of the earlier posts I have mentioned about Alert log

location change

in 11g DB and I have touched a bit about ADR.

You may would like to review alert log location change post.

Terminologies Used:

Problem: its critical error in database, Each problem will be having

problem key. eg. ora4775 error

Incident: Single occurrence of Problem

Trace: Continuous Diagnostic data generated over the lifetime of

process

Dump: type of Trace, trace generated for a single event.

Automatic Diagnostic Repository:

ADR is file based repository which stores diagnostic data, trace,

dumps, alerts and reports.

Its having specific directory structure.

ADR Directory Structure:

ADR base is determined by init.ora parameter called "diagnostic_dest"

for example

diagnostic_dest =/slot10/tkr12r3m/adr_base

Reminder:

user_dump_dest, background_dump_dest,core_dump_dest 10g init.ora

parameters are deprecated in 11g.

Advantages of ADR:

1) Reducing problem diagnostic time

2) Reducing problem solution time

3) Detecting problems proactively

4) Easy diagnosing in RAC environment

Say Whenever ora-600 occurs DBA will have to go through the errors in

the alert log, traces and have to decide which are files have to be

uploaded for Oracle Support. It requires considerable amount of

skilled DBA's time. with ADR when problem occurs you can create the

required directories (subset of ADR) as zip using IPS (Incident

Packaging Service).

ADRCI is the command line Tool introduced with 11g to work with ADR. A

simple example is given in the below picture

ADRCI is best in RAC environment. I will be explaining the usage of

ADRCI in 11g RAC.

Stay Tuned for the next update on 11g.