ITPub博客

首页 > 数据库 > Oracle > smon_scn_time ORA-00600 ktspfupdst-1 (ORA-08102)

smon_scn_time ORA-00600 ktspfupdst-1 (ORA-08102)

Oracle 作者:q418441117 时间:2017-11-06 17:02:16 0 删除 编辑
处理流程如下:


查看数据库日志报错:


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/26655292/viewspace-2146894/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-09-11

  • 博文量
    201
  • 访问量
    372556