Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> !!! database recovery HELP!!!
Morning Qwerty,
When you open a database and get told that file 'n' needs recovery, you simply type 'recover database' and let the recovery proced using the on-line redo logs. This normally solves any problems. If this fails then you need to restore a/some data files and do a recovery from archived logfiles plus the on-line logs as appropriate.
In the case of having to restore from a dump, the first thing you should do is shutdown and take a cold backup of the current (crap) database. This adds time to the recovery but at least you have a place to get back to if you bollox up the main recovery.
I'd be willing to bet that when you 'recoverd day before yesterday' that you recovered your controlfiles as well. If you did then you managed to bollox your chances of applying the archived redo logs because the old controlfile doesn't know about them. When doing a recovery with a following 'recover database' then you DO NOT restore the control files. In your recovered database, the SCN etc in the control file matches up to the SCN in the data file(s) so the database is restored correctly.
If you had only recoverd the datafiles, you would have had an old SCN in the datfile headers and the correct latest one in the controlfiles, so you would have been told that you needed to recover the database and could then start applying archived logs.
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Mon Jun 09 2003 - 03:01:46 CDT
-------------------------------------