nerdexam
Oracle

1Z0-052 · Question #149

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and…

The correct answer is F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace. In Oracle's Automatic Diagnostic Repository (ADR), the alert log is stored under ORACLE_BASE/diag/rdbms/<db_unique_name>/<instance_name>/trace/.

Performing Database Maintenance

Question

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed. What is the location of the alert_orcl.log file?

Exhibit

1Z0-052 question #149 exhibit

Options

  • AORACLE_HOME/dbs
  • BORACEL_HOME/rdbms
  • C/u01/app/oracle/admin/orcl/adump
  • D/u01/app/oracle/flash_recovery_area
  • EORACLE_BASE/diag/rdbms/orcl/alert
  • FORACLE_BASE/diag/rdbms/orcl/orcl/trace

How the community answered

(42 responses)
  • C
    2% (1)
  • D
    2% (1)
  • E
    5% (2)
  • F
    90% (38)

Why each option

In Oracle's Automatic Diagnostic Repository (ADR), the alert log is stored under ORACLE_BASE/diag/rdbms/<db_unique_name>/<instance_name>/trace/.

AORACLE_HOME/dbs

ORACLE_HOME/dbs stores initialization parameter files (init.ora, spfile) and password files, not diagnostic or alert logs.

BORACEL_HOME/rdbms

ORACLE_HOME/rdbms contains Oracle executable binaries and shared libraries, not alert log files.

C/u01/app/oracle/admin/orcl/adump

This path is the audit dump destination configured by AUDIT_FILE_DEST, not the ADR alert log location.

D/u01/app/oracle/flash_recovery_area

The flash_recovery_area is the Fast Recovery Area used for backups and archived redo logs, not for ADR diagnostic logs.

EORACLE_BASE/diag/rdbms/orcl/alert

The correct ADR path requires both the db_unique_name and instance_name subdirectories followed by 'trace'; this option omits the instance subdirectory and 'trace' folder, making it an invalid path.

FORACLE_BASE/diag/rdbms/orcl/orcl/traceCorrect

The ADR stores alert_orcl.log at ORACLE_BASE/diag/rdbms/<db_unique_name>/<instance_name>/trace/alert_<instance>.log. For the 'orcl' instance, this path resolves to ORACLE_BASE/diag/rdbms/orcl/orcl/trace, which is exactly option F.

Concept tested: Oracle ADR alert log file location

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html

Topics

#alert log#ADR#diagnostic repository#trace file location

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice