Re: RedoLog file corrupted!!

From: srivenu <srivenu_at_hotmail.com>
Date: 22 Oct 2002 21:45:09 -0700
Message-ID: <1a68177.0210222045.55d04921@posting.google.com>

In some circumstances You can recover the database even if an online redo is lost or corrupted.
1) If the last shutdown was proper, you can open the database with resetlogs after doing a dummy recovery.

2) If the last shutdown was not proper, it depends on factors like 
a) whether the redo that was lost is the CURRENT one or not, 
b) if it is not the CURRENT one, the checkpoint initiated after it was

switched was completed or not.

Before you start doing any thing, i recommend that you backup the existing database so that you can start again in case you make a mistake during recovery.

regards
Srivenu Received on Tue Oct 22 2002 - 23:45:09 CDT