Re: System Crash, how to restore database?

I agree with Karen -- provided that through your (documented and tested) recovery plan you have a cold, off-line backup of the database, AND a combination of warm backups and archivelogs sufficient to bring you to the point in time desired. You are running in archivelog mode, of course?

Why wouldn't the RDBMS binaries be on the OS backup? A reinstall seems superfluous.

Your "dbf" files.... I get a cold chill you didn't mention your control files, redo logs, and init files....

Good luck!

Dave Van Zandt, OCP

"Karen Abgarian" <abvk_at_ureach.com> wrote in message news:3D51FF59.399F381A_at_ureach.com...
> It is not clear what exactly was lost. The confusing thing is existing
files.
>
> If the box crashed but oracle files were not damaged you can simply start
the
> database.
> This is called instance recovery - not this, but what oracle needs to do
to
> recover.
>
> If something was damaged, then there is a lot of recovery options
depending on
> your
> particular situation. Recovery techniques are something that you should
well
> understand
> to be successful. I recommend Rama Velpuri's book, it has both recovery
> scenarios and
> recovery concepts.
>
>
>
>
> Winbatch wrote:
>
> > Hi,
> > Last week our AIX box crashed and we needed to start over with a clean
> > install. Luckily, we had week old backups of the system which included
the
> > oracle database files. Is there anyway if I now reinstall oracle that I
can
> > use my existing database files? We have no other source of the data we
> > need. What would be the procedure? Would I not have the install create
a
> > database? How do I take my .dbf files that I have backed up and making
them
> > 'active'? THe oracle version we are using is 8.1.6.
> >
> > Thanks!
>
Received on Fri Aug 09 2002 - 21:24:27 CDT