Re: redo logs in noarchivelog mode

From: Subodh Deshpande <>
Date: Thu, 29 Mar 2012 08:59:44 +0530
Message-ID: <>

Yes, may be a stupid question and may not be, I think you are curious :) oracle rdbms architecture is such that you require redo logs whether you want to run the oracle database in noarchivelog mode or not.. during the crash recovery redo is not the only one component and there are others too..
similarly, about making transactions into dbf files, redo is not the only one component and there are other components too. just writing to dbf file is not important, it should be made available whenever it requires back for every meaningful purpose(such as select, insert,update, delete)..
yes, documentation is also available on oracle site and there are a lot of books available about oracle architecture..


On 28 March 2012 20:07, 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?
> Thanks,
> Carmelinda
> --

Love me or Hate me both are in my Favour.
Love me, I am in your Heart. Hate me, I am in your Mind.

Received on Wed Mar 28 2012 - 22:29:44 CDT

Original text of this message