Tuesday, April 5, 2011

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2]

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [2650],
[2647], [0x0], [], [], [], []

Database Version: and later

Problem when

The database is getting the following errors on Startup:

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [2650],
[2647], [0x0], [], [], [], []


control file corruption, then try to recover database with one of the control file .


[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


1) restore a backup of a controlfile and recover


2) recreate the controlfile


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.

1 comment:

Unknown said...


The last trick worked for me.
Thanks a lot.