Redo only contains the actual changed data and
control information, I seem to remember Oracles
official term is called a 'redo vector'. The only time
full blocks are in the redo is when a tablespace is
in 'hot backup mode' (after a 'begin backup') and
even then only under certain circumstances, i.e.
the first insert into a block. So, even in this case
blocks are not 'duplcated'.
--
Scott Thompson
terryg8 wrote:
> Hello,
>
> We have a batch update job that generates a lot
> of redo log activity and subsequently a bunch of
> archiving. Moreso than seems reasonable.
> My understanding of redo logs is that any change to
> a block result in the whole block being written to
> the redo log.
> ... lines deleted ...
>
> Cheers,
> Terry
Received on Mon Aug 04 1997 - 00:00:00 CDT
