Re: Quick standby setup

From: Mike Killough <mwkillough_at_hotmail.com>
Date: Fri, 9 Sep 2022 20:00:34 +0000
Message-ID: <MW4PR17MB5925C8DA850F5D0057ECF7CAC2439_at_MW4PR17MB5925.namprd17.prod.outlook.com>



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_at_gmail.com> wrote:


Instead of doing a failover, you would need to do a switchover. You should 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_at_hotmail.com<mailto:mwkillough_at_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 becomes primary, we would like to be able to have a standby 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?

Mike Killough

Sent from my iPhone

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 09 2022 - 22:00:34 CEST

Original text of this message