TEL/電話: +86 13764045638   service@parnassusdata.com   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

 

TRACE文件中可能出现:

情景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,但是实际不存在
 
TRACE文件中显示:
 
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
 
 
这个情景下如果执行ANALYZE TABLE .. VALIDATE STRUCTUR则不会发现逻辑错误
 
 
可以通过做一个exp或者全表扫描来确认是否存在持续的无限链式行
 
 
对于以上ORA-600 [kdsgrp1]错误,一般都可以通过设置10231 EVENT来绕过的。
 
与ORA-600 [kdsgrp1]错误相关的BUG列表如下:
 

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