Oracle 9i 啟動報 ORA-00600 [kcratr1_lostwrt] 解決實錄：SHUTDOWN ABORT + RECOVER DATABASE

非正常關機或斷電導致 Oracle 9i 啟動報錯：
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [], [], [], []

完整修復步驟

SQL> STARTUP
ORA-01081: cannot start already-running ORACLE -- shut down first
SQL> SHUTDOWN ABORT
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Database mounted.
ORA-00600: [kcratr1_lostwrt] ...
SQL> SHUTDOWN IMMEDIATE
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORACLE instance started.
Database mounted.
SQL> RECOVER DATABASE;
Media recovery complete.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> EXIT

關鍵點

1. 先 SHUTDOWN ABORT 確保實例乾淨關閉。
2. 以 STARTUP MOUNT 進入掛載模式 (不開啟資料庫)。
3. 執行 RECOVER DATABASE 介質恢復，應用歸檔/線上重做日誌修復不一致。
4. ALTER DATABASE OPEN 正常開啟。

此流程適用於因斷電/強制關機導致的控制檔/資料檔 SCN 不一致情況。