ORACLE集群在做问题排查时,需要查看日志。这些日志都集群中都是存放在那里的? 1.集群相关日志主要放在$ORACLE_CRS_HOME/log,$ORACLE_HOME/log中。 $ORACLE_CRS_HOME/log目录下内容如下 [oracle@rac1 log]$ pwd /u01/app/11.2.0/11ggrid/log [oracle@rac1 log]$ ls crs/ diag/ rac1/ [oracle@rac1 log]$ $ORACLE_HOME/log内容如下 [oracle@rac1 log]$ cd $ORACLE_HOME [oracle@rac1 dbhome_1]$ cd log [oracle@rac1 log]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/log [oracle@rac1 log]$ ls diag/ rac1/ [oracle@rac1 log]$ 2.具体日志与目录的对应说明 CRS日志存放在$ORACLE_CRS_HOME/log/HOSTNAME/crsd下[oracle@rac1 crsd]$ pwd /u01/app/11.2.0/11ggrid/log/rac1/crsd [oracle@rac1 crsd]$ ll total 6212 -rw-r--r-- 1 root root 6338257 Sep 21 22:24 crsd.log -rw-r--r-- 1 root root 812 Sep 7 00:06 crsdOUT.log -rw-r--r-- 1 root root 114 Aug 7 20:10 crsd.trc[oracle@rac1 crsd]$ tail -10 crsd.log TextMessage[rac1] WAIT: TextMessage[0] ] 2012-09-21 22:24:01.928: [UiServer][2604460944] Container [ Name: UI_DATA RESULT: TextMessage[223] ] 2012-09-21 22:24:01.928: [UiServer][2604460944] Done for ctx=0xc605e68 2012-09-21 22:24:01.937: [ CRSCCL][2648554384]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 130 msglen = 991 clschdr.size_clscmsgh= 1079 src= (1, 4294366130) dest= (2, 4294385480) [oracle@rac1 crsd]$CSS日志存放在“$ORA_CRS_HOME/log//cssd”目录 [oracle@rac1 cssd]$ pwd /u01/app/11.2.0/11ggrid/log/rac1/cssd [oracle@rac1 cssd]$ ls cssdOUT.log ocssd.l01 ocssd.l02 ocssd.l03 ocssd.l04 ocssd.log ocssd.trc [oracle@rac1 cssd]$ more cssdOUT.log 08/07/12 20:08:56: CSSD starting 08/07/12 20:11:08: CSSD starting 08/15/12 23:23:27: CSSD starting 08/17/12 19:48:02: CSSD handling signal 15 08/17/12 19:48:02: CSSD killed 08/17/12 19:50:12: CSSD starting 08/17/12 22:42:00: CSSD handling signal 15 08/17/12 22:42:00: CSSD killed 08/17/12 22:44:22: CSSD starting 08/18/12 22:17:57: CSSD handling signal 15 08/18/12 22:17:57: CSSD killed 08/18/12 22:20:10: CSSD starting 09/07/12 00:05:14: CSSD starting [oracle@rac1 cssd]$EVM日志存放在“$ORA_CRS_HOME/log//evmd”目录 [oracle@rac1 evmd]$ pwd /u01/app/11.2.0/11ggrid/log/rac1/evmd [oracle@rac1 evmd]$ ls evmd.log evmdOUT.log evmd.trc [oracle@rac1 evmd]$ more evmd.log Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009 Oracle. All rights reserved. [ clsdmt][3046398864]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=rac1DBG_EVMD)) 2012-08-07 20:12:17.831: [ clsdmt][3046398864]PID for the Process [19602], connkey 2 2012-08-07 20:12:17.839: [ clsdmt][3046398864]Creating PID [19602] file for home /u 01/app/11.2.0/11ggrid host rac1 bin evm to /u01/app/11.2.0/11ggrid/evm/init/ 2012-08-07 20:12:17.865: [ clsdmt][3046398864]Writing PID [19602] to the file [/u01 /app/11.2.0/11ggrid/evm/init/rac1.pid] 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CLSVER 0 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CLUCLS 0 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: COMMCR S 0 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: COMMNS 0 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CRSOCR 0 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CSSCLN T 0 2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: EVMAGE NT 0 2012-08-07 20:12:18.303: [ default][3046692560] ENV Logging level for Module: EVMAPP 0 2012-08-07 20:12:18.303: [ default][3046692560] ENV Logging level for Module: EVMCOM M 0 2012-08-07 20:12:18.303: [ EVMD][3046692560] ENV Logging level for Module: EVMD 0 --More--(1%) $ORA_CRS_HOME/log/和$ORACLE_HOME/log/目录中的racg目录中记录了RACG可执行文件对应的日志 [oracle@rac1 racg]$ pwd /u01/app/11.2.0/11ggrid/log/rac1/racg [oracle@rac1 racg]$ ls racgeut/ racgevtf/ racgmain/ [oracle@rac1 racg]$ $ORA_CRS_HOME/log//client和$ORACLE_HOME/log //client”目录记录了与srvctl、ocrdump、ocrconfig以及ocrcheck命令对应的日志 信息。 [oracle@rac1 rac1]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/log/rac1 [oracle@rac1 rac1]$ ls client/ [oracle@rac1 rac1]$ [[oracle@rac1 client]$ pwd /u01/app/11.2.0/11ggrid/log/rac1/client [oracle@rac1 client]$ ls clscfg.log ocrcheck_25681.log oifcfg11.trc oifcfg6.trc crsctl.log ocrcheck_6982.log oifcfg12.trc oifcfg7.trc crsctl.trc ocrconfig_17191.log oifcfg13.trc oifcfg8.trc gpnptool_17951.log ocrconfig_17634.log oifcfg14.trc oifcfg9.trc gpnptool_17951.trc ocrconfig_18620.log oifcfg1.trc oifcfg.log gpnptool_17959.log ocrconfig_20321.log oifcfg2.trc oifcfg.trc gpnptool_17959.trc ocrconfig_25725.log oifcfg3.trc olsnodes.log oclskd.log ocrdump_25560.log oifcfg4.trc olsnodes.trc ocrcheck_16786.log oifcfg10.trc oifcfg5.trc [oracle@rac1 client]$ 集群中ALERT文件的位置$ORACLE_CRS_HOME/LOG/HOSTNAME下 [oracle@rac1 rac1]$ pwd /u01/app/11.2.0/11ggrid/log/rac1 [oracle@rac1 rac1]$ ls admin/ alertrac1.log crsd/ ctssd/ evmd/ gnsd/ mdnsd/ racg/ agent/ client/ cssd/ diskmon/ gipcd/ gpnpd/ ohasd/ srvm/ [oracle@rac1 rac1]$
oracle rac事务日志,ORACLE 11G RAC--日志路径
最新推荐文章于 2021-04-15 19:42:58 发布