ORA-00600: internal error code, arguments: [4194] 錯誤處理

huyi_tony發表於2014-07-31
Error
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表空間

  3. SQL> alter system set undo_tablespace=myundo;                                                                  --  切換預設UNDO表空間

  5. SQL> drop tablespace undotbs1 including contents and datafiles;                                                --  刪除之前的UNDO表空間


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12238525/viewspace-1243258/，如需轉載，請註明出處，否則將追究法律責任。

相關文章