用rman執行塊恢復

用rman的blockrecover執行塊恢復異常簡單。

前段時間Oracle自動shutdown，在alert日誌中發現如下錯誤：

***
Corrupt block relative dba: 0x10402bb6 (file 65, block 11190)
Bad header found during preparing block for write
Data in bad block -
 type: 1 format: 2 rdba: 0x00000206
 last change scn: 0x5c75.10402bb6 seq: 0x5d flg: 0x38
 consistency value in tail: 0x02c10231
 check value in block header: 0x0, block checksum disabled
 spare1: 0x74, spare2: 0xa4, spare3: 0x1
***

Wed Sep 15 12:11:37 2004
Errors in file e:oracleadminsimisbdumpsimisDBW0.TRC:
ORA-00600: internal error code, arguments: [kcbzpb_1], [272640950], [4], [1], [], [], [], []

Wed Sep 15 12:11:42 2004
Errors in file e:oracleadminsimisbdumpsimisDBW0.TRC:
ORA-00600: internal error code, arguments: [kcbzpb_1], [272640950], [4], [1], [], [], [], []

DBW0: terminating instance due to error 600
Instance terminated by DBW0, pid = 1524

重新啟動後用rman執行：

rman>blockrecover file 65 block 11190;

就可以自動進行塊恢復了，方便快捷。