Dataguard Sanity Check Please - One-Node Primary to RAC Standby (19.17)

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 18 Jul 2023 11:39:48 -0400
Message-ID: <CAP79kiRcWdh3V2ccib66hWrWLT-Et=EOueaNBEFk3VGQw59usQ_at_mail.gmail.com>



Hey folks, just need a sanity check here for a VALIDATE on Dataguard.

In this scenario (as preparing for migration/switchover) we have a one-node RAC primary, and 2-node ExaCS in OCI.

I've setup the thread2 onlinelogs and standby logs in the RAC DB, but the primary db only has the 1 thread and I want to be able to switch _back_ over to the primary if we run into issues during testing.

Right now VALIDATE is WARNING about insufficient SRLs for thread 2 on the
*primary* (which makes sense as there isn't a thread 2 on a one-node RAC).

Any concerns here with this since there is no thread #2 on Primary in this scenario?

DGMGRL> validate database STANDBYDB <redacted>

  Database Role: Physical standby database

  Primary Database: PRIMARYDB <redacted>

  Ready for Switchover: Yes

  Ready for Failover: Yes (Primary Running)

  Managed by Clusterware:

    PRIMARY_DB : YES <redacted>

    STANDBY_DB: YES <redacted>

  Future Log File Groups Configuration:

    Thread # Online Redo Log Groups Standby Redo Log Groups Status

              (STANDBYDB) (PRIMARYDB)

    2         3                       0                       Insufficient
SRLs
  • Warning: standby redo logs not configured for thread 2 on PRIMARYDB*
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 18 2023 - 17:39:48 CEST

Original text of this message