关于diag进程的问题

今天RAC的一台机突然无法执行一些大的操作了，但数据库状态正常，经检查发现，原来是本机磁盘满了。晕，还有几十G的空间，怎么会一下子就满了呢？查找后发现原来是ykrac1_diag_4529.trc文件一下子增长到了20多G，里面全是些重复的信息，看不懂。

 

GCS RESOURCE 0xeab368e4 hashq [0xe9b33574,0xefe3ad98] name[0xfc32d.90000] pkey 53578
grant 0x5fffbf88 cvt (nil) send (nil),0 write (nil),0@65535
flag 0x0 mdrole 0x1 mode 1 scan 0 role LOCAL
disk: 0x0000.00000000 write: 0x0000.00000000 cnt 0x0 hist 0x0
xid 0x0000.000.00000000 sid 0
pkey 53578
hv 6 [stat 0x0, 0->0, wm 32767, RMno 0, reminc 20, dom 0]
kjga st 0x4, step 0.0.0, cinc 20, rmno 64, flags 0x0
lb 0, hb 0, myb 10341, drmb 5221, apifrz 0
GCS SHADOW 0x5fffbf88,1 sq[0xede47f08,0xeab368fc] resp[0xeab368e4,0xfc32d.90000] pkey 53578
grant 1 cvt 0 mdrole 0x21 st 0x40 GRANTQ rl LOCAL
master 0 owner 0 sid 0 remote[(nil),0] hist 0x467df
history 0x1f.0x1f.0x6.0x1.0x0.0x0. cflag 0x0 sender 0 flags 0x0 replay# 0
disk: 0x0000.00000000 write request: 0x0000.00000000
pi scn: 0x0000.00000000
msgseq 0x0 updseq 0x0 reqids[1,0,0] infop 0x0
GLOBAL CACHE ELEMENT DUMP (address: 0x5fffbf40):
id1: 0xfc32d id2: 0x90000 obj: 53578 block: (9/1033005)
lock: SL rls: 0x0000 acq: 0x0000 latch: 5
flags: 0x41 fair: 0 recovery: 0 fpin: 'kdiwh100: kdircys'
bscn: 0x0.0 bctx: (nil) write: 0 scan: 0x0 xflg: 0 xid: 0x0.0.0
lcp: (nil) lnk: [NULL] lch: [0x98f88ed4,0x98f88ed4]
seq: 10 hist: 3 227 160 3 227 160 66 144:0 192 352
LIST OF BUFFERS LINKED TO THIS GLOBAL CACHE ELEMENT:
flg: 0x00080000 state: SCURRENT mode: NULL
addr: 0x98f88e24 obj: 53578 cls: DATA bscn: 0x1.6808edbe
GCS SHADOW 0xede47f08,2 sq[0xeab368fc,0x5fffbf88] resp[0xeab368e4,0xfc32d.90000] pkey 53578
grant 1 cvt 0 mdrole 0x21 st 0x40 GRANTQ rl LOCAL
master 0 owner 1 sid 0 remote[0x28fc2018,43] hist 0x197cc079
history 0x39.0x1.0xc.0x1f.0x19.0x0. cflag 0x0 sender 0 flags 0x0 replay# 0
disk: 0x0000.00000000 write request: 0x0000.00000000
pi scn: 0x0000.00000000
msgseq 0x1 updseq 0x0 reqids[50,0,0] infop 0x0

alert文件中也没发现什么异常

Trace dumping is performing id=[cdmp_20070105151418]
System State dumped to trace file /opt/oracle/admin/ykrac/bdump/ykrac1_diag_4529.trc
Fri Jan 5 15:14:35 2007
System State dumped to trace file /opt/oracle/admin/ykrac/bdump/ykrac1_diag_4529.trc
Fri Jan 5 15:14:39 2007
Trace dumping is performing id=[cdmp_20070105151439]

到itpub上问eygle大师，也未解决

http://www.itpub.net/thread-697094-1-1.html

最后没办法只能使用max_dump_file_size参数限制文件大小，才暂时解决了问题。