szkking

8 积分	0 好友	7 主题

发消息

[常规总体性能调优] 10.2.0.5的RAC，出现600错误，轮番重启

1^#

发表于 2013-5-17 15:28:14 | 查看: 3254| 回复: 4

错误代码如下：
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri May 17 14:58:21 EAT 2013
Errors in file /oraclelog/crmdb/bdump/crmdb1_reco_28430.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
Fri May 17 14:58:23 EAT 2013
Trace dumping is performing id=[cdmp_20130517145823]
Fri May 17 14:58:23 EAT 2013
Errors in file /oraclelog/crmdb/bdump/crmdb1_reco_28430.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
Fri May 17 14:58:25 EAT 2013
Errors in file /oraclelog/crmdb/bdump/crmdb1_reco_28430.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
Fri May 17 14:58:26 EAT 2013
Errors in file /oraclelog/crmdb/bdump/crmdb1_reco_28430.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
Fri May 17 14:58:26 EAT 2013

crmdb1_reco_19082.rar

383.73 KB, 下载次数: 694

trace文件

分享0

收藏0 回复只看该作者道具举报

szkking

5^#

发表于 2013-5-17 15:47:44

OK，谢谢刘大

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-5-17 15:43:47

kcbz_check_objd_typ_3=》触发了 online redo 被dump但似乎里面没有该块的修改记录

10.2.0.5.0 +RECO +kcbz_check_objd_typ_3

reco估计是在rollback某个txn

首先确认(732/903380) 对应的是那个segment吧

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-5-17 15:38:18

seg/obj: 0xa3e85 ==> 671365 磁盘上的 obj=671365
字典认为为563751

回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-5-17 15:36:27

OBJD MISMATCH typ=6, seg.obj=-2, diskobj=671365, dsflg=0, dsobj=563751, tid=563751, cls=1
Input data 0x0000000000000000, 0, 0
Formatted dump of block:
buffer tsn: 6 rdba: 0xb70dc8d4 (732/903380)
scn: 0x0c21.db31e0d0 seq: 0x01 flg: 0x04 tail: 0xe0d00601
frmt: 0x02 chkval: 0x8786 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1

Block header dump:  0xb70dc8d4
Object id on Block? Y
seg/obj: 0xa3e85  csc: 0xc21.da96cade  itc: 3  flg: E  typ: 1 - DATA
   brn: 0  bdba: 0xb70dc509 ver: 0x01 opc: 0
   inc: 0  exflg: 0

Itl          Xid                Uba       Flag  Lck       Scn/Fsc
0x01 0xffff.000.00000000  0x00000000.0000.00  C--- 0  scn 0x0c21.da96cade
0x02 0x0000.000.00000000  0x00000000.0000.00  ---- 0  fsc 0x0000.00000000
0x03 0x0000.000.00000000  0x00000000.0000.00  ---- 0  fsc 0x0000.00000000

data_block_dump,data header at 0xc00000121713407c
===============
tsiz: 0x1f80
hsiz: 0xd8
pbl: 0xc00000121713407c
bdba: 0xb70dc8d4
   76543210
flag=--------
ntab=1
nrow=99
frre=-1
fsbo=0xd8
fseo=0x40f
avsp=0x337
tosp=0x337
0xe:pti[0] nrow=99 offs=0
0x12:pri[0] offs=0x1f36
0x14:pri[1] offs=0x1eec
0x16:pri[2] offs=0x1ea5

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册