Re: Please help on recovery Data from Oracle DB

From: Paul Drake <paled_at_home.com>
Date: Wed, 06 Jun 2001 05:54:17 GMT
Message-ID: <3B1DC51D.C1D5605@home.com>

Chris Wiss wrote:
>
> After you have constructed the data extract, drop the entire table space and
> delete the data files. Verify that there are no physical problems with the
> disk, and then rebuild the tablespace and reload the data.
>
> Good Luck,
> Chris Weiss
>

One comment:

If the particular datafile is small - drop the tablespace and leave the dead datafile alone (don't re-use the space) Re-create the tablespace with a datafile with a different name (or rename the old datafile as 'has_corrupt_blocks.ded' and leave it dead, like an old tractor in the field.

hth,

Paul Received on Wed Jun 06 2001 - 00:54:17 CDT