This discussion is archived
1 Reply Latest reply: Nov 29, 2012 12:16 AM by moreajays RSS

replication between 4 databases (11g R2 standard edition , windows 7/xp)

975824 Newbie
Currently Being Moderated
We want to replicate the data between the databases.We have 4 databases in a network.If there will be any change in database 1,eg updation in any table,it should automatically replicalte on other 3 databases.or user will change something in database 2 ,it should replicate on other 3 databases and vice versa.All 4 databases have same schema and same configuration.

please suggest me the tool or any method for replication .
  • 1. Re: replication between 4 databases (11g R2 standard edition , windows 7/xp)
    moreajays Pro
    Currently Being Moderated
    HI,

    Your requirement is very complex being each & every DB holding similar schema/objects & should be updated with each other.

    All replication methods of oracle will fail to keep consistent image across all 4 db's

    best approach that you can have is to create 4 Node Oracle RAC which will maintain same image of schema on all nodes

    RAC will hold 4 DB instances on single shared storage

    Thanks,
    Ajay More
    http://moreajays.blogspot.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points