当前位置:Gxlcms > mysql > 【ORACLE数据库恢复】ORA-00600[KCLCHKBLK]

【ORACLE数据库恢复】ORA-00600[KCLCHKBLK]

时间:2021-07-01 10:21:17 帮助过:77人阅读

ORA-600: internal error code, arguments: [kclchkblk_3/4]错误的相关症状可能如下: 当从备份中restore过数据库并做了一个incomplete recovery不完全恢复时 以resetlogs 选项打开数据库 在打开数据库之后可能遇到以下的错误: ORA-00600 [kclchkblk_4] ORA

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

如果自己搞不定可以找ASKMACLEAN专业ORACLE数据库修复团队成员帮您恢复!

已知的一些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

Related posts:

  1. 【Oracle数据恢复】ORA-00600[3020]错误解析
  2. 【Oracle数据恢复】ORA-00600[kdBlkCheckError]错误解析
  3. 【Oracle数据恢复】ORA-00600[4000]错误解析
  4. 【Oracle数据恢复】ORA-600[4511]错误解析
  5. Oracle内部错误:ORA-00600:[6033]一例
  6. 【Oracle数据恢复】ORA-00600[2662]错误解析
  7. Oracle内部错误:ORA-00600[25012]一例
  8. ORA-00600 [KCBZPB_1], [59033077], [4], [1], [] example
  9. ORA-00600[kglhdunp2_2]错误一例
  10. 【Oracle数据恢复】ORA-01578错误解析

人气教程排行