暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-00600 internal error code, arguments: [ktubko_1], [], [], [], [], [], [], [], [], [], [], []

原创 Allen duan 2020-12-24
2798
  1. 数据库异常开启不起来首先查看alter日志

Tail -1000 /oracle/diag/rdbms/tymlb/tymlb/trace/ alert_tymlb.log |grep ORA

Tail -1000 /oracle/diag/rdbms/tymlb/tymlb/trace/ alert_tymlb.log |grep ALTER

Tail -1000 /oracle/diag/rdbms/tymlb/tymlb/trace/ alert_tymlb.log |grep ERROR

查看错误带时间
tail -22000 alert_tymlb.log |grep -A3 -B3 I_58_TS_WIP |more
(查看有I_58_TS_WIP这个表空间的所有报错待时间)

此次异常查询与解决的方法
tail -5000 /oracle/diag/rdbms/tymlb/tymlb/trace/alert_tymlb.log |grep -A3 -B3 ORA |more
错误报告如下======================
ORA-00600: internal error code, arguments: [ktubko_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/tymlb/tymlb/incident/incdir_1152318/tymlb_smon_49420_i1152318.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ORACLE Instance tymlb (pid = 15) - Error 600 encountered while recovering transaction (21, 18) on object 98975. —这个现实出坏块的号码
Errors in file /oracle/diag/rdbms/tymlb/tymlb/trace/tymlb_smon_49420.trc:

select * from dba_objects where OBJECT_ID=98765

Drop index index名字

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论