Message-ID: <3B1DC51D.C1D5605@home.com>
From: Paul Drake <paled@home.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Please help on recovery Data from Oracle DB
References: <9fj6f7$2j$1@taliesin.netcom.net.uk> <9fjav9$1p2e$1@msunews.cl.msu.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
Date: Wed, 06 Jun 2001 05:54:17 GMT
NNTP-Posting-Host: 24.3.185.92
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc1.nj.home.com 991806857 24.3.185.92 (Tue, 05 Jun 2001 22:54:17 PDT)
NNTP-Posting-Date: Tue, 05 Jun 2001 22:54:17 PDT
Organization: Excite@Home - The Leader in Broadband http://home.com/faster


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