今天在PlateSpin Forge(關於PlateSpin相關介紹,請見最下面部分簡單介紹) 復制出來的一台數據庫服務器上,測試數據庫能否正常啟動時,遇到了“ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []”錯誤:
在官方文檔介紹中,這個錯誤主要出現在磁盤出現故障導致數據庫崩潰後,實例啟動失敗,並報ORA-00600: arguments: [kcratr1_lastbwr].
After a disk failure that caused the database to crash, the instance fails to start up with ORA-00600: arguments: [kcratr1_lastbwr].The alert log file shows the following entries :
Completed: ALTER DATABASE MOUNT
Tue Sep 19 09:43:03 2006
ALTER DATABASE OPEN
Block change tracking file is current.
Tue Sep 19 09:43:04 2006
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Sep 19 09:43:04 2006
Started redo scan
Tue Sep 19 09:43:05 2006
Errors in file gns80_ora_9936.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []
Tue Sep 19 09:43:06 2006
Aborting crash recovery due to error 600
出現這個錯誤後,只能手工操作恢復,操作步驟也非常簡單。如下所示:
Oracle is unable to perform instance recover but it works when is invoked manually.
SQL> shutdown immediate;
SQL> startup mount;
SQL> recover database;
SQL> alter database open;
在整個過程中,最好開啟另外一個窗口,一直刷新告警日志(tail -60f alert_{$ORACLE_SID}.log),查看恢復過程中的具體情況。
Novell PlateSpin Forge 相關資料:
Novell PlateSpin Forge 將其接入生產環境後, 便可通過Forge管理界面,指定保護對象(workload, 可以是物理機或VM), 確定之後, Forge便將每個被保護對象轉換復制成其ESX上的一台VM. 並在之後根據用戶的設定在被保護對象和DR的VM之間進行定期復制更新.
保護對象故障時, 用戶激活Forge上的VM, 實現failover. 故障排除之後, 可以通過V2P或V2V的方式, 對DR VM進行Failback操作, 將其復制回生產環境中的物理機或VM.
參考資料:
ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (文檔 ID 393984.1)