Dataguard Sanity Check Please - One-Node Primary to RAC Standby (19.17)
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 InsufficientSRLs
- Warning: standby redo logs not configured for thread 2 on PRIMARYDB*
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 18 2023 - 17:39:48 CEST