1. 首页
  2. IT资讯

smon_scn_time ORA-00600 ktspfupdst-1

处理流程如下:

查看数据库日志报错:

ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/oradba/oracle/diag/rdbms/yjfcdbp/yjfcdb/incident/incdir_192162/yjfcdb_smon_17351_i192162.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 2 out of maximum 100 non-fatal internal errors.
System state dump requested by (instance=1, osid=17307 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /home/oradba/oracle/diag/rdbms/yjfcdbp/yjfcdb/trace/yjfcdb_diag_17323.trc
Dumping diagnostic data in directory=[cdmp_20141030070534], requested by (instance=1, osid=17307 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 17307

查看trace文件发现错误语句如下:

insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)

出现原因:

smon_scn_time表中的索引逻辑损坏

进行处理
首先对smon_scn_time进行结构验证,没有问题
SQL> conn / as sysdba
SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE;

Table analyzed.

然后对涉及的索引进行验证报错:
SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE; 

ERROR at line 1:
ORA-01499: table/index cross reference failure – see trace file

然后对涉及的索引进行重建

SQL> ALTER INDEX SMON_SCN_TIME_TIM_IDX REBUILD ONLINE;
SQL> ALTER INDEX SMON_SCN_TIME_SCN_IDX REBUILD  ONLINE;

重建后可以进行验证

SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE; 

Table analyzed.

但是查看日志报错任然有ORA600错误,但是语句报错已经消失

然后处理如下:

SQL> conn / as sysdba
停止SMON 写入 smon_scn_time表
SQL> alter system set events ‘12500 trace name context forever, level 10’;

SQL> truncate cluster SMON_SCN_TO_TIME_AUX;
 
Cluster truncated

启动SMON 写入 smon_scn_time表
SQL> alter system set events ‘12500 trace name context off’;

再次查看日志没有报错。

SCN=(SCN_WRP * 4294967296) + SCN_BAS

参考文档
SMON Signals ORA-00600 [ktspfupdst-1] and Instance Terminates (文档 ID 1353076.1)
Instance Terminated With Error ORA-00474: SMON Process Terminated With Error (文档 ID 1361872.1)
LOCK ON SYS.SMON_SCN_TIME (文档 ID 747745.1)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-1314845/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183370.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code