From: Jonathan Lewis <jonathan@jlcomp.demon.co.uk>
To: "oracledbaquestions@gmail.com" <oracledbaquestions@gmail.com>,
 "andy@oracledepot.com" <andy@oracledepot.com>
CC: ORACLE-L <oracle-l@freelists.org>
Subject: Re: Anyway to estimate how much space flashback logs space will be
 needed in 11.2.0.4?
Thread-Topic: 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@MMXP123MB1037.GBRP123.PROD.OUTLOOK.COM>
References: <CAE-dsOJ4vU5LVVrOkvF4Nt6chCiBUUE7tfO3xnxZFqRv2M0jHw@mail.gmail.com>,<CADo_RaOyJ=Ziwv3eBJmnueZ=AB8+6DzrYQ=95mfOqiQzob2faA@mail.gmail.com>
In-Reply-To: <CADo_RaOyJ=Ziwv3eBJmnueZ=AB8+6DzrYQ=95mfOqiQzob2faA@mail.gmail.com>
Accept-Language: en-GB, en-US
Content-Language: en-GB
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Jul 2017 17:32:33.2548
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: c5ec3dea-08bd-405e-942c-f61dff9a4831
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MMXP123MB1039
X-archive-position: 68732
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: jonathan@jlcomp.demon.co.uk
Precedence: normal
Reply-To: jonathan@jlcomp.demon.co.uk
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:mark.bobak@proquest.com>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l


I've just discovered I wrote a couple of potentially useful blog notes abou=
t 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@freelists.org <oracle-l-bounce@freelists.org> on beha=
lf of Andy Klock <andy@oracledepot.com>
Sent: 07 July 2017 14:16:31
To: oracledbaquestions@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@gmail.com<mail=
to:oracledbaquestions@gmail.com>> wrote:
If I make a guaranteed restore point for a specific point in time. If the D=
B generates archivelog, is there a way to estimate how much space will be n=
eeded? We have limited space and may need to backout a build coming. The bu=
ild 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 archivelo=
g 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-pedregalcolvi=
n-514442.pdf
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/flashdb.htm#BRADV710=
00

 Thanks,

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