Re: Help! how to recover user (DES2K) without complete DB recovery

Richard G. Ramirez wrote:
>
> I need to recover the tablespace TOOLS from a physical backup
> on a database run in NOARCHIVELOG mode. Can anyone help?
>
> I exported the DES2K user and then dropped it. When I tried to
> import it back, I discovered that the export file was corrupted
> (yes, I should have checked just like I checked everything else
> except this, Murphy's law)..........
>
 

> I appreciate any help.
>
> Richard
> --------------------------

You can try the following. I have only tried this with user data tablespaces and never with TOOLS tablespace.

I had run into a similar problem a while ago with user data datafiles. what I did was to DROP the datafiles and the tablespace, bring up the database and then re-create the tablespace. I fortunately had the data backup (in ASCII files) and was able to re-create the data in the tablespace.

What you have to do is to start the database with MOUNT option. This will not open the database annd will not try to look for datafiles. Then issue ALTER DATABASE DATAFILE <file name> OFFLINE DROP command. This will take the datafile(s) associated with the tablespace offline. Now, open the database. (ALTER DATABASE OPEN). Since, the datafile is offline, the server will not try to find it or try to read the SCN # in it.

After you have the database up and running, drop the tablespace and re-create it. Now you can restore the DES2K user and its objects while other users are up and running!

Good luck!! I hope this works for you.

-
Ashok F. Kapur | Galaxy Latin America | Project Engineer | (954)958-3373 | afkapur_at_ccgate.hac.com Received on Tue Jan 14 1997 - 00:00:00 CST