Which statement is true about the ADR?

View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?
Exhibit:

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *