Automatic Health Monitor :
It is similar to advisors introduced in 10g. The Automatic Health Monitor "checkers" monitor (automatically after a failure or on demand) various components, such as the datafiles and dictionary, to make sure they are not corrupted physically or logically. IPS (Incident Packaging Service) is used to bundle all supporting files for use to Oracle Support.
EM Navigation :
Database page -> Related Links -> Advisor Central -> Advisors and Checkers -> Checkers
DB Structure Integrity Check
Data Block Integrity Checker
Redo Integrity Check
Undo Segment Integrity Check
Transaction Integrity Check
Dictionary Integrity Check
Checkers generate reports of their findings and recommendations for resolving problems.
Run Type : "Manual" and "Reactive" (automatic). We can follow the suggestions from the above health check runs.
Data Recovery Advisor :
Using OEM : Availability> Manage> Perform Recovery> Perform Automated Repair
Automatic Diagnostic Repository :
All the critical events in the database are recorded in a repository called Automatic Diagnostic Repository. It is newly introduced in 11g.
It is a new directory structure which can be set using diagnostic_dest ( Default ORACLE_BASE ).
EM Navigation :
Database page -> Software and Support -> Support Workbench
Navigate to the corresponding issue/error/incident and create a package( all required info for Oracle Support ) and then pass it to support.
We can use Configuration Manager to pass the collected pacakge to Oracle Support.
We can also collect the packages using the command line utility ( ADRCI )
ADR Home :
The Automatic Diagnostic Repository (ADR) is a file system repository to store diagnostic data source such as alter log, trace files, user and background dump files, and also new types of troubleshooting files such as Health Monitor reports, Incident packages, SQL test cases and Data repair records.
This is the same DIAGNOSTIC_DEST value. This home stores all the logs and traces of all the oracle components like ASM, CRS, listener, DB at a single location unlike oracle 10g.
Configuring ADR :
Set value for init.ora parameter DIAGNOSTIC_DEST
Query the view V$DIAG_INFO to display all the ADR-related locations (also number of active problems and incidents):
Using the Tool :
Problems and Incidents :
Problem is a critical error occurred in the database. Each problem has a problem key. The problem key consists of the Oracle error number and error argument. Here is an example: ORA 600 .
The first time a problem occurs, an incident is also created. When the same problem takes place again, another incident will be generated for the same problem i.e relation between problem and incident is one to many. Thus, you may have multiple incidents for a one problem.
When an incident occurs, Oracle performs the following:
a) An alert will be issued.
b) An entry will be added in the alert log file.
c) Related data will be stored in the ADR directory.
IMPORTANT TABLES :
==== DEMO DEMO DEMO DEMO DEMO DEMO ========
=== ====== DEMO ON IPS ========= =========
Incident Packaging Service (IPS) wraps up all information about an incident and allows you to send the whole package to Oracle Support.
=== ====== DEMO ON HEALTH MONITOR =========
METHOD 3 :
METHOD 4 :
Using EM tool also we can view the report.
Resiliency - Automatic Health Monitor And Diagnostics