RE: Re[1] : Recovery Scenarios - Help (did you already crash?)
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <peter.gram@xxxxxxxxxxxx>, <premj@xxxxxxxxxxxxxx>
- Date: Mon, 29 Nov 2004 11:00:25 -0500
Depends. Did you crash or hang? Were any dirty blocks in the buffer cache
remaining that were dependent on the log that was lost when you crashed or
shut down?
Now if you had any dirty block in the buffer, crashed(losing the dirty
blocks) and the online log you lost was indeed the current log (not what the
poster wrote, but not too wild an assumption), then I believe you have lost
all sources of producing block images consistent with a complete recovery
from the existing database files. Hmm. Maybe one more out - if all the
"lost" dirty blocks were from uncommitted transactions, it is possible that
rollback from the UNDO could allow full consistent recovery, but you might
need to write a special program to use the information in UNDO, because I
*think* Oracle's recovery establishes a consistent redo point before the
rollback is performed. If you've got dirty blocks at all, though, it seems
likely you've got dirty blocks for UNDO, so that probably is a dead end.
Suppose for a moment that the database did not crash (yet).
Can you switch to a log that remains available or to a new log? (I haven't
tested recent versions. Testdb online logs, your days(hours) are numbered!)
Will checkpoint and patience assure that your database files don't need any
of the current online logs?
Your proper action might well not be a recovery at all, but rather a full
hot backup (since the thread of continuous redo logs from any previous
backup is lost.)
Now if the online log lost is indeed the current log and you already crashed
with dirty blocks I think you're limited as Peter indicated.
Regards,
mwf
>
>>>Case 3
>>>------
>>>I have lost an un-archived online redo log file.The proper recovery pr=
ocedure is :
>>>- restore all datafiles from backup
>>>- mount the database
>>>- recover until cancel
>>>- open resetlogs
>>>
>>>Without restoring datafiles from backup,Can i do this :=20
>>>- mount the database
>>>- recover until cancel
>>>- open resetlogs
>>> =20
>>>
>
>when i recover/resetlogs without restoring the
>datafiles from backup , the database will be inconsistent
>state ... am i right ?
>
> =20
>
You will not be able to open the database since the current redolog is=20
missing.
You can get more infomation on Oracle and revovery from *Oracle9/i/=20
Backup and Recovery Concepts Release 2 (9.2),*
*Chapter 3 Recovery Principles*
****
**/peter
**
>Thanks and Regards,
>Prem.
>
>--
>//www.freelists.org/webpage/oracle-l
>
> =20
>
--=20
Best regards / Venlig hilsen
/*Peter Gram*/
Miracle A/S <http://www.miracleas.dk>
Kratvej 2
DK - 2760 M=E5l=F8v
Cell: (+45) 2527 7107
Phone: (+45) 4466 8855
Fax: (+45) 4466 8856
Home: (+45) 3874 5696
Skype: peter_gram
Email: peter.gram@xxxxxxxxxxxx
22-24 Nov 2004 RMAN-kursus med Tuomas Pystynen=20
17-19 Jan 2005 Miracle Master Class with Tim Gorman=20
28 feb - 2.mar 2005 Database Master Class with Chris Date=20
2-4 May 2005 SQL Server Master Class with Kimberly Tripp=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: Re[1] : Recovery Scenarios - Help (did you already crash?)
