联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库版本10.2.0.1创建控制文件出现ORA-00600[kccscf_1]错误
SQL> CREATE CONTROLFILE REUSE DATABASE "ITPLUSDW" RESETLOGS ARCHIVELOG 2 MAXLOGFILES 16 3 MAXLOGMEMBERS 3 4 MAXDATAFILES 100 5 MAXINSTANCES 8 6 MAXLOGHISTORY 292000 7 LOGFILE 8 GROUP 1 '/backup/oracle/oradata/redo01.log' SIZE 50M, 9 GROUP 2 '/backup/oracle/oradata/redo02.log' SIZE 50M, 10 GROUP 3 '/backup/oracle/oradata/redo03.log' SIZE 50M 11 -- STANDBY LOGFILE 12 DATAFILE 13 '/backup/oracle/oradata/system01.dbf', 14 '/backup/oracle/oradata/undotbs01.dbf', 15 '/backup/oracle/oradata/sysaux01.dbf', 16 '/backup/oracle/oradata/users01.dbf', 17 '/backup/oracle/oradata/itplus_data', 18 '/backup/oracle/oradata/invertories_data', 19 '/backup/oracle/oradata/inventories_data01', 20 '/backup/oracle/oradata/itplus_discover', 21 '/backup/oracle/oradata/inventories_data02', 22 '/backup/oracle/oradata/inventories_data03', 23 '/backup/oracle/oradata/inventories_data05', 24 '/backup/oracle/oradata/inventories_data04' 25 CHARACTER SET ZHS16CGB231280 26 ; CREATE CONTROLFILE REUSE DATABASE "ITPLUSDW" RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-00600: internal error code, arguments: [kccscf_1], [9], [292000], [65535],[], [], [], []
alert日志错误
Default Temporary Tablespace will be necessary for a locally managed database in future release Tue Feb 26 15:49:36 2013 Errors in file /backup/oracle/admin/udump/itplustest_ora_25001.trc: ORA-00600: internal error code, arguments: [kccscf_1], [9], [292000], [65535], [], [], [], [] Tue Feb 26 15:49:36 2013 Errors in file /backup/oracle/admin/udump/itplustest_ora_25001.trc: ORA-00600: internal error code, arguments: [kccscf_1], [9], [292000], [65535], [], [], [], [] ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ITPLUSDW" NORESETLOGS ARCHIVELOG
查询mos发现Create Control File fails with ORA-600 [kccscf_1] [ID 387210.1],中有描述,该bug在10.2.0.1到11.1.0.6版本中,如果MAXLOGHISTORY超过了65535均有可能出现,在10.2.0.4和11.1.0.6中修复,部分版本有Patch 4877360修复该问题。在不能升级或者没有patch的情况下,解决该问题的思路是设置MAXLOGHISTORY为65535或者更小值,重建控制文件