Re: Flashback log file sync

From: Jonathan Lewis <>
Date: Sun, 13 May 2012 07:54:15 +0100
Message-ID: <>

"Mladen Gogala" <> wrote in message
| 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)


Jonathan Lewis
Oracle Core (Apress 2011)

| If the block being changed is in SGA, th
Received on Sun May 13 2012 - 01:54:15 CDT

Original text of this message