Error: ORA-16416: No viable switchover targets available
edited Jul 3, 2020 4:17PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Oracle 19.0.0.0
OEL 7
AWS -EC2
I'm getting an error while doing a switchover. Thanks in advance for any valuable inputs.
[oracle@ip-172-31-xx-xx ~]$ dgmgrl sys/xxxx@newcdbDGMGRL for Linux: Release 19.0.0.0.0 - Production on Wed Jul 1 16:26:02 2020Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.Welcome to DGMGRL, type "help" for information.Connected to "NEWCDB"Connected as SYSDBA.DGMGRL> show configuration;Configuration - msdba_dg_config Protection Mode: MaxPerformance Members: newcdb - Primary database newcdb_s - Physical standby databaseFast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 53 seconds ago)DGMGRL> validate database verbose newcdb_s; Database Role: Physical standby database Primary Database: newcdb Ready for Switchover: Yes Ready for Failover: Yes (Primary Running) Flashback Database Status: newcdb : On newcdb_s: Off Capacity Information: Database Instances Threads newcdb 1 1
0