View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?
A.
The text alert log file will be available in Diag Trace
B.
A copy alert log file will be kept in Diag Incident for every incident.
C.
The XML version of the alert log file will be available in Diag Trace.
D.
An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the
Health Monitor whenever an incident occurs.
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/diag001.htm
The V$DIAG_INFO view lists all important ADR locations for the current Oracle Database
instance.
The following table describes some of the information displayed by this view.The alert log is an XML file that is a chronological log of database messages and errors. It is
stored in the ADR and includes messages about the following:
– Critical errors (incidents)
– Administrative operations, such as starting up or shutting down the database, recovering
the database, creating or dropping a tablespace, and others.
– Errors during automatic refresh of a materialized view
– Other database events
You can view the alert log in text format (with the XML tags stripped) with Enterprise Manager and
with the ADRCI utility. There is also a text-formatted version of the alert log stored in the ADR for
backward compatibility. However, Oracle recommends that any parsing of the alert log contents be
done with the XML-formatted version, because the text format is unstructured and may change
from release to release. In 11g the default alert log is now in xml format, text is provided for
backward compatibility.
