Errors ORA-00600 [kclchkblk_4] and ORA-00600 [2662] After Recovery of Datab

Applies to:

Oracle Server - Enterprise Edition - Version: 9.0.1.0.0 to 10.1.0.2
This problem can occur on any platform.

Symptoms

1) You restored the database from backup and did an incomplete recovery.

2) Opened the database with resetlogs.

3) After opening the database, you start getting following errors:

ORA-00600 [kclchkblk_4]
ORA-00600 [2662]

4) Stack trace is:- kclchkblk kcbzib kcbgcur ktfbhget ktftfcload

Cause

1) Error, ORA-600[KCLCHKBLK_4], is signaled because the SCN in a tempfile block
is too high. The same reason caused the ORA-600[2662]s in the alert logs.

2) This issue is because the tempfiles may not get reinitialized during open
resetlogs.

Solution

1) First find the tempfiles in the database:

select file_name, file_id from dba_temp_files;

2) Startup mount.

3) Drop all the tempfiles:

alter database tempfile drop;

4) Alter database open;

5) Add new tempfile(s).

alter tablespace add tempfile size N;


5) Restart the instance.