Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help! Corrupt data file

Help! Corrupt data file

From: George Chance <gchance_at_sun-link.com>
Date: 1998/01/23
Message-ID: <34c7ec3d.3698138@news.netrax.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US