数据库日志报错如图
trace 文件内容:
解决前科普:
1,了解 ora-600,【13013】 的参数含义:
解决前科普:
1,了解 ora-600,【13013】 的参数含义:
Format: ORA-600 [13013] [a] [b] {c} [d] [e] [f]
Arg [a] Passcount
Arg [b] Data Object number
Arg {c} Tablespace Decimal Relative DBA (RDBA) of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Decimal RDBA of block being updated (Typically same as {c})
Arg [f] Code
2, 一般是由索引损坏导致的:
Select object_name,object_type,owner from dba_objects where data_object_id=338;
分析:Analyze table . validate structure online ;
如果得到ora-1498 继续
Analyze table . validate structure cascade online ;
如果得到ora-1499表明了有损坏的索引
Arg [a] Passcount
Arg [b] Data Object number
Arg {c} Tablespace Decimal Relative DBA (RDBA) of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Decimal RDBA of block being updated (Typically same as {c})
Arg [f] Code
2, 一般是由索引损坏导致的:
Select object_name,object_type,owner from dba_objects where data_object_id=338;
分析:Analyze table . validate structure online ;
如果得到ora-1498 继续
Analyze table . validate structure cascade online ;
如果得到ora-1499表明了有损坏的索引
开始针对上面问题的具体解决步骤:
1,SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS WHERE DATA_OBJECT_ID=338;
2: SELECT OWNER,INDEX_NAME FROM DBA_INDEXES WHERE TABLE_NAME='SMON_SCN_TIME';
3:ANALYZE TABLE sys.smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;
4:dba权限执行
ALTER INDEX sys.SMON_SCN_TIME_TIM_IDX REBUILD ONLINE;
ALTER INDEX sys.SMON_SCN_TIME_SCN_IDX REBUILD ONLINE;
以上问题解决。
1,SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS WHERE DATA_OBJECT_ID=338;
2: SELECT OWNER,INDEX_NAME FROM DBA_INDEXES WHERE TABLE_NAME='SMON_SCN_TIME';
3:ANALYZE TABLE sys.smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;
4:dba权限执行
ALTER INDEX sys.SMON_SCN_TIME_TIM_IDX REBUILD ONLINE;
ALTER INDEX sys.SMON_SCN_TIME_SCN_IDX REBUILD ONLINE;
以上问题解决。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8109090/viewspace-2121242/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8109090/viewspace-2121242/