Streams replication between 2 Data Guard Configured databases.
There is a requirement to setup streams replication between 2 Data Guard (physical standby) databases located at 2 different physical locations. I have two questions on this configuration.
1) What will be the behaviour of Oracle Streams after failover on either source or target database?
2) After a site loss how will two DG databases come in sync again once the lost site is recovered?
Any help much appreciated.
Regards,
UserHA