时间：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]错误的相关症状可能如下：
触发该错误的原因是：
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:
原文地址：【ORACLE数据库恢复】ORA-00600[KCLCHKBLK], 感谢原作者分享。