OCP 1Z0 053 29

29.Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle 
Database 11g? (Choose two.) 
A. A single ADR can support multiple ADR homes for different database instances. 
B. The alert files are stored in XML file format in the TRACE directory of each ADR home. 
C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to 
$ORACLE_BASE.  
D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST 
initialization parameter for the location of the alert log file. 
Answer: AC 

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

Automatic Diagnostic Repository (ADR)

The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health monitor reports, and more. It has a unified directory structure across multiple instances and multiple products. Beginning with Release 11g, the database, Automatic Storage Management (ASM), and other Oracle products or components store all diagnostic data in the ADR. Each instance of each product stores diagnostic data underneath its own home directory within the ADR. For example, in an Oracle Real Application Clusters environment with shared storage and ASM, each database instance and each ASM instance has an ADR home directory. ADR's unified directory structure, consistent diagnostic data formats across products and instances, and a unified set of tools enable customers and Oracle Support to correlate and analyze diagnostic data across multiple instances.

The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:

• If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.

• If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.