运维联盟俱乐部

 找回密码
 立即注册
查看: 2606|回复: 0

[故障处理] ORA-00600: internal error code, arguments: [kccpb_sanity_check_2]

[复制链接]
  • TA的每日心情
    开心
    2023-8-9 11:05
  • 发表于 2020-9-16 14:19:15 | 显示全部楼层 |阅读模式
    Applies to:
    Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
    Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
    Information in this document applies to any platform.
    ***Checked for relevance on 17-Jul-2014***
    ***Checked for relevance on 07-Dec-2015***
    Symptoms
    The database is getting the following errors on Startup:
    ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [3621501], [3621462],
    [0x000000000]
    Changes
    In this case, the customer moved the box from one data center to another.
    Cause
    ORA-600 [kccpb_sanity_check_2] indicates that the seq# of the last read block is
    higher than the seq# of the control file header block. This is indication of
    the lost write of the header block during commit of the previous cf
    transaction.
    Solution
    1) restore a backup of a controlfile and recover
    OR
    2) recreate the controlfile
    OR
    3) restore the database from last good backup and recover
    NOTE: If you do not have any special backup of control file to restore and you are using Multiple Control File
    copies in your pfile/init.ora/spfile you can attempt to mount the database using each control file one by one. If
    you are able to mount the database with any of these control file copies you can then issue 'alter database
    backup controlfile to trace' to recreate controlfile.

    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    运维联盟俱乐部 ( 冀ICP备19036648号 )

    GMT+8, 2024-3-29 23:54 , Processed in 0.048622 second(s), 21 queries , Gzip On.

    Powered by Discuz! X3.4

    © 2001-2023 Discuz! Team.

    快速回复 返回顶部 返回列表