OraFAQ Forum: Backup & Recovery » Database Block corruption

Home » RDBMS Server » Backup & Recovery » Database Block corruption (10.2.0.4 standard edition Windows 2008 R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Block corruption [message #577983]

Fri, 22 February 2013 06:09

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

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

Code: [Select all] [Show/ hide]

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