Re: Flashback log file sync

"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news:pan.2012.05.12.21.10.26_at_gmail.com...
|
| Flashback logs, just like their redo counterparts, record change vectors,
| in order to be able to reconstruct the data, up to specific point in
| time. The default is 24 hours, controlled by the
| "db_flashback_retention_target" parameter.
|

Flashback logs hold entire Oracle blocks (think Oracle 5 and the BI file).

However they don't (normally) hold a copy of every version of the block that has every existed; you should get something like one copy per flashback log file to cover all the changes that have happened to a block since it was most recently loaded into the buffer cache (compare redo logging full blocks when tablespaces are in backup mode)

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com
Oracle Core (Apress 2011)
http://www.apress.com/9781430239543



| If the block being changed is in SGA, th