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

Hi Robert,
I agree... I didn't really know what I was into before this db crashed and I had the devs breathing down my neck to get their db up and running. Now that I know its not a simple thing to recover a crashed db, would you have a check-list that I might use to prevent this kind of mishap from happening again?

Regards,
Srinivas.

On Fri, Apr 25, 2008 at 7:17 PM, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:

> 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_at_gmail.com>
> To: David Pintor <painterman_at_gmail.com>
> Cc: oracle-l_at_freelists.org
> 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_at_gmail.com>
> 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_at_gmail.com>
> > 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
>

-- 
Regards,
Srinivas Chintamani

--
http://www.freelists.org/webpage/oracle-l