ORACLE Database recovery ORA-00600 [KCLCHKBLK]

Source: Internet
Author: User
ORA-600: internalerrorcode, arguments: [kclchkblk_34] the symptoms of the error may be as follows: when you restore a database from a backup and make an incompleterecovery Incomplete recovery, open the database with the resetlogs option and you may encounter the following error after opening the database: ORA-00600 [kclchkblk_4] ORA

ORA-600: internal error code, arguments: [kclchkblk_3/4] The symptoms of the error may be as follows: when you restore a database from a backup and make an incomplete recovery, open the database with the resetlogs option and you may encounter the following error after opening the database: ORA-00600 [kclchkblk_4] ORA

ORA-600: internal error code, arguments: [kclchkblk_3/4] The symptoms of the error may be as follows:

  • When the database has been restore from the backup and an incomplete recovery is not completely restored
  • Use the resetlogs option to open a database
  • After opening the database, you may encounter the following errors:
      • ORA-00600 [kclchkblk_4]
        ORA-00600 [2662]
  • The error stack trace is kclchkblk kcbzib kcbgcur ktfbhget ktftfcload.

The cause of this error is:

ORA-600 [KCLCHKBLK_4] is caused by an excessively high SCN on the block in the temporary file ,? The ORA-600 [2662] error is also a similar cause.

This problem may be caused by the incorrect initialization of the temporary file after open resetlogs.

KCLCHKBLK in this ORA-00600 [KCLCHKBLK] represents 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 upload uption
Possible physical upload uption

If you are not sure, you can contact the ASKMACLEAN professional ORACLE Database repair team to help you recover it!

Known bugs related to ORA-00600 [KCLCHKBLK3/4] are as follows:

NB Bug Fixed Description
17273253 12.1.0.1.1 Various ORA-600 resume uption errors with ASM
14034244 11.2.0.3.BP09, 11.2.0.4, 12.1.0.1 Lost write type resume uption 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/partition uption 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 resume uption 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 Data Recovery ORA-00600 [3020] Error Parsing
  2. Oracle Data Recovery ORA-00600 [kdBlkCheckError] Error Parsing
  3. Oracle Data Recovery ORA-00600 [4000] Error Parsing
  4. Oracle Data Recovery ORA-600 [4511] Error Parsing
  5. Oracle internal error: ORA-00600: [6033] example
  6. Oracle Data Recovery ORA-00600 [2662] Error Parsing
  7. Oracle internal error: ORA-00600 [25012] example
  8. ORA-00600 [KCBZPB_1], [59033077], [4], [1], [] example
  9. An error in ORA-00600 [kglhdunp2_2]
  10. [Oracle data recovery] ORA-01578 error Parsing

[ORACLE database recovery] ORA-00600 [KCLCHKBLK], thank you for sharing.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.