【ORACLE数据库恢复】ORA-00600[KCLCHKBLK]-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:36 PM

oraclerecoverdatabase

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 选项打开数据库
在打开数据库之后可能遇到以下的错误：
其错误堆栈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

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

原文地址：【ORACLE数据库恢复】ORA-00600[KCLCHKBLK], 感谢原作者分享。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AM

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AM

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AM

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns

See all articles