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

From: Robert Freeman <>
Date: Fri, 25 Apr 2008 06:47:20 -0700 (PDT)
Message-ID: <>

LOL.... restoring Oracle is not a pain if you have thought about it BEFORE the crash. Backing up Oracle is easy. However, you need the datafiles, the control file and the online redo logs (if in NOARCHIVELOG mode) backed up with the databse down. If you have those (or if in ARCHIVELOG mode if you have the archived redo logs and you backed up the datafiles in hot backup mode or you used RMAN) then you should be able to recover.

Sounds like your problem is that you stepped up from McMicrosoft to a real database and didn't bother to understand what you were stepping up to. Don't blame the database for your lack of planning. If only I had a fiver for the number of times people assumed a particular backup strategy would work, and it didn't. It's all right there, in the documentation (or in books)... all one has to do is read and apply said knowledge. Oh... testing your backup strategy is also probably a good idea.



 Robert G. Freeman
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: (Oracle Press)

  • Original Message ---- From: Srinivas Chintamani <> To: David Pintor <> Cc: Sent: Friday, April 25, 2008 7:31:14 AM Subject: Re: Is it possible to add existing datafiles to an oracle database?

The crashed database is deleted now and I only have the datafiles of the crashed database somewhere on my filesystem. What I am trying to do is to find out if, it is possible to load the data from the datafiles of the crashed database into another new database.

Earlier when working with SQL Server, it was simple to backup / restore the db. Just take a backup, dump the backup file anywhere on the filesystem and point to SQL Server, where the backup file is at and it happily recovered the db, all in a few seconds.

Wonder why restoring an oracle db is such a pain ...


On Fri, Apr 25, 2008 at 6:50 PM, David Pintor <> wrote:


I'm not really sure if there's a way of doing that, but before thinking about this I would try to recover the database first, or if your datafiles are in a consistent state, I would try to recreate the control file and try to restart...

Good luck.


On 25/04/2008, Srinivas Chintamani <> wrote: Hi,
I ended up with a crashed Oracle db, which refuses to start. I have all the datafiles for this database and was wondering if it is possible to somehow "Load / Import" the data in these datafiles into another working database. If yes, it will save me quite a lot of re-work. Can somebody help me on this please ....


Srinivas Chintamani


Srinivas Chintamani
-- Received on Fri Apr 25 2008 - 08:47:20 CDT

Original text of this message