Oracle ORA-600 [kccpb_sanity_check_2] ORA-00600 [kccpb_sanity_check_2]

 

If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

Parnassusdata Software Database Recovery Team

Service Hotline:  +86 13764045638 E-mail: [email protected]

 

ERROR:
ORA-600 [kccpb_sanity_check_2] [a] [b] [c]

 

VERSIONS:

Versions 10.2 to 11.2
DESCRIPTION:

This internal error is raised when the sequence number (seq#) of the current block of the controlfile is greater than the seq# in the controlfile header. The header value should always be equal to, or greater than the value held in the control file block(s).
This extra check was introduced in Oracle 10gR2 to detect lost writes or stale reads to the header.
ARGUMENTS:
Arg [a] seq# in control block header.
Arg [b] seq# in the control file header.
Arg [c]
FUNCTIONALITY:

Kernel Cache layer Control file component.

IMPACT:

INSTANCE FAILURE
PROCESS FAILURE
POSSIBLE CONTROLFILE CORRUPTION

 

ORA-00600: [kccpb_sanity_check_2] During Instance Startup

 

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.

 

ora-600 ora-600 ora-600 ora-600 ora-600 ora-600 ora-600
ora-600 ora-600 ora-600 ora-600 ora-600 ora-600 ora-600
kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2
kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2
kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2
kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2
kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2 kccpb_sanity_check_2

 

 


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *