今天RAC的一台机突然无法执行一些大的操作了,但数据库状态正常,经检查发现,原来是本机磁盘满了。晕,还有几十G的空间,怎么会一下子就满了呢?查找后发现原来是ykrac1_diag_4529.trc文件一下子增长到了20多G,里面全是些重复的信息,看不懂。
GCS RESOURCE 0xeab368e4 hashq [0xe9b33574,0xefe3ad98] name[0xfc32d.90000] pkey 53578grant 0x5fffbf88 cvt (nil) send (nil),0 write (nil),0@65535flag 0x0 mdrole 0x1 mode 1 scan 0 role LOCALdisk: 0x0000.00000000 write: 0x0000.00000000 cnt 0x0 hist 0x0xid 0x0000.000.00000000 sid 0pkey 53578hv 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 0x0lb 0, hb 0, myb 10341, drmb 5221, apifrz 0GCS SHADOW 0x5fffbf88,1 sq[0xede47f08,0xeab368fc] resp[0xeab368e4,0xfc32d.90000] pkey 53578grant 1 cvt 0 mdrole 0x21 st 0x40 GRANTQ rl LOCALmaster 0 owner 0 sid 0 remote[(nil),0] hist 0x467dfhistory 0x1f.0x1f.0x6.0x1.0x0.0x0. cflag 0x0 sender 0 flags 0x0 replay# 0disk: 0x0000.00000000 write request: 0x0000.00000000pi scn: 0x0000.00000000 msgseq 0x0 updseq 0x0 reqids[1,0,0] infop 0x0GLOBAL CACHE ELEMENT DUMP (address: 0x5fffbf40):id1: 0xfc32d id2: 0x90000 obj: 53578 block: (9/1033005)lock: SL rls: 0x0000 acq: 0x0000 latch: 5flags: 0x41 fair: 0 recovery: 0 fpin: 'kdiwh100: kdircys'bscn: 0x0.0 bctx: (nil) write: 0 scan: 0x0 xflg: 0 xid: 0x0.0.0lcp: (nil) lnk: [NULL] lch: [0x98f88ed4,0x98f88ed4]seq: 10 hist: 3 227 160 3 227 160 66 144:0 192 352LIST OF BUFFERS LINKED TO THIS GLOBAL CACHE ELEMENT:flg: 0x00080000 state: SCURRENT mode: NULLaddr: 0x98f88e24 obj: 53578 cls: DATA bscn: 0x1.6808edbeGCS SHADOW 0xede47f08,2 sq[0xeab368fc,0x5fffbf88] resp[0xeab368e4,0xfc32d.90000] pkey 53578grant 1 cvt 0 mdrole 0x21 st 0x40 GRANTQ rl LOCALmaster 0 owner 1 sid 0 remote[0x28fc2018,43] hist 0x197cc079history 0x39.0x1.0xc.0x1f.0x19.0x0. cflag 0x0 sender 0 flags 0x0 replay# 0disk: 0x0000.00000000 write request: 0x0000.00000000pi 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.trcFri Jan 5 15:14:35 2007System State dumped to trace file /opt/oracle/admin/ykrac/bdump/ykrac1_diag_4529.trcFri Jan 5 15:14:39 2007Trace dumping is performing id=[cdmp_20070105151439]
到itpub上问eygle大师,也未解决
http://www.itpub.net/thread-697094-1-1.html
最后没办法只能使用max_dump_file_size参数限制文件大小,才暂时解决了问题。
转载于:https://www.cnblogs.com/seawwh/archive/2011/11/04/2236151.html
