關於diag程式的問題

今天RAC的一臺機突然無法執行一些大的操作了，但資料庫狀態正常，經檢查發現，原來是本機磁碟滿了。暈，還有幾十G的空間，怎麼會一下子就滿了呢？查詢後發現原來是ykrac1_diag_4529.trc檔案一下子增長到了20多G，裡面全是些重複的資訊，看不懂。

[@more@]

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引數限制檔案大小，才暫時解決了問題。