MIME-Version: 1.0
References: <CACj1VR54XKHuC=T8LtJAcpGCuF5SfnTHYsSZ7xOTw_U4o3Qcsg@mail.gmail.com>
 <MW4PR17MB5925C8DA850F5D0057ECF7CAC2439@MW4PR17MB5925.namprd17.prod.outlook.com>
 <MW4PR17MB59259E38312DFE44FC397A38C2439@MW4PR17MB5925.namprd17.prod.outlook.com>
In-Reply-To: <MW4PR17MB59259E38312DFE44FC397A38C2439@MW4PR17MB5925.namprd17.prod.outlook.com>
From: Andy Sayer <andysayer@gmail.com>
Date: Fri, 9 Sep 2022 13:19:50 -0700
Message-ID: <CACj1VR6di64BZc6gr5BA4yTJbiCUQTkkLdwVfJ2CY3QQYok38g@mail.gmail.com>
Subject: Re: Quick standby setup
To: Mike Killough <mwkillough@hotmail.com>
Cc: list oracle <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="0000000000004c19a905e84445b3"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: andysayer@gmail.com
--0000000000004c19a905e84445b3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I would:
Connect via dgmgrl
Show configuration when primary is 'DB_B';
Confirm that redo goes from DB_B to DB_C (and DB_A but we=E2=80=99ll be rem=
oving
that later).
If there=E2=80=99s no route then
Edit database 'DB_B' set property redoroutes =3D '(LOCAL:DB_C)';
And confirm again

If happy, do
Validate database verbose 'DB_B';
And if happy
Switchover to 'DB_B=E2=80=99;

Once switchover complete and you=E2=80=99ve confirmed DB_C is being updated=
. Remove
DB_A from all redoroutes on B and C (C should look similar to B).
Disable database 'DB_A';
Remove database 'DB_A';

Then you should be okay to shut down DB_A.

Thanks,
Andy

On Fri, Sep 9, 2022 at 1:04 PM, Mike Killough <mwkillough@hotmail.com>
wrote:

> Sorry for the repeat first send said failed but it didn=E2=80=99t.
>
> Sent from my iPhone
>
> On Sep 9, 2022, at 3:01 PM, Mike Killough <mwkillough@hotmail.com> wrote:
>
> =EF=BB=BF Ok so I could do a switchover to B and C and A become standbys,=
 then
> remove A from the configuration before shutting it down and closing the
> data center? No hard failover. Thanks
>
>
>
> Sent from my iPhone
>
> On Sep 9, 2022, at 2:32 PM, Andy Sayer <andysayer@gmail.com> wrote:
>
> =EF=BB=BF
> Instead of doing a failover, you would need to do a switchover. You shoul=
d
> set up your redoroutes in advance in dgmgrl. You should also use this to
> test the configuration using the
> Show configuration when primary is DB_B.
> Syntax
>
> Remove the old server from the redo routes before getting rid of it.
>
> Hope that helps,
> Andy
>
> On Fri, Sep 9, 2022 at 11:51 AM, Mike Killough <mwkillough@hotmail.com>
> wrote:
>
>> Currently we have a primary database (DB_A) and 2 standbys (DB_B & DB_C)=
.
>> We are planning on hard failing over to one of the standby databases to
>> retire the current primary. To protect the future standby when it become=
s
>> primary, we would like to be able to have a standby right away if possib=
le.
>> When we fail over to DB_B, is there a way to make DB_C immediately be th=
e
>> standby for DB_B?
>>
>> Mike Killough
>>
>> Sent from my iPhone
>>
>

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

<div dir=3D"auto">I would:</div><div dir=3D"auto">Connect via dgmgrl</div><=
div dir=3D"auto">Show configuration when primary is &#39;DB_B&#39;;</div><d=
iv dir=3D"auto">Confirm that redo goes from DB_B to DB_C (and DB_A but we=
=E2=80=99ll be removing that later).</div><div dir=3D"auto">If there=E2=80=
=99s no route then</div><div dir=3D"auto">Edit database &#39;DB_B&#39; set =
property redoroutes =3D &#39;(LOCAL:DB_C)&#39;;</div><div dir=3D"auto">And =
confirm again</div><div dir=3D"auto"><br></div><div dir=3D"auto">If happy, =
do</div><div dir=3D"auto">Validate database verbose &#39;DB_B&#39;;</div><d=
iv dir=3D"auto">And if happy</div><div dir=3D"auto">Switchover to &#39;DB_B=
=E2=80=99;</div><div dir=3D"auto"><br></div><div dir=3D"auto">Once switchov=
er complete and you=E2=80=99ve confirmed DB_C is being updated. Remove DB_A=
 from all redoroutes on B and C (C should look similar to B).=C2=A0</div><d=
iv dir=3D"auto">Disable database &#39;DB_A&#39;;</div><div dir=3D"auto">Rem=
ove database &#39;DB_A&#39;;</div><div dir=3D"auto"><br></div><div dir=3D"a=
uto">Then you should be okay to shut down DB_A.</div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Andy</div><div><br><=
div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Sep=
 9, 2022 at 1:04 PM, Mike Killough &lt;<a href=3D"mailto:mwkillough@hotmail=
.com">mwkillough@hotmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex">


<div dir=3D"auto">
Sorry for the repeat first send said failed but it didn=E2=80=99t.<br>
<br>
<div dir=3D"ltr">Sent from my iPhone</div>
<div dir=3D"ltr"><br>
<blockquote type=3D"cite">On Sep 9, 2022, at 3:01 PM, Mike Killough &lt;<a =
href=3D"mailto:mwkillough@hotmail.com" target=3D"_blank">mwkillough@hotmail=
.com</a>&gt; wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF Ok so I could do a switchover to B and C and A b=
ecome standbys, then remove A from the configuration before shutting it dow=
n and closing the data center? No hard failover. Thanks</div></blockquote><=
/div><div dir=3D"auto"><blockquote type=3D"cite"><div dir=3D"ltr"><br>
<br>
<div dir=3D"ltr">Sent from my iPhone</div>
<div dir=3D"ltr"><br>
<blockquote type=3D"cite">On Sep 9, 2022, at 2:32 PM, Andy Sayer &lt;<a hre=
f=3D"mailto:andysayer@gmail.com" target=3D"_blank">andysayer@gmail.com</a>&=
gt; wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF
<div dir=3D"auto">Instead of doing a failover, you would need to do a switc=
hover. You should set up your redoroutes in advance in dgmgrl. You should a=
lso use this to test the configuration using the=C2=A0</div>
<div dir=3D"auto">Show configuration when primary is DB_B.=C2=A0</div>
<div dir=3D"auto">Syntax=C2=A0</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Remove the old server from the redo routes before getting=
 rid of it.</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Hope that helps,</div>
<div dir=3D"auto">Andy</div>
<div><br>
<div class=3D"gmail_quote">
<div dir=3D"ltr" class=3D"gmail_attr">On Fri, Sep 9, 2022 at 11:51 AM, Mike=
 Killough &lt;<a href=3D"mailto:mwkillough@hotmail.com" target=3D"_blank">m=
wkillough@hotmail.com</a>&gt; wrote:<br>
</div>
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:r=
gb(204,204,204)">
<div dir=3D"auto"><span style=3D"background-color:rgb(255,255,255)">Current=
ly we have a primary database (DB_A) and 2 standbys (DB_B &amp; DB_C). We a=
re planning on hard failing over to one of the standby databases to retire =
the current primary. To protect the future
 standby when it becomes primary, we would like to be able to have a standb=
y right away if possible. When we fail over to DB_B, is there a way to make=
 DB_C immediately be the standby for DB_B?</span><br>
<div>
<div dir=3D"ltr" data-smartmail=3D"gmail_signature">
<div dir=3D"ltr">
<div style=3D"font-family:arial;font-size:small"><br>
</div>
<div style=3D"font-family:arial;font-size:small">Mike Killough</div>
</div>
</div>
</div>
<br>
<div dir=3D"ltr">Sent from my iPhone</div>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>

</blockquote></div></div>

--0000000000004c19a905e84445b3--
--
http://www.freelists.org/webpage/oracle-l