Corrupt block problem
451915Jul 21 2006 — edited Nov 14 2010Hi
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.