Database Block corruption [message #577983] |
Fri, 22 February 2013 06:09 |
|
Dear All,
Please note recently one of our database had block corruption,But we recreated the corrupted table and imported from logical backup,But during corruption we didn't find any corruption block in v$database_block_corruption but alert log shows as block corruption happens
Hex dump of (file 6, block 952301) in trace file d:\oracle\product\10.2.0\admin\oraci\bdump\oraci_dw01_215552.trc
Corrupt block relative dba: 0x018e87ed (file 6, block 952301)
Fractured block found during user buffer read
Also i want to know how to recover block from rman since blockrecover command doesn't support in standard edition.Also please advice how to find logical and physical corruption since we need to make sure no media corrupt.
Regards,
Anil
[Updated on: Fri, 22 February 2013 06:51] Report message to a moderator
|
|
|
|