Re: Redo Log Question

From: <kvsraju_at_my-dejanews.com>
Date: Fri, 05 Feb 1999 05:15:01 GMT
Message-ID: <79duog$ho$1@nnrp1.dejanews.com>

In article <36AF7E06.2381261_at_iafrica.com>, Rob Medley <medleyrk_at_iafrica.com> wrote:
> 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
>

> Hi,

Wheter you r in archive or noarchive log mode . when u give arollback oracle don't use logfiles. It always use rollback segments
So irrespective whether u'r transaction is completed or not oracle will overwrite the logfiles.
These logfiles are used only as part of recovery of the database.

rgds
kvsraju_at_polaris.co.in

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 23:15:01 CST