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

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.

Happy Learning!!

No comments: