1 Reply Latest reply: Sep 28, 2012 8:07 AM by Balazs Papp RSS

    Is it possible to install Oracle RAC without shared storage

    916361
      Dear All,

      I would like to seek for your advice.

      I got two different servers. We call it node 1 and node 2. And two different instances name.

      Node 1 -> instance name as "ORCL1"
      Node 2 -> instance name as "ORCL2"

      For the system we need Oracle RAC active-active cluster mode. Our objective is to have 2 replicated databases, in other words we need 2 instances of the same database automatically replicated for 100% up time to the Application server. We have 2 separate database machines and 2 application server machines. We need our application server to connect to any of the databases at any point of time and be having a consistent data on both database machines. We only need the database to be in a cluster mode, we won't need the OS to be in a cluster. There is no shared storage in this case.

      Can this be done? Please advice.
        • 1. Re: Is it possible to install Oracle RAC without shared storage
          Balazs Papp
          you should review RAC concepts, and the meaning of instance and database
          For the system we need Oracle RAC active-active cluster mode.
          RAC = single database with multiple instances all accessing the same shared storage, no replication involved
          Our objective is to have 2 replicated databases, in other words we need 2 instances of the same database automatically replicated for 100% up time to the Application server.
          what you describe here is = multiple databases with multiple instances, replicated between each other
          We have 2 separate database machines and 2 application server machines. We need our application server to connect to any of the databases at any point of time and be having a consistent data on both database machines. We only need the database to be in a cluster mode, we won't need the OS to be in a cluster. There is no shared storage in this case.
          no shared storage = no RAC
          you will have two seperate databases synchronizing continuously
          you can use for example Streams / Advanced Replication (with multi-master configuration)

          if you dont insist on an active-active configuration, you can also use Data Guard for building a standby database