Database Software

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!

Replication for Failover

381666Jan 22 2004 — edited Jan 27 2004

Hi all,

We have setup 2 databases in multimaster configuration for redundancy. All our servers are connected to both the databases but at a time they are just writing to one database (called primary). If the primary database goes down then manually all the servers are switched to the secondary database. Now if the primary database comes back up, we want to ignore all its broken transactions and we want it to synch up with the secondary. Can it be done?

I think, master-slave configuration suits us better but we would like to switch the role of who is the master dynamically.

Any help would be greatly appreciated.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2004

Added on Jan 22 2004

#database-key-features, #replication

8 comments

431 views