Home » RDBMS Server » Backup & Recovery » Database Block corruption (10.2.0.4 standard edition Windows 2008 R2)
Database Block corruption [message #577983] Fri, 22 February 2013 06:09 Go to next message
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


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

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: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recover the whole file.

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


Current Time: Sun Sep 21 08:08:20 CDT 2014

Total time taken to generate the page: 0.05303 seconds