用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;
就可以自动进行块恢复了,方便快捷。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/6906/viewspace-21539/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/6906/viewspace-21539/