ORA-00600: internal error code, arguments: [3020]

今天有台oracle db 被關機了,重開機後出現無法開啟db的問題,而且進行recover database後還是出現error , error如下:

SQL> recover database ;
ORA-00600: internal error code, arguments: [3020], [10], [244], [41943284], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 10, block# 244, file
offset is 1998848 bytes)
ORA-10564: tablespace UNDOTBS2
ORA-01110: data file 10: ‘/datafile/o1_mf_undotbs2_gn4kyc4y_.dbf’
ORA-10560: block type ‘KTU UNDO BLOCK’

後來的解決方法是重建undo tablespace

參考資料:
https://rana-abdulwahid.blogspot.com/2018/08/ora-10564-tablespace-undotbs1-ora-01110.html

分類: Oracle。這篇內容的永久連結