Re: Is it possible to add existing datafiles to an oracle database?
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: srinivas.chintamani@xxxxxxxxx, David Pintor <painterman@xxxxxxxxx>
- Date: Fri, 25 Apr 2008 06:47:20 -0700 (PDT)
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.
Sheesh...
RF
Robert G. Freeman
Author:
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: http://robertgfreeman.blogspot.com (Oracle Press)
----- Original Message ----
From: Srinivas Chintamani <srinivas.chintamani@xxxxxxxxx>
To: David Pintor <painterman@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Friday, April 25, 2008 7:31:14 AM
Subject: Re: Is it possible to add existing datafiles to an oracle database?
Hi,
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 ...
Regards,
Srinivas.
On Fri, Apr 25, 2008 at 6:50 PM, David Pintor <painterman@xxxxxxxxx> wrote:
Hi,
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.
David
On 25/04/2008, Srinivas Chintamani <srinivas.chintamani@xxxxxxxxx> 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 ....
--
Regards,
Srinivas Chintamani
--
Regards,
Srinivas Chintamani
Other related posts:
