Re: Anyway to estimate how much space flashback logs space will be needed in 11.2.0.4?

  • From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "oracledbaquestions@xxxxxxxxx" <oracledbaquestions@xxxxxxxxx>, "andy@xxxxxxxxxxxxxxx" <andy@xxxxxxxxxxxxxxx>
  • Date: Fri, 7 Jul 2017 17:32:33 +0000


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:
https://jonathanlewis.wordpress.com/2015/03/09/flashback-logging/
https://jonathanlewis.wordpress.com/2015/03/11/flashback-logging-2/

Regards
Jonathan Lewis

________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf 
of Andy Klock <andy@xxxxxxxxxxxxxxx>
Sent: 07 July 2017 14:16:31
To: oracledbaquestions@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: Anyway to estimate how much space flashback logs space will be 
needed in 11.2.0.4?

On Thu, Jul 6, 2017 at 12:52 PM, Dba DBA 
<oracledbaquestions@xxxxxxxxx<mailto:oracledbaquestions@xxxxxxxxx>> wrote:
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)
http://blog.oracle-ninja.com/wp-content/uploads/2012/05/13445-pedregalcolvin-514442.pdf
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/flashdb.htm#BRADV71000

 Thanks,

Andy K
--
http://www.freelists.org/webpage/oracle-l


Other related posts: