Replication to Multiple Sites through Oracle 11g Active Dataguard
Hi,
I am planning to deploy two standby sites(R1,R2) with read only mode(Active Dataguard) against a primary site(P1), can I configure the architecture where P1 replicates data to R1(standby) and R1 further replicates redo to R2(another standby) so to avoid the workload of replicating redo to two sites, I guess this is somewhat we call cascading site. Please note that standby sites will also be used to fulfill the reporting needs along with data protection and disaster recovery.
Database Version: Oracle 11.1.0.4 (64-bits)
OS Version: Oracle Enterprise Linux 6.4 (64-bits)
I will really appreciate if you can provide your feedback in this regard.