Re: rollback after crash

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Dec 2005 22:27:15 +0100
Message-ID: <2g31q19qai6mtglnfubgeia7j67uopt0e3@4ax.com>

On 14 Dec 2005 08:01:38 -0800, "Pradeep" <agarwalp_at_eeism.com> wrote:

>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

redo log is not overwritten, redo log is *archived*

And your description of how a transaction is being processed is woefully inadequate.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Dec 14 2005 - 15:27:15 CST