一個[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.

[@more@]