Re: Why does Orcl generate REDO logs in NOARCHIVE mode?

From: Monique van Daal <mvdaal_at_arisco.nl>
Date: Fri, 26 Mar 1999 16:35:10 GMT
Message-ID: <36fbb725.29833166@news.atriserv.nl>

Ever heard about a crash, and a crash recovery?

On 23 Mar 1999 23:20:58 GMT, kittu_at_Hawaii.Edu (Chakravarthy KM Nalamotu) wrote:

>Hello Oracle Users,
>I was wondering if someone could explain why Oracle
>writes transactions to redo logs even though
>the database is running in NOARCHIVELOG mode.
>If I am running in NOARCHIVELOG mode, doesn't it mean
>that I don't need the logs which also should include redo logs?
>What good are these logs doing to me except for wasting
>my system resources?
>There must be a good reason for this.
>Can someone explain the logic behind this architecture.
>Thanx,
> Kittu.
Received on Fri Mar 26 1999 - 10:35:10 CST