一个Oracle的[kclchkblk_4]异常错误处理

今天早上一上班就有朋友在MSN上说，容灾库无法启动，昨天晚上容灾库和生产库同步后，容灾库打开频繁的出现下列错误

ORA-00600: internal error code, arguments: [2662], [2156], [2993124414], [2156], [2997732192], [97803001], [], []
ORA-00600: internal error code, arguments: [kclchkblk_4], [2156], [18446744072412316512], [2156], [18446744072407708733], [], [], []

查看metalink文档275902.1

解释该错误

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.