Re: Is it possible to add existing datafiles to an oracle database?
- From: "Srinivas Chintamani" <srinivas.chintamani@xxxxxxxxx>
- To: "David Pintor" <painterman@xxxxxxxxx>
- Date: Fri, 25 Apr 2008 19:01:14 +0530
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:
