OCP-1Z0-053-200题-40题-619

QUESTION 40

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 Incidentfor 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.

Answer: A

同619题：http://blog.csdn.net/rlhua/article/details/19070785

Explanation/Reference:

Section: Database Architecture & Resource Management, RAC, ASM

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/diag001.htm

The V$DIAG_INFO view lists all important ADR locationsfor 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 storedin the ADR

and includes messages about the following:

- Critical errors (incidents)

- Administrative operations, such as starting upor 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.