Hello,
After testing switchover I've met an error for one of the standby databases:
ORA-16795: the standby database needs to be re-created
There are 2 standby databases for primary:
Primary: host1@oracle1
Logical standby: oracledg@host2
Snapshot standby: orasnap@host3
So, I performed switchover of the oracle1 to oracledg:
DGMGRL> switchover to oracledg;
Performing switchover NOW, please wait...
Switchover succeeded, new primary is "oracledg"
After I found that there is an error in my network configuration. Oracledg and orasnap haven't access to each other. I've fixed it, but still there were the errors:
DGMGRL> show configuration
Configuration - DGConfig1
Protection Mode: MaxPerformance
Databases:
oracledg - Primary database
Error: ORA-16778: redo transport error for one or more databases
oracle1 - Logical standby database
orasnap - Snapshot standby database
Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
Alert.log of orasnap contains the following entries:
Wed Jan 18 20:01:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:02:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:03:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:04:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:05:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:06:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:07:23 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Wed Jan 18 20:10:35 2017
Standby database ID mismatch [0xca1b9543:0x23a82f1e] (3390805315:598224670)
Then I've switched back oracle1 as primary. The operation was successful but now I have the error ORA-16795 for orasnap.
I assume that this is a normal behavior because the switchover was done on oracledg and orasnap can't recognize this database.
But I want to now if it is possible to configure this environment to perform switchovers without any errors?
Updated RDBMS version 11.2.0.4 for each database.