ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []

今天檢查資料庫，發現alert日誌出現如下錯誤：

Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_arc3_10122.trc  (incident=38753):
ORA-00600: 內部錯誤程式碼, 引數: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/incident/incdir_38753/ssdhr1_arc3_10122_i38753.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jul 19 19:55:06 2013
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_mmon_10075.trc:
Fri Jul 19 19:55:09 2013
Dumping diagnostic data in directory=[cdmp_20130719195509], requested by (instance=1, sid=10075 (MMON)), summary=[abnormal process termination].
Fri Jul 19 19:55:09 2013
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_ora_3342.trc  (incident=38921):
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/incident/incdir_38921/ssdhr1_ora_3342_i38921.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_mmon_10075.trc:
Fri Jul 19 19:55:11 2013
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_ora_3313.trc  (incident=38865):
ORA-00600: 內部錯誤程式碼, 引數: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/incident/incdir_38865/ssdhr1_ora_3313_i38865.trc

另外發現還有另外的異常日誌：

*************************************************************
ARC3: Error 19504 Creating archive log file to '+DATA'
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_arc3_10122.trc:
ORA-19816: 警告: 檔案可能存在於資料庫未知的 db_recovery_file_dest 中。
ORA-17502: ksfdcre: 4 未能建立檔案 +DATA
ORA-15041: diskgroup "DATA" space exhausted
*************************************************************
WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************
ARC3: Error 19504 Creating archive log file to '+DATA'
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_arc1_10118.trc:
ORA-19816: 警告: 檔案可能存在於資料庫未知的 db_recovery_file_dest 中。
ORA-17502: ksfdcre: 4 未能建立檔案 +DATA
ORA-15041: diskgroup "DATA" space exhausted
*************************************************************
WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************

通過以上日誌分析，立刻知道應該是由於磁碟組空間滿了，不能歸檔，導致的資料異常。

檢視：

v$recovery_file_dest發現閃回區空間只剩下20M了，另外檢視gv$asm_diskgroup，發現磁碟組的空間還剩80來G，因此可以通過修改引數：db_recovery_file_dest_size來擴大閃回區的大小：

alter system set db_recovery_file_dest_size=150G scope=both sid='*';

資料庫歸檔能繼續了，但是為了歸檔再次滿了，應該利用午飯時間資料庫業務不忙的時候，對資料庫進行備份，備份完後將舊的規歸檔刪掉。

至於歸檔滿了，為何能導致600錯誤，請查案mos：