Re: Lost active online redo log, noarchive mode. Is this bad?

From: Sybrand Bakker <Sybrand.Bakker_at_Bentley.nl>
Date: 1995/10/10
Message-ID: <45d7fd$b2f_at_sun630.bentley.com>#1/1


Cary,

Yes it is bad. The only thing you can do is either a) cancel the recovery at the point Oracle prompts you for the lost logfile
b) perform a manual recovery (Recover ... until <date-time>) After this you have to open the database with the following command alter database .. open RESETLOGS.
This does what it says, so it simply forgets anything that was done. If the logfile you last was not the (chronological) last one, you will have lost data/changes on data.
NEVER run a production database in NOARCHIVELOG, except for administrative tasks like defragmenting, recreating indexes and so on, making a cold backup after this kind of work. Always read your manuals and your online recovery.doc (in ORA_HOME/rdbms../admin) carefully. In a previous job I had to recover a database many times because of diskcrashes (1 per month) and I was always able to do so, because I was running in archivelog mode.

Sybrand Bakker
Senior IS Analyst
Bentley Systems Europe
Hoofddorp
The Netherlands Received on Tue Oct 10 1995 - 00:00:00 CET

Original text of this message