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>
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-lReceived on Fri Apr 25 2008 - 09:02:32 CDT