TEL/電話: +86 13764045638   7 x 24 online!

【Oracle数据恢复】解析ORA-600 [kdsgrp1]错误

【Oracle数据恢复】解析ORA-600 [kdsgrp1]错误

ORA-00600[kdsgrp1]错误从10g开始被引入,具体针对bug 2442351,这个kdsgrp1错误号是特别针对数据块做的一个额外的健康检查,如果发生了该错误,那么一般是Oracle检测到一个空的行头了。

引发该ORA-600 [kdsgrp1]报错的一般场景是:

  1. 索引所指向的行记录被发现在表上其实并不真实存在
  2. 一个链式行指向不存在的ROWID



情景1 表和索引的不一致

row 02433566.13 continuation at
file# 9 block# 210278 slot 20 not found
这里的file=9 block=210278 即rdba=0x02433566是由索引指出的
row#3[7549] flag: ------, lock: 0, len=85, data:(6): 02 43 35 66 00 14
但是对应的SLOT 20则在块中并不真实存在
tab 0, row 1, @0x1e62
tl: 2 fb: --HDFL-- lb: 0x3
tab 0, row 12, @0x191a
tl: 2 fb: --HDFL-- lb: 0x1
tab 0, row 17, @0x1675
tl: 2 fb: --HDFL-- lb: 0x2
tab 0, row 21, @0x1459
tl: 2 fb: --HDFL-- lb: 0x4
如果执行analyze 命令:analyze table <table name> validate structure cascade;, 则可能出现ORA-1499错误
情景2 一行指向另一个ROWID,但是实际不存在
row 1186b11a.ffffffff continuation at
file# 70 block# 441621 slot 1 not found
其代表该rdba 0x1186b11a的行的后续部分在file# 70 block# 441621 slot 1.
但是可惜的是file# 70 block# 441621 slot 1却并不存在:
tab 0, row 16, @0xd7f ---> This is the slot with the problem.
tl: 29 fb: -------- lb: 0x0 cc: 11
nrid: 0x1186bd15.1
对于以上ORA-600 [kdsgrp1]错误,一般都可以通过设置10231 EVENT来绕过的。
与ORA-600 [kdsgrp1]错误相关的BUG列表如下:

NB Bug Fixed Description
13614906 ORA-600 [kdsgrp1] due to missing weak changes from an XA transaction in RAC - superceded
13146182,, ORA-1499 ORA-8102 ORA-600 [kdsgrp1] Bitmap Index / Table mismatch
12619529 ORA-600[kdsgrp1] from SELECT on plugged in tablespace with FLASHBACK
10633840,,, ORA-1502 on insert statement on INTERVAL partitioned table. ORA-8102 / ORA-1499 Index
10329146,,,,,, Lost write in ASM with multiple DBWs and a disk is offlined and then onlined
10245259,, PARALLEL INSERT with +NOAPPEND hint or if PARALLEL INSERT plan is executed in SERIAL
corrupts index and causes wrong results
+ 10209232,,,,,, ORA-1578 / ORA-600 [3020] Corruption. Misplaced Blocks and Lost Write in ASM
9770451,,,, ORA-600 [20022] with bitmap indexes
+ 9734539, ORA-8102 / ORA-1499 corrupt index after update/merge using QUERY REWRITE
+ 9469117,,, Corrupt index after PDML executed in serial. Wrong results. OERI[kdsgrp1]/ORA-1499 by
9457185,, Intermittent ORA-600 [kdsgrp1] during CR read
+ 9231605,,,, Block corruption with missing row on a compressed table after DELETE
* 9145541,,, OERI[25027]/OERI[4097]/OERI[4000]/ORA-1555 in plugged datafile after CREATE
9061269, ORA-600 [kdsgrp1] executing CTX_QUERY.COUNT_HITS during concurrent sync Text index
+ 8951812, Corrupt index by rebuild online. Possible OERI [kddummy_blkchk] by SMON
8837919, DBV / RMAN enhanced to detect ASSM blocks with ktbfbseg but not ktbfexthd flag set as in
Bug 8803762
8803762,,,, ORA-600[kdsgrp1], ORA-600[25027] or wrong results on 11g database upgrade from 9i
8771916,,,, OERI [kdsgrp1] during CR read
P 8635179,, Solaris: directio may be disabled for RAC file access. Corruption / Lost Write
+ 8597106,, Lost Write in ASM when normal redundancy is used
+ 8546356,,,, ORA-8102/ORA-1499/OERI[kdsgrp1] Composite Partitioned Index corruption after rebuild
7710827, Index rebuild or Merge partition causes wrong results in concurrent reads instead of ORA-
7705591,,,, Corruption with self-referenced row in MSSM tablespace. Wrong Results / OERI[6749] / ORA-
7251049,, Corruption in bitmap index introduced when using transportable tablespaces
P 12330911 12.1 EXADATA LSI firmware for lost writes
8650661, OERI / corruption type errors using global transactions in RAC
8588540, Corruption / ORA-8102 in RAC with loopback DB links between instances
7682186 ORA-600[kdsgrp1] on consistent read in RAC with global transaction
+ 7329252,,, ORA-8102/ORA-1499/OERI[kdsgrp1] Index corruption after rebuild index ONLINE
7289224 ORA-600 [kdsgrp1] on CR read with parallel query
6791996 ORA-600 errors for a DELETE with self referencing FK constraint and BITMAP index
6445948,,, Intermitent ORA-600 [kdsgrp1] accessing table with a LONG
6404058,, OERI:12700 OERI:kdsgrp1 OERI:qertbFetchByRowID wrong results from CR rollback of split
index leaf
6129296 ORA-600 [kdsgrp1] by PARALLEL select for update with LOB
6772911, OERI[12700] OERI[qertbFetchByRowID] OERI[kdsgrp1] due to bad CR rollback of INDEX block
5621677, Logical corruption with PARALLEL update
5374225, SDO_FILTER query fails with OERI[kdsgrp1]
5368945, ORA-600 [kdsgrp1] on Index Organized Table with Overflow
4883635, MERGE (with DELETE) can produce wrong results or Logical corruption in chained rows
3408192,, Heavy concurrent DML scenarios can cause $R table to contain deleted rowids


Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.