- 数据库异常开启不起来首先查看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名字




