ORA-00600: internal error code, arguments: [4194] 错误处理

alert日志里错误信息

点击(此处)折叠或打开

1. Tue Jul 29 14:34:03 2014
   
2. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_smon_2170.trc (incident=18149):
   
3. ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
   
4. Use ADRCI or Support Workbench to package the incident.
   
5. See Note 411.1 at My Oracle Support for error and packaging details.
   
6. Block recovery from logseq 7, block 158 to scn 1143290
   
7. Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
   
8.   Mem# 0: /u01/app/oracle/oradata/prod/redo01.log
   
9. Block recovery completed at rba 7.160.16, scn 0.1143291
   
10. Block recovery from logseq 7, block 158 to scn 1143403
    
11. Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
    
12.   Mem# 0: /u01/app/oracle/oradata/prod/redo01.log
    
13. Block recovery completed at rba 7.276.16, scn 0.1143404
    
14. Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
    
15. SMON encountered 16 out of maximum 100 non-fatal internal errors.

这里 ORA-00600: internal error code, arguments: [4194] 错误原因：是UNDO表空间文件损坏。
处理方法： 重新创建一个UNDO表空间，来代替损坏的UNDO表空间。

点击(此处)折叠或打开

1. SQL> create undo tablespace myundo datafile \'/u01/app/oracle/oradata/prod/myundo01.dbf\' size 800m;           --  创建新的UNDO表空间
   
2. 
   
3. SQL> alter system set undo_tablespace=myundo;                                                                  --  切换默认UNDO表空间
   
4. 
   
5. SQL> drop tablespace undotbs1 including contents and datafiles;                                                --  删除之前的UNDO表空间

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12238525/viewspace-1243258/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12238525/viewspace-1243258/