1 Reply Latest reply: Nov 29, 2012 2:16 AM by moreajays RSS

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

    975824
      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
          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