Re: Roll forward using Archive Logs

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 15 May 2006 13:47:05 -0700
Message-ID: <1147726025.077114.20660@j33g2000cwa.googlegroups.com>

>Do you mean uncommitted transactions ? Those
>are not in the archived log files, but in the online redo log files.

Matthias,

this is not correct: redo for uncommitted transactions can be archived. However, archived redo not needed for *crash* recovery.

Actually, my first response uses sloppy wording when it says that redo for uncommitted transactions is not needed for crash recovery - it *is* needed for cache recovery phase, but all redo needed for cache recovery is in active online logs.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon May 15 2006 - 15:47:05 CDT