Re: Lost active online redo log, noarchive mode. Is this bad?
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