Re: Anyway to estimate how much space flashback logs space will be needed in 11.2.0.4?
Date: Fri, 7 Jul 2017 17:32:33 +0000
Message-ID: <MMXP123MB103740781D83B7B6950DCF2DA5AA0_at_MMXP123MB1037.GBRP123.PROD.OUTLOOK.COM>
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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Andy Klock <andy_at_oracledepot.com> Sent: 07 July 2017 14:16:31
To: oracledbaquestions_at_gmail.com
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_at_gmail.com<mailto:oracledbaquestions_at_gmail.com>> 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-lReceived on Fri Jul 07 2017 - 19:32:33 CEST