MIME-Version: 1.0
In-Reply-To: <CAE-dsOJ4vU5LVVrOkvF4Nt6chCiBUUE7tfO3xnxZFqRv2M0jHw@mail.gmail.com>
References: <CAE-dsOJ4vU5LVVrOkvF4Nt6chCiBUUE7tfO3xnxZFqRv2M0jHw@mail.gmail.com>
From: Andy Klock <andy@oracledepot.com>
Date: Fri, 7 Jul 2017 09:16:31 -0400
Message-ID: <CADo_RaOyJ=Ziwv3eBJmnueZ=AB8+6DzrYQ=95mfOqiQzob2faA@mail.gmail.com>
Subject: Re: Anyway to estimate how much space flashback logs space will be
 needed in 11.2.0.4?
To: "oracledbaquestions@gmail.com" <oracledbaquestions@gmail.com>
Cc: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="001a1143223aaad4710553ba0a76"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: andy@oracledepot.com
--001a1143223aaad4710553ba0a76
Content-Type: text/plain; charset="UTF-8"

On Thu, Jul 6, 2017 at 12:52 PM, Dba DBA <oracledbaquestions@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

--001a1143223aaad4710553ba0a76
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On T=
hu, Jul 6, 2017 at 12:52 PM, Dba DBA <span dir=3D"ltr">&lt;<a href=3D"mailt=
o:oracledbaquestions@gmail.com" target=3D"_blank">oracledbaquestions@gmail.=
com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex"><div dir=3D"ltr"><div>If I make a guaranteed restore point for a specif=
ic point in time. If the DB generates archivelog, is there a way to estimat=
e how much space will be needed? We have limited space and may need to back=
out a build coming. The build includes a data migration. One option is to t=
ake a backout and restore from backup. The other options is a guaranteed re=
store point. The migration scripts are done by a whole other group. I have =
no idea how much archivelog will be generated.=C2=A0</div></div></blockquot=
e><div><br></div><div>From my notes, see:=C2=A0</div><div><br></div><div><s=
pan style=3D"color:rgb(0,0,0);font-family:Tahoma,Verdana,Helvetica,sans-ser=
if;font-size:14.3px;text-align:right">How To Calculate the Size of the Gene=
rated Flashback Logs (Doc ID 761126.1)</span><br></div><div><span style=3D"=
text-align:right"><font color=3D"#000000" face=3D"Tahoma, Verdana, Helvetic=
a, sans-serif"><span style=3D"font-size:14.3px"><a href=3D"http://blog.orac=
le-ninja.com/wp-content/uploads/2012/05/13445-pedregalcolvin-514442.pdf">ht=
tp://blog.oracle-ninja.com/wp-content/uploads/2012/05/13445-pedregalcolvin-=
514442.pdf</a></span></font></span></div><div><span style=3D"font-size:14.3=
px;color:rgb(0,0,0);font-family:Tahoma,Verdana,Helvetica,sans-serif;text-al=
ign:right"><a href=3D"https://docs.oracle.com/cd/E11882_01/backup.112/e1064=
2/flashdb.htm#BRADV71000">https://docs.oracle.com/cd/E11882_01/backup.112/e=
10642/flashdb.htm#BRADV71000</a></span><br></div><div><span style=3D"text-a=
lign:right"><font color=3D"#000000" face=3D"Tahoma, Verdana, Helvetica, san=
s-serif"><div style=3D"font-size:14.3px"><br></div></font></span></div><div=
>=C2=A0Thanks,</div><div><br></div><div>Andy K</div></div></div></div>

--001a1143223aaad4710553ba0a76--
--
http://www.freelists.org/webpage/oracle-l