Re: Help! Corrupt data file

How about deallocating any extents and resizing the datafile to the highwater mark ! This will cut off the damaged portion and keep it outside the file rather than inside it. Assuming that it is a damaged track problem.

George Chance wrote in message <34c7ec3d.3698138_at_news.netrax.net>...
>I had oracle down while doing a full backup on my sun box.
>One of the EMC disk drives failed during the backup .
>The EMC SE was able to save all the data but 2 tracks.
>I identified the data files that had the bad data. These
>were in tablespaces that only have indexes. Oracle came
>up OK. I ran analyse index compute statistics and validate
>structure against all the indexes. Everything came back clean.
>I assume the 2 tracks of low values are in an area of the data
>file that has not been used.
>What will happen when the table extends into that area?
>Oracle support was no help.
>I can not easily drop and create these indexes since they
>are primary keys and I would have to drop all the RI.
>I've been running like this for 5 days with no problem
>Shoul I just wait and see?
Received on Fri Jan 23 1998 - 00:00:00 CST