Oracle Data Guard 26ai: Restricting Switchover and Failover Targets with PrimaryDatabaseCandidates
Oracle AI Database 26ai introduces a useful enhancement for Data Guard environments that contain multiple standby databases. The new PrimaryDatabaseCandidates Data Guard Broker property allows administrators to explicitly define which databases are eligible to assume the primary role during switchover or failover operations. This feature is particularly valuable in environments where some standby databases are dedicated to disaster recovery while others are used for reporting, testing, cloning, or other non-production purposes. *The PrimaryDatabaseCandidates property is available starting with Oracle Database 19.26 Release Update (RU). Test Environment For this test, I configured a Data Guard environment consisting of one primary database and two physical standby databases. DGMGRL> show configuration Configuration - DB2 Protection Mode: MaxPerformance Members: DB2 - Primary database dg1 - Physical standby database dg2 - Physical standby database...