alert日志里错误信息
这里 ORA-00600: internal error code, arguments: [4194] 错误原因:是UNDO表空间文件损坏。
处理方法: 重新创建一个UNDO表空间,来代替损坏的UNDO表空间。
点击(此处)折叠或打开
- Tue Jul 29 14:34:03 2014
- Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_smon_2170.trc (incident=18149):
- ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
- Use ADRCI or Support Workbench to package the incident.
- See Note 411.1 at My Oracle Support for error and packaging details.
- Block recovery from logseq 7, block 158 to scn 1143290
- Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
- Mem# 0: /u01/app/oracle/oradata/prod/redo01.log
- Block recovery completed at rba 7.160.16, scn 0.1143291
- Block recovery from logseq 7, block 158 to scn 1143403
- Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
- Mem# 0: /u01/app/oracle/oradata/prod/redo01.log
- Block recovery completed at rba 7.276.16, scn 0.1143404
- Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
- SMON encountered 16 out of maximum 100 non-fatal internal errors.
处理方法: 重新创建一个UNDO表空间,来代替损坏的UNDO表空间。
点击(此处)折叠或打开
- SQL> create undo tablespace myundo datafile \'/u01/app/oracle/oradata/prod/myundo01.dbf\' size 800m; -- 创建新的UNDO表空间
-
- SQL> alter system set undo_tablespace=myundo; -- 切换默认UNDO表空间
-
- SQL> drop tablespace undotbs1 including contents and datafiles; -- 删除之前的UNDO表空间
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12238525/viewspace-1243258/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12238525/viewspace-1243258/