Ora-600 [kccpb_sanity_check_2]处理

By on 2009/07/27 at 1:41 下午 in dba

本文标题:Ora-600 [kccpb_sanity_check_2]处理【本站如从外站转载,会注明出处】
本文链接:http://www.validba.net/2009/07/ora-600-kccpb_sanity_check_2%e5%a4%84%e7%90%86/

今天以前的同事求助,数据库在启动的时候提示Ora-600错误,alert中记录了以下信息:

starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Jul 27 11:03:31 2009
ALTER DATABASE   MOUNT
Mon Jul 27 11:03:35 2009
Errors in file /opt/oracle/oracle/product/10.2.0 _1
/admin/hotel/udump/hotel_ora_3046.trc:
ORA-00600: internal error code, arguments:
[kccpb_sanity_check_2], [1706], [1699], [0x0], [], [], [], []
Mon Jul 27 11:14:33 2009
Process 0x0x29e1b264 appears to be hung while dumping
Current time = 1718136175,
process death time = 1718070344 interval = 60000
Attempting to kill process 0x0x29e1b264 with OS pid = 3046
OSD kill succeeded for process 0x29e1b264

然后用各种方式重启了都不行,打开trace文件,发现数据库是在mount的时候发生了错误,有点奇怪,该问题因该是控制文件本身的不一致造成的.

MetaLink上Oracle对kccpb_sanity_check_2的解释为:

The ORA-600 [kccpb_sanity_check_2] is reported when the SCN in the controlfile header is lower than the SCN in a controlfile block.  或者

The 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.

可通过下列三种方法解决: 

  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

可参考MetaLink:435436.1,833115.1

CopyRight Validba'S Home 版权所有.本站为个人学习之用,评论时请遵守本国法律

Relative Posts

Tags:

Reader's Comments »

  1. By ww on 2011/09/23 at 2:49 上午

    请问您是使用哪种方法解决的？

  2. By Robin on 2012/02/01 at 1:45 上午

    @ww:recreate controlfile

Leave a Reply