Today I got one challenging task requirement :-
We have two Geo sites and following environment
OS Platform:- RHEL5.5 64bit
Database Version:- 22.214.171.124
CLUSTER:-2-Node RAC Database
DATA SYNC: RAC to RAC Dataguard
Site-1 and Site-2 Database Servers is accessible via separate public network2/vlan
So We want to do Communication of Data Guard Sync via separate public network2/vlan
We have available the separate vlan for this configuration
We have refered the RAC FAQ.
Can I have multiple public networks accessing my Oracle RAC?
Yes, you can have multiple networks however with Oracle RAC 10g and Oracle RAC 11g, the cluster can only manage a single public network with a VIP and the database can only load balance across a single network. FAN will only work on the public network with the Oracle VIPs.
Oracle RAC 11g Release 2 supports multiple public networks. You must set the new init.ora parameter LISTENER_NETWORKS so users are load balanced across their network. Services are tied to networks so users connecting with network 1 will use a different service than network 2. Each network will have its own VIP.
We are referring Meta Link [ID 1063571.1]
How to Configure A Second Listener on a Separate Network in 11.2 Grid Infrastructure
We go through the R&D via referring the Google
We are doing test the above scenario on local environment 🙂