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

From: David Barbour <>
Date: Fri, 25 Apr 2008 10:22:41 -0400
Message-ID: <>

Gee - I'm not sure what I can add to this with the exception that you are very lucky this is a development database and not production. Since that's the case, you ought to take the opportunity to practice your recovery techniques. I really don't know if you have a recoverable database or not, but I suspect, if you've got a full filesystem copy of all the datafiles, you might have a shot at it if you approach it correctly. Do you have access to Metalink and/or Oracle Support? If so, you might want to put in a service request and look through the notes. Additionally, you need to look at the backup and recovery documentation. Since we don't know what version of Oracle you're using, or anything else, go to and find the documentation for the version you're using. Then come up with a plan and post it here for more input.

It might have been a good idea to ask for help before you decided to "delete" the database.

On 4/25/08, Srinivas Chintamani <> wrote:
> "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.

Received on Fri Apr 25 2008 - 09:22:41 CDT

Original text of this message