使用范围：
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
HP-UX PA-RISC (64-bit)
HP-UX Itanium

详情：
Index Organized Tables (IOT) can become corrupt if the associated tablespace was transported (TTS or Transportable Database) from a different Operating System Platform to HP (XTT / XTTS).

TTS= Transportable Tablespace.
XTT / XTTS =Transportable Tablespace from a different OS platform.

当我们使用传输表空间功能时，从其他平台到HP的平台造成让索引组织表损坏

相关事件：
When using TTS or Transportable Database to HP:

HP-UX Itanium / HP-UX IA (64-bit)
HP-UX PA-RISC (64-bit) / HP-UX (64-bit)

from any of the next platforms: --也就是下面的平台传输到HP平台会造成上述问题

Linux x86 32-bit
Linux x86 64-bit
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit) / Solaris Operating System (x86-64)
IBM AIX on POWER Systems (64-bit) / AIX-Based Systems (64-bit)

症状：

ORA-600 [6200] can be produced or ORA-600 [kddummy_blkchk] [file#] [block#] [6401] if db_block_checking is set to TRUE/FULL.

and the trace file may contain the corruption details like for example:

Block Checking: DBA = <rdba>, Block Type = KTB-managed data block
**** row 0: row length <length> past end of block
**** row 0: row skipped so other stats may be wrong
**** row 1: row length <length> past end of block
**** row 1: row skipped so other stats may be wrong
**** row 2: row length <length> past end of block
**** row 2: row skipped so other stats may be wrong
**** actual free space credit for itl <itl#> = <itl#> != # in trans. hdr = <hdr>
**** actual free space = <length> < kdxcoavs = 3405
**** actual unlocked split hole space = <value> != kdxlespl = <value>
**** key (begin=<offset>, len=<len>) overlaps with another
begin = 0xf81 len =<len>

DBVerify or RMAN with the check logical option may report the same corruption description.

目前办法：
使用传输表空间后，重建索引组织表

补丁信息：
There is not currently a patch for this issue.

This is a restriction caused by BUG:9816640.

ITPub博客

【BUG】当使用TTS（传输表空间时）从其他平台到HP可造成索引组织表损坏

最新文章