ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17],

数据库重启后不定期的发生ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17], [], [], [], [], []错误。这里小计一下解决办法

一、查看实例日志

在alter_sid.log中找到最近一次的错误信息


Wed Jun 08 22:28:15 2016
Errors in file /home/oracle/app/diag/rdbms/bsjdb/bsjdb/trace/bsjdb_ora_25780.trc:
Wed Jun 08 22:28:18 2016
Trace dumping is performing id=[cdmp_20160608222818]
Wed Jun 08 22:28:52 2016
Errors in file /home/oracle/app/diag/rdbms/bsjdb/bsjdb/trace/bsjdb_smon_23740.trc  (incident=8567):
ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17], [], [], [], [], []
Incident details in: /home/oracle/app/diag/rdbms/bsjdb/bsjdb/incident/incdir_8567/bsjdb_smon_23740_i8567.trc
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 5 out of maximum 100 non-fatal internal errors.
Wed Jun 08 22:28:53 2016
Trace dumping is performing id=[cdmp_20160608222853]
Wed Jun 08 22:28:54 2016
Sweep [inc][8567]: completed
Sweep [inc2][8567]: completed

得知,实例触发了ora-006错误,但是是非致命的(non-fatal internal errors)
根据提示继续查看.trc日志。

...
*** 2016-06-08 22:08:44.037
*** SESSION ID:(158.1) 2016-06-08 22:08:44.037
*** CLIENT ID:() 2016-06-08 22:08:44.037
*** SERVICE NAME:(SYS$BACKGROUND) 2016-06-08 22:08:44.037
*** MODULE NAME:() 2016-06-08 22:08:44.037
*** ACTION NAME:() 2016-06-08 22:08:44.037

Dump continued from file: /home/oracle/app/diag/rdbms/bsjdb/bsjdb/trace/bsjdb_smon_23740.trc
ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17], [], [], [], [], []

========= Dump for incident 8563 (ORA 600 [13013]) ========

*** 2016-06-08 22:08:44.038
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dma0vxbwh325p) -----
update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4,  scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn =  (select min(scn) from smon_scn_time)
...

Google找到类似解决方案After database restore errors appear in the alert log and instance crash -> ORA-00600: [13013], [5001], [267], [8402519], [0], [8402519], [17]

二、重建索引


SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;
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;

Index altered.

SQL>  ALTER INDEX SMON_SCN_TIME_SCN_IDX REBUILD ONLINE;

Index altered.

SQL>  ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;

Table analyzed.

至此,已解决

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值