Active/Active dataguard setup in Oracle 10g
583730Aug 6 2009 — edited Aug 6 2009Hi All,
I am kinda eager to know is there any functionality in Oracle 10g Data Guard where i can implement the following?
1. Both Primary as well as standby should always be in sync with each other.
2. Both the Primary as well as standby should be open in read write mode with complete active active sync.
So if we perform transactions on any of the database it should be able to accept all transactions on any database and both the databases still remain in sync.
I need such configuration to ensure if my Primary database becomes unavailable, standby is ready to accept all transactions without switch over or fail over operations..
I understand this can be accomplished by configuring broker for automatic failover.. But if the failover is performed i need to reconfigure my old primary whole again to new Standby and do switch over to this new standby to act as primary.
Oracle Version which we are using is 10.2.0.1
Any suggestion, comments are most welcome
Thanks - Em