Re: redo logs in noarchivelog mode

From: Norman Dunbar <>
Date: Wed, 28 Mar 2012 15:52:58 +0100
Message-ID: <>

Hi Carmelinda,

On 28/03/12 15:37, Richard, Carmelinda wrote:
> This may be a stupid question, but I was installing a new database for the first time, and I started wondering, what is the useful purpose of redo logs if a database is in noarchivelog mode? Only if the database crashes and transactions were written to the redo logs before they make it into the database files?
If you shutdown abort, then the startup will do instance recover using the online redo logs.

Also, sometimes a problem in the database, can be overcome by RECOVER DATABASE which uses the online redo log to solve the problem.

Other than that, there's no reason why anyone would want to run a database in noarchive log mode!


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
Received on Wed Mar 28 2012 - 09:52:58 CDT

Original text of this message