OCP-1Z0-052-V8.02-124题
124. You executed the following commands to find the location of the alert log file:SQL> SHOW PARAMETER BACKGROUND_DUMP_DEST
NAME TYPE VALUE
-------------------- -------- ------------------------------------------
background_dump_dest string /u01/app/oracle/diag/rdbms/orcl/orcl/trace SQL> SHOW PARAMETER DIAGNOSTIC_DEST
NAME TYPE VALUE
---------------- ----------- ----------------
diagnostic_dest string /u01/app/oracle
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
Answer: AE
答案解析：
参考：http://blog.iyunv.com/rlhua/article/details/12709243
$ORACLE_BASE/diag/rdbms/<db_name>/<SID>/alert 目录中有一个XML 版本的预警日志。要通过SQL*Plus 确定预警日志的位置，请执行以下操作：· 使用SQL*Plus（或其它查询工具，如 SQL Developer）连接到数据库。· 查询V$DIAG_INFO 视图。要查看不带XML 标记的纯文本预警日志，请执行以下操作：· 在V$DIAG_INFO 查询结果中，记下对应于Diag Trace 条目的路径。将目录更改至该路径。· 使用文本编辑器打开alert_SID.log 文件。要查看XML 格式的预警日志，请执行以下操作：· 在V$DIAG_INFO 查询结果中，记下对应于Diag Alert 条目的路径。将目录更改至该路径。· 使用文本编辑器打开log.xml文件。
sys@TEST0924> select * from v$diag_info;
INST_ID NAME VALUE---------- ------------------------- -------------------------------------------------------1 Diag Enabled TRUE1 ADR Base /u01/app/oracle1 ADR Home /u01/app/oracle/diag/rdbms/test0924/test09241 Diag Trace /u01/app/oracle/diag/rdbms/test0924/test0924/trace1 Diag Alert /u01/app/oracle/diag/rdbms/test0924/test0924/alert1 Diag Incident /u01/app/oracle/diag/rdbms/test0924/test0924/incident1 Diag Cdump /u01/app/oracle/diag/rdbms/test0924/test0924/cdump1 Health Monitor /u01/app/oracle/diag/rdbms/test0924/test0924/hm1 Default Trace File /u01/app/oracle/diag/rdbms/test0924/test0924/trace/test0924_ora_24429.trc1 Active Problem Count 01 Active Incident Count 0
11 rows selected.
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]