Thank you. Sorry about not checking back right away.
On Fri, Jul 7, 2017 at 1:32 PM, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
I've just discovered I wrote a couple of potentially useful blog notes
about the costs and impact of flashback logging a couple of years ago:
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Andy Klock <andy@xxxxxxxxxxxxxxx>
Sent: 07 July 2017 14:16:31
Subject: Re: Anyway to estimate how much space flashback logs space will
be needed in 220.127.116.11?
On Thu, Jul 6, 2017 at 12:52 PM, Dba DBA <oracledbaquestions@xxxxxxxxx<
If I make a guaranteed restore point for a specific point in time. If the
DB generates archivelog, is there a way to estimate how much space will be
needed? We have limited space and may need to backout a build coming. The
build includes a data migration. One option is to take a backout and
restore from backup. The other options is a guaranteed restore point. The
migration scripts are done by a whole other group. I have no idea how much
archivelog will be generated.
From my notes, see:
How To Calculate the Size of the Generated Flashback Logs (Doc ID 761126.1)