Hello Team,
good morning.
Problem description:
to implement replication of downstream db using data guard on a standby db. The Golden gate changes should replicate to the standby db.
Kindly have a look at our current architecture:
source DB ---> downstream replication of golden gate ---> datawarehouse server (extract and replicat run here. this server will be used for reporting)--->redolog shipping --> active dataguard.
Kindly advise on the steps/technique to rpelicate the trail files to standby db(active DG site) so that in case Datawarehouse server is unavailable, it will be easy for us to fail over to DR site for golden gate.
Note:
datawarehouse server and DG site have same SID but different DB_UNIQUE_NAME.
Thanks,
Joe