1Z0-052 · Question #132
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.)
The correct answer is A. in the BACKGROUND_DUMP_DEST location; in text format E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format. Starting with Oracle 11g ADR, the alert log exists in two separate locations and formats: text in the BACKGROUND_DUMP_DEST trace directory and XML in the ADR alert subdirectory.
Question
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.)
Exhibit
Options
- Ain the BACKGROUND_DUMP_DEST location; in text format
- Bin the BACKGROUND_DUMP_DEST location; in XML format
- Cin the BACKGROUND_DUMP_DEST location; in both text and XML format
- Din the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format
- Ein the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format
- Fin the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format
How the community answered
(30 responses)- A90% (27)
- C3% (1)
- D7% (2)
Why each option
Starting with Oracle 11g ADR, the alert log exists in two separate locations and formats: text in the BACKGROUND_DUMP_DEST trace directory and XML in the ADR alert subdirectory.
BACKGROUND_DUMP_DEST now maps to the ADR trace directory ($DIAGNOSTIC_DEST/diag/rdbms/<db>/<instance>/trace), which contains the traditional text-format alert log named alert_<SID>.log, preserving backward compatibility with pre-11g tooling.
BACKGROUND_DUMP_DEST points to the trace directory, which holds only the text-format alert log; the XML log.xml resides in the separate alert subdirectory and is not present under BACKGROUND_DUMP_DEST.
BACKGROUND_DUMP_DEST contains only the text-format alert log and does not also hold an XML copy.
The DIAGNOSTIC_DEST/.../alert directory stores only the XML-format log; the text-format alert_<SID>.log lives in the trace directory, not the alert directory.
The ADR alert subdirectory ($DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert) stores the alert log exclusively in XML format as log.xml, which is the native format consumed by the ADRCI utility and the V$DIAG_ALERT_EXT view.
The DIAGNOSTIC_DEST/.../alert directory contains only the XML-format log and does not also store a text version.
Concept tested: Oracle 11g ADR alert log dual-format dual-location storage
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html
Topics
Community Discussion
No community discussion yet for this question.