12c集群日志位置_Oracle 19C RAC 集群日志位置变化

作者 | JiekeXu

来源 | JiekeXu之路(ID: JiekeXu_IT)

转载请联系授权 | (微信ID：xxq1426321293)

大家好，我是 JiekeXu,很高兴又和大家见面了，今天分享一篇 Oracle 19C RAC 集群日志位置变化

。

本文首发于墨天轮，欢迎点击上方蓝字关注我，标星或置顶，更多干货第一时间到达！

有些时候，当数据库出现故障，尤其是当数据库集群无法启动时，这时候就需要查看各种日志来分析定位问题。例如db 的alert 日志，集群日志，ASM 日志，操作系统日志等等，下面来一起看着怎么查找日志，尤其是 12C 以后的数据库集群日志由于新特性而发生变化，更加不好查找。

在 oracle 11g 时查看数据库后台日志，一般会使用视图v$diag_info 或者参数 dump 来查看,当然安装规范的话，也可以直接cd 查看。

cd $ORACLE_BASE/diag/rdbms/{db_name}/{SID}/trace/alter{SID}.log

SQL> set line456 pages 345SQL> col NAMEfor a30SQL> col VALUEfor a88SQL> select * from v$diag_info;INST_ID NAME VALUE---------------------------------------- ----------------------------------------------------------------------------------------2 Diag Enabled TRUE2 ADR Base /app/oracle2 ADR Home /app/oracle/diag/rdbms/Jiekedb/Jiekedb22 Diag Trace /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/trace2 Diag Alert /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/alert2 Diag Incident /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/incident2 Diag Cdump /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/cdump2 Health Monitor /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/hm2 Default Trace File /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/trace/Jiekedb2_ora_1212.trc2 Active Problem Count 22 Active Incident Count 511 rows selected.SQL> showparameter dumpNAME TYPE VALUE----------------------------------------------- ------------------------------background_core_dump string partialbackground_dump_dest                 string      /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/tracecore_dump_dest                       string      /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/cdumpmax_dump_file_size string unlimitedshadow_core_dump string partialuser_dump_dest                       string      /app/oracle/diag/rdbms/Jiekedb/Jiekedb2/trace

ASM日志位置

$ORACLE_BASE/diag/asm/+asm/SID/tracecd $ORACLE_BASE/diag/asm/+asm/+ASM2/traceJiekeXur2:/app/grid/diag/asm/+asm/+ASM2/trace$ls alert*alert_+ASM2.logJiekeXur2:/app/grid/diag/asm/+asm/+ASM2/trace$pwd/app/grid/diag/asm/+asm/+ASM2/trace

当然也可以在 ASM 实例中查看

JiekeXur2:/home/grid$sqlplus / as sysasmSQL*Plus: Release11.2.0.4.0 Production on Fri Dec 18 17:13:19 2020Copyright (c)1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the RealApplication Clusters and Automatic Storage Management optionsSQL> showparameter dumpNAME TYPE VALUE--------------------------------------------------------------------- ------------------------------background_core_dump string partialbackground_dump_dest                 string                            /app/grid/diag/asm/+asm/+ASM2/tracecore_dump_dest                       string                            /app/grid/diag/asm/+asm/+ASM2/cdumpmax_dump_file_size string 100Mshadow_core_dump string partialuser_dump