alternative to dataguard and advanced queueing for 12.1 DB
edited Apr 21, 2020 10:32AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered ✓
Hello
I have been asked to find alternatives to Oracle Active data guard and advance queuing in below proposed setup.
Existing architecture
3 node custom application (VM's , no idea what is it)
3 node 12.1 RAC db
Existing issue : lot of clocking sessions and poor performance ( no access to the system to verify this)
proposed architecture
split the application VM's so first one connects to the existing DB and is mainly available for write operations
Second VM of application uses the second schema as read only in an active data guard environment( continuous sync with primary DB)
3rd application VM connects to a new R-W oracle DB and uses advance queuing to push changes to original R-W database.
0