oracle+600+4511,【ORACLE数据库恢复】ORA-00600[KCLCHKBLK]

ORA-600: internal error code, arguments: [kclchkblk_3/4]错误的相关症状可能如下：

当从备份中restore过数据库并做了一个incomplete recovery不完全恢复时

以resetlogs 选项打开数据库

在打开数据库之后可能遇到以下的错误：

ORA-00600 [kclchkblk_4]

ORA-00600 [2662]

其错误堆栈stack trace 为kclchkblk kcbzib kcbgcur ktfbhget ktftfcload

触发该错误的原因是：

ORA-600[KCLCHKBLK_4]是由临时文件中的块上的SCN过高引起，  ORA-600[2662]错误也是类似的原因。

该问题可能是由于在OPEN RESETLOGS之后临时文件temporary file没有正确初始化所引起

这个ORA-00600[KCLCHKBLK]中的KCLCHKBLK 代表 check block scn after a disk read

ORA-600 [kclchkblk_3] [a] [b] [c]

The error is reported when the block SCN is less than the last block SCN.

Called by the cache layer after reading a block from disk.

The block SCN is checked to make sure it is not greater than the recent

SCN and not less than the last block SCN seen.

ARGUMENTS:

Arg [a]  Current SCN WRAP

Arg [b]  Current SCN BASE

Arg [c]  Block type

FUNCTIONALITY:

Check Block scn

IMPACT:

MEMORY CORRUPTION

POSSIBLE PHYSICAL CORRUPTION

已知的一些ORA-00600[KCLCHKBLK3/4]的相关BUG如下：

NB

Bug

Fixed

Description

17273253

12.1.0.1.1

Various ORA-600 corruption errors with ASM

14034244

11.2.0.3.BP09, 11.2.0.4, 12.1.0.1

Lost write type corruption using ASM in 11.2.0.3

12718090

11.2.0.3.1, 11.2.0.3.BP02, 11.2.0.4, 12.1.0.1

ORA-600 [kclchkblk_3] can occur in RAC

+

10425010

11.2.0.3, 12.1.0.1

Stale data blocks may be returned by Exadata FlashCache

*

10205230

11.2.0.1.6, 11.2.0.1.BP09, 11.2.0.2.2, 11.2.0.2.BP04, 11.2.0.3, 12.1.0.1

ORA-600 / corruption possible during shutdown in RAC

10071193

11.2.0.2.BP02, 11.2.0.3, 12.1.0.1

Lost write / ORA-600 [kclchkblk_3] / ORA-600 [3020] in RAC – superceded

+

8597106

11.2.0.1.BP06, 11.2.0.2, 12.1.0.1

Lost Write in ASM when normal redundancy is used

12905058

11.2.0.3.1, 11.2.0.3.BP02, 11.2.0.4.1, 11.2.0.4.BP02

Rare ASM corruption after disk resync

4767885

10.2.0.1

OERI [kclchkblk_3] possible in RAC

3601253

9.2.0.6, 10.1.0.2

OERI[kclchkblk_3] possible accessing transported tablespace in RAC

2000029

9.0.1.3, 9.2.0.1

OERI:KCLCHKBLK_3 possible in RAC after reconfiguration

NB

Bug

Fixed

Description

14351566

11.2.0.3.8, 11.2.0.3.BP21, 11.2.0.4, 12.1.0.1

ORA-600 [kclchkblk_4] when doing flash back

NB

Bug

Fixed

Description

10112810

11.2.0.3, 12.1.0.1

ORA-600[kjbcrc:g] / ORA-600[kclchkblk_2] / [kjbconvert:modes] With Flash Cache Enabled on RAC

2873045

9.2.0.4, 10.1.0.2

OERI:[KCLCHKBLK_2] possible in RAC