用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;

就可以自动进行块恢复了，方便快捷。