Home » RDBMS Server » Backup & Recovery » Database Block corruption ( standard edition Windows 2008 R2)
Database Block corruption [message #577983] Fri, 22 February 2013 06:09 Go to next message
Messages: 69
Registered: September 2012
Location: Chennai

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.


[Updated on: Fri, 22 February 2013 06:51]

Report message to a moderator

Re: Database Block corruption [message #577988 is a reply to message #577983] Fri, 22 February 2013 07:40 Go to previous message
Michel Cadot
Messages: 67923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recover the whole file.

Previous Topic: RMAN issus with catalog database
Next Topic: recover data from .dbf files
Goto Forum:

Current Time: Fri Jul 30 08:23:24 CDT 2021