Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Active/Active dataguard setup in Oracle 10g

583730Aug 6 2009 — edited Aug 6 2009
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2009
Added on Aug 6 2009
8 comments
702 views