Re: rollback after crash

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 14 Dec 2005 16:21:58 GMT
Message-ID: <Xns972C550AA35AFSunnySD@70.168.83.30>

"Pradeep" <agarwalp_at_eeism.com> wrote in news:1134576000.307813.127720_at_g14g2000cwa.googlegroups.com:

> Sybrand,
>
> With redo i mean redo logs.
> Suppose i have 2 redo log files.
> I run an update statement.
> T1) Corresponding details gets logged into redo log file 1.
> The uncommitted data frm buffer cache and undo is flushed to the disk
> subsequent transactions results
> redo log1 gets full -> log switch -> redo log 2 gets full -> log switch
> -> redo log 1 is over written here.
>
> So after over writing redo files if my instance crashes how does it
> recovers or rollbacks the uncommitted data which occured at T1
>
> I hope my question is clear
>

What part of "redo is NEVER EVER overwritten." do you NOT understand.

Your "hypothesis is flawed, faulty & will NOT occur. Received on Wed Dec 14 2005 - 10:21:58 CST