Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Corrupt block problem

451915Jul 21 2006 — edited Nov 14 2010
Hi

Last night when we did analyse table, an error occured in a specific table with error :
ORA-01578 + ORA-01110 : for summary, a block corrupt problem.

So i use the dbv (dbverify utility) to see the problem. The resul is as follow :
Page 29249 marquée altérée
***
Corrupt block relative dba: 0x0bc07241 (file 47, block 29249)
Bad header found during dbv:
Data in bad block -
type: 23 format: 0 rdba: 0x17807442
last change scn: 0x0000.24844424 seq: 0x0 flg: 0x00
consistency value in tail: 0x5f54562c
check value in block header: 0x744, block checksum disabled
spare1: 0x66, spare2: 0x82, spare3: 0x4154
***

I have one corrupt block.
So i ask myself something. I can easily recover this datafile but once recover, the problem can persist because the corrupt block is on the system disk.

So is there a way to do something at Oracle level or is this more a disk system problem ??

Thanks for anwser.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2010
Added on Jul 21 2006
18 comments
1,159 views