How to integrate Oracle Data Guard in an Oracle Streams environment
We are working in One Hub & several spokes environment with bi-directional streams replication ( rules are set at table level ) . Our Oracle version is 10 Release 2.
Hub site has a dedicated capture , propagate and apply process for each spoke site .
Each spoke site has a capture, propagate and apply process.
We want to install Oracle Data Guard to improve Availibility on one spoke site ( let's say S1 for example )
Our goal is to maintain S1 standby database as syncronised as possible as S1 Primary database and of course to integrate with the existing streams processes .
So in case of switchover or failover , capture