Re: Redo Log Question

From: Rob Medley <medleyrk_at_iafrica.com>
Date: Wed, 27 Jan 1999 22:58:47 +0200
Message-ID: <36AF7E06.2381261@iafrica.com>

Hi,

I stand to be corrected, but if you are running in NoArchiveLog mode, then in your scenario Oracle would overwrite the first Redo Log and keep on going with the transaction. If the transaction were to fail, then the Rollback segments would be used (as for any transaction) to roll it back.

Rob

> Hi,
>
> If you're running Oracle in non-archive log mode and you have a large
> transaction that has not been committed before Oracle is ready to over-
> write the redo log that contains the start of the transaction - what
> does Oracle do ?
>
> I think this makes sense.
>
> Alan
Received on Wed Jan 27 1999 - 14:58:47 CST