在/u01/app/oracle/diag/rdbms///trace目录下,存在大量到.trc/ .trm文件,占用174G空间,而且备库2节点有,备库1节点没有出现这个问题。 截取一个trc部分信息,头部-尾部,还请帮忙判断下是否存在异常。Trace file /u01/app/oracle/diag/rdbms///trace/_lmsc_48852.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: SunOS
Node name:
Release: 5.11
Version: 11.3
Machine: sun4v
Instance name:
Redo thread mounted by this instance: 0
Oracle process number: 25
Unix process pid: 48852, image: oracle@ (LMSC)
*** 2019-02-27 23:43:58.616
*** SESSION ID:(126.1) 2019-02-27 23:43:58.616
*** CLIENT ID:() 2019-02-27 23:43:58.616
*** SERVICE NAME:() 2019-02-27 23:43:58.616
*** MODULE NAME:() 2019-02-27 23:43:58.616
*** ACTION NAME:() 2019-02-27 23:43:58.616
KSXPCINI: kjxgnpub KSXP 2.2.0GESR013 13, 0
2019-02-27 23:43:58.779239 : 0 GCS shadows cancelled, 0 closed, 0 Xw survived
2019-02-27 23:43:58.784830 : 0 GCS resources traversed, 0 cancelled
2019-02-27 23:43:58.803842 : 0 GCS shadows traversed, 0 replayed, 0 duplicates, 0 not replayed, dissolve 0 timeout 0
RCFG(2) lms 12 finished replaying gcs resources
2019-02-27 23:43:58.804983 : 0 write requests issued in 0 GCS resources
0 PIs marked suspect, 0 flush PI msgs
2019-02-27 23:43:58.805130 : 0 write requests issued in 0 GCS resources
0 PIs marked suspect, 0 flush PI msgs
·················
*** 2019-03-28 14:17:36.957
2019-03-28 14:17:36.957649 : GSIPC:PING: send PINGREQ[17522] to 1.13 (seq 0.47) stm 0x8c62287c
2019-03-28 14:17:36.958134 : GSIPC:PING: rcv'd PINGACK[17522] from 1.13 elptm 0 usec
*** 2019-03-28 14:18:13.057
2019-03-28 14:18:13.057373 : GSIPC:PING: rcv'd PINGREQ[17521] from 1.13 (seq 0.172) stm 0xbb6dc4e8
2019-03-28 14:18:13.057559 : GSIPC:PING: send PINGACK[17521] to 1.13 (seq 0.172)
2019-03-28 14:19:57.883460 : GSIPC:PING: send PINGREQ[17523] to 1.13 (seq 0.47) stm 0x94c886e6
*** 2019-03-28 14:19:57.883
2019-03-28 14:19:57.883948 : GSIPC:PING: rcv'd PINGACK[17523] from 1.13 elptm 0 usec
*** 2019-03-28 14:20:35.025
2019-03-28 14:20:35.025810 : GSIPC:PING: rcv'd PINGREQ[17522] from 1.13 (seq 0.172) stm 0xc3e40c5b
2019-03-28 14:20:35.026005 : GSIPC:PING: send PINGACK[17522] to 1.13 (seq 0.172)
*** 2019-03-28 14:22:18.807
2019-03-28 14:22:18.807884 : GSIPC:PING: send PINGREQ[17524] to 1.13 (seq 0.47) stm 0x9d2ede06
2019-03-28 14:22:18.808385 : GSIPC:PING: rcv'd PINGACK[17524] from