You executed the following commands to find the location of the alert log file:
Where is the alert log file stored? (Choose all that apply.)
A.
in the BACKGROUND_DUMP_DEST location; in text format
B.
in the BACKGROUND_DUMP_DEST location; in XML format
C.
in the BACKGROUND_DUMP_DEST location; in both text and XML format
D.
in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format
E.
in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format
F.
in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format
Why “E” is correct too?
alerts are stored in
Text format: @BACKGROUND_DUMP_DEST location>>alert_SID.log
XML format: @DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory>>log.xml
This question is tricky. What makes A and E correct is how the answers are listed. Please see response below
According to metalink note – 438148.1, beginning with Release 11g, the alert log file is written as XML formatted and as a text file (like in previous releases). The default location of both these files is the new ADR home (Automatic Diagnostic Respository, yet another new dump dest in 11g).
The ADR is set by using the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted, then, the default location of ADR is, ‘u01/oracle/product/ora11g/log’ (depends on ORACLE_HOME settings).
The location of an ADR home is given by the following path, which starts at the ADR base directory: ADR_BASE/diag/product_type/product_id/instance_id
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
Within the ADR home directory are subdirectories:
alert – The XML formatted alertlog
trace – files and text alert.log file
cdump – core files
The XML formatted alert.log is named as ‘log.xml’