alert日志里错误信息

点击(此处)折叠或打开

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.

这里 ORA-00600: internal error code, arguments: [4194] 错误原因：是UNDO表空间文件损坏。
处理方法：重新创建一个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表空间