Re: Is it possible to add existing datafiles to an oracle database?
Date: Fri, 25 Apr 2008 15:43:52 +0200
"which refuses to start"
--> What is the error that you receive on startup?
"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?
On 4/25/08, Srinivas Chintamani <srinivas.chintamani_at_gmail.com> wrote:
> 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 <painterman_at_gmail.com>
>> 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 <srinivas.chintamani_at_gmail.com> wrote:
>>> 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
-- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Toon Koppelaars RuleGen BV +31-615907269 toon_at_rulegen_dot_com www_dot_rulegen_dot_com Author: "Applied Mathematics for Database Professionals" -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 25 2008 - 08:43:52 CDT