Re: A tough DBA Issue!

I got the inmpression that the data you need in in the SYSTEM tablespace. I also think that you have indicated that the missing datafile is part of a different tablespace. Assuming that is the case, do the following.

1. startup mount (maybe nomount... I forget)
2. alter database datafile <datafilename> offline drop

This should allow you to open the database. Once it is open, export the data that you need.

Joe Bonner wrote:
>
> I need to restart a database that has a missing tablespace file. There
> were 7 tablespace data files that I restored from a server backup. But
> one of the files was never backed up so I can't restore it. When I try
> to start the database it says that the file that was supposed to be
> there isn't there any more.
>
> I tried to trick the database by creating another SID that had only the
> datafiles that I could restore and then replace the ones that "Storeage
> Manager" created and replace them with the ones that I restored.
> "Instance Manager" still says that the database can be opened because
> the data file is missing..
>
> I tried to trick it again by copying another data file that had the same
> data file id but a different instance ID and making this rigged file
> available to the database but the same issues occurs.
>
> Can somebody tell me how to start up a database that has a missing data
> file.
>
> It turns out that the data I need from the instance is in the SYSTEM
> tablespace datafile not in the one that is missing. So when I get this
> instance running I'll be good to go.
>
> Joe Bonner
> Programmer Analyst II
> U of M Medical School
> Molecular Medicine and Genetics
> 4301 MSRB - III
> Ann Arbor, MI 48109-0638
> (734) 647-4251 phone
> (734) 763-7672 fax
> jbonner_at_umich.edu
Received on Fri Oct 30 1998 - 19:36:21 CET