Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help! Corrupt data file
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