Re: Help! Corrupt data file

Trust me, if your datafiles smelled fishy...Oracle would not let you come back up. If you're worried that you might have corrupt blocks in your datafile(s), do a full export. If there is corruption in the datafiles, the export will fail. Also, can you disable the primary constraint, then drop the indexes and re-create them? Another thing, is Oracle creating dump files that are complaining of failed reads or writes? Hope I pointed you into the right direction and not into darkness.

Satar Naghshineh
Oracle DBA / Unix System Admin
satarnag_at_microcad.com

>>Subject: Help! Corrupt data file
>>From: gchance_at_sun-link.com (George Chance)
>>Date: 1/23/98 1:14AM GMT
>>Message-id: <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 Sun Jan 25 1998 - 00:00:00 CST