SSChris,
The first question is, "Has your database been in ARCHIVELOG mode since prior to your failure?" If the answer is, "No", then you cannot "recover" the database; at best, you can only "restore" the database to the point in time of the last backup (or export, if that is what you are using in lieu of ARCHIVELOG mode.)
If you
are in ARCHIVELOG mode, and if you have an unbroken chain of archived log files since your last full backup, then you do the following:
1) Ensure that the database instance is shutdown.
2) Restore to disk your most recent full backup of your database data files. (Do not restore your control files and your on-line redo log files; you want them to be up-to-the-moment current for the recovery process.)
3) Issue the following commands:
Code:
sqlplus /nolog
connect / as sysdba
startup mount
recover database
alter database open;
If everything worked properly, it results in an open, working database.
![[santa] [santa] [santa]](/data/assets/smilies/santa.gif)
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use
Oracle and live or work in
Utah, USA?
Then click here to join
Utah Oracle Users Group on Tek-Tips.