MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_4b95142449831392a12702038edc4d82"
Date: Wed, 10 Oct 2018 15:38:32 -0500
From: Rich J <rjoralist3@society.servebeer.com>
To: oracle-l@freelists.org
Subject: Re: Flashback guaranteed restore point with ADG for DB upgrade
 fallback
In-Reply-To: <CAGV8MGqijSJ0JakLg1Laa83x0i7abEBBhaRwsCFR5trzhc5_OQ@mail.gmail.com>
References: <b02b36585ef1bf38bd21e91b4de7e523@society.servebeer.com>
 <CABe10saNZYSTBMWc8=rTTWhzhH=dH+Kanb_v_DkRnPUFkRKjSw@mail.gmail.com>
 <CAGV8MGqijSJ0JakLg1Laa83x0i7abEBBhaRwsCFR5trzhc5_OQ@mail.gmail.com>
Message-ID: <6587960a4d99a355ca5a2c49f9aa7507@society.servebeer.com>
User-Agent: Roundcube Webmail/1.3.7
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: rjoralist3@society.servebeer.com
--=_4b95142449831392a12702038edc4d82
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

On 2018/10/10 13:11, Jose Rodriguez wrote:

> I've recently used the exact same approach for an ADG upgrade. This was 11.2.0.3 to 11.2.0.4, but the idea is the same. 
> As Niall says, just enable flashback database on both sides, create a GRP on the standby first and then on the primary, so you have an older SCN on the standby in case of a rollback. 
> Bear in mind the required FRA space for the flashback logs, not much for the upgrade itself, but this will be recording the applied redo on the standby as well if I recall correctly. 
> I tested it and it worked like a charm. 
> I am not at my desk right now, so I can't share any docs, but I'll take a look tomorrow.

I'm testing this now, and have gotten further than I did before, but am
getting ORA-19909 starting MRP on the standby.  Looking at V$INSTANCE,
the instance_role is "PRIMARY_INSTANCE".  It appears someone forgot to
use the "STANDBY" keyword when doing the flashback.  Doh.  At least that
sounds like it could be the cause. 

I don't want to spend the amount of time it would take to properly test
the effects of enabling flashback on the databases, which appears to be
necessary to flashback to an SCN on the standby.  Creating a guaranteed
restore point on the standby seems to be the way to go here, as Oracle
allowed it, even if I...erm, "someone"...forgot the proper keyword. 

More testing tomorrow -- thanks all for the replies! 

Rich
--=_4b95142449831392a12702038edc4d82
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen=
eva,sans-serif'>
<p>On 2018/10/10 13:11, Jose Rodriguez wrote:</p>
<blockquote type=3D"cite" style=3D"padding: 0 0.4em; border-left: #1010ff 2=
px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ig=
nored -->
<div dir=3D"auto">I've recently used the exact same approach for an ADG upg=
rade. This was 11.2.0.3 to 11.2.0.4, but the idea is the same.
<div dir=3D"auto">As Niall says, just enable flashback database on both sid=
es, create a GRP on the standby first and then on the primary, so you have =
an older SCN on the standby in case of a rollback.</div>
<div dir=3D"auto">Bear in mind the required FRA space for the flashback log=
s, not much for the upgrade itself, but this will be recording the applied =
redo on the standby as well if I recall correctly.</div>
<div dir=3D"auto">I tested it and it worked like a charm.</div>
<div dir=3D"auto">I am not at my desk right now, so I can't share any docs,=
 but I'll take a look tomorrow.</div>
</div>
</blockquote>
<p>I'm testing this now, and have gotten further than I did before, but am =
getting ORA-19909 starting MRP on the standby.&nbsp; Looking at V$INSTANCE,=
 the instance_role is "PRIMARY_INSTANCE".&nbsp; It appears someone forgot t=
o use the "STANDBY" keyword when doing the flashback.&nbsp; Doh.&nbsp; At l=
east that sounds like it could be the cause.</p>
<p>I don't want to spend the amount of time it would take to properly test =
the effects of enabling flashback on the databases, which appears to be nec=
essary to flashback to an SCN on the standby.&nbsp; Creating a guaranteed r=
estore point on the standby seems to be the way to go here, as Oracle allow=
ed it, even if I...erm, "someone"...forgot the proper keyword.</p>
<p>More testing tomorrow -- thanks all for the replies!</p>
<p>Rich</p>
</body></html>

--=_4b95142449831392a12702038edc4d82--
--
http://www.freelists.org/webpage/oracle-l