A tough DBA Issue!
Date: Fri, 16 Oct 1998 08:55:21 -0400
Message-ID: <36274238.241DBC2_at_umich.edu>
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 16 1998 - 14:55:21 CEST