Re: System Crash, how to restore database?

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 - 07:20:12 CEST