Re: Is Self Recovery Possible?

If you have all the control files, datafiles and on line redo log files, all you need to do is change the init.ora file to have the correct db_name, and the control_files parameter pointing to the control files. After this, the database should start without any problems. If, as you say, you did not loose any Oracle data files, all that Oracle will do is Crash Recovery.

Andrew

huntbright_at_my-dejanews.com wrote:

> Hello,
>
> OS and Oracle crashed due to disk permanent failure, but all the
> controlfiles, datafiles, redo logs and init file are fine since they were
> stored on other disks. I've reinstalled OS and Oracle, now the challenge is
> how to make the new Oracle recoganize previous files to recover the database.
> There's no backup at all. I'm considering startup a new database and replace
> it with previous files but I'm not sure. Is it possible for Oracle to do such
> a "self-recovery"? Or, can I use the saved previous files as the backup and
> do recovery from them? Please help me out of this issue.
>
> B.R.
> Hunt
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Apr 25 1999 - 01:51:24 CDT