Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 266

your email information in this case!). The FDI comprises a set of technologies that are
described in Table 6.1.

TABle 6.1 Technologies Used as a Part of the FDI

Technology Name Description

Automatic capture of diag-
nostic data upon first failure

Perhaps the most exciting part of this Framework is the fact
that critical database errors (such as ORA-0600 errors) are
automatically trapped when they occur. When errors are
trapped, Oracle will quickly collect all the diagnostic files
that were created as a result of the failure. These files are
stored in an area called the Automatic Diagnostic Repository
(ADR), which we will discuss later in this chapter.

Standardized trace formats Oracle has standardized the location and format of Oracle-

generated trace files. This makes for easier problem resolution.

Health checks Oracle has created a number of health checks that run on

the Oracle Database. These checks run on a regular basis and
also when a critical database error occurs. You can also run
the health checks manually and review the results from OEM
or through V$ views in the database.

Incident Packaging Service
(IPS) and incident packages

When a critical error is detected, Oracle will create an inci-
dent package related to that failure. This incident package will
contain all of the relevant information that Oracle will need to
diagnose the problem. This reduces the workload of the DBA in
that they no longer need to look for files related to the critical
problem that occurred.

Data Recovery Advisor Integrated into the Fault Diagnostic Framework is the Data

Recovery Advisor. This tool is integrated into the Oracle
Database RMAN backup and recovery tool as well as the
database health checks. The Data Recovery Advisor can
then be used to analyze database recovery issues and
recommend correct recovery actions.

SQL Test Case Builder In cases where the issue is a SQL problem, the SQL Test Case

Builder provides a way to produce a SQL test case and send
the results of that test case to Oracle Support.

This Framework and its associated infrastructure can create a large number of files.
These files need to be stored somewhere in a logical storage structure. This storage struc-
ture is provided through the auspices of the Automatic Diagnostic Repository. Let's dis-
cuss that topic next.