Re: Is it possible to add existing datafiles to an oracle database?

From: Srinivas Chintamani <srinivas.chintamani_at_gmail.com>
Date: Fri, 25 Apr 2008 19:32:32 +0530
Message-ID: <98c5e2a20804250702m5829da4flcd9303a423591968@mail.gmail.com>


"which refuses to start"
--> What is the error that you receive on startup?
>>>>> The error it __gave__ was "UNDOTbs1.dbf size X is smaller than Y blocks".

"The crashed database is deleted now and I only have the datafiles of the crashed database somewhere on my filesystem"
--> If I read this carefully you are contradicting yourself here.... not?
>>>>> After trying to get the database to start for about a full day, we just did a file system backup of all the files belonging to the crashed db and later on went on to create a new db with the same name. We couldn't change the name of the db, because a lot of developers were on this crashed db :(

Regards,
Srinivas.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 25 2008 - 09:02:32 CDT

Original text of this message