Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: A Theoretical Situation
Oracle will not 'wrap' onto an 'active', one containing open
transactions,
redo log in archivelog mode.
-- Scott Thompson Alan Gano wrote:Received on Fri Aug 01 1997 - 00:00:00 CDT
> Hi,
>
> Assuming an instance of this configuration:
> - 5 redo logs of 10K each.
>
> Assume this situation:
> - A single transaction (say an UPDATE) produces more than 50K of redo
> information, filling the redo logs, and then wraps around.
> - There is plenty of rollback space for the transaction.
> - The transaction is not committed.
>
> In this situation, some redo information concerning the transaction is
>
> being overwritten or written off to offline archive logs. I would
> assume
> that at least some of the modified blocks for this
> offlined/overwritten
> information has been getting written out to the datafiles by DBWR.
>
... lines deleted ...
![]() |
![]() |