5 Replies Latest reply: Jun 23, 2013 6:33 AM by Arun Sankar RSS

    Dataguard vs RAC


      Am basically a PeopleSoft DBA, I would like to know the exact differences between RAC and dataguard, both of its pros and cons.

      Even I know the basic differences between them, I would like to hear more from gurus.

      Also I would like to create dataguard in my laptop using VM. Where can I get the easy steps for dummies?

      Thanks in Advance,
      Sarathy Kandaswamy

      Edited by: 1010360 on Jun 6, 2013 7:38 PM
        • 1. Re: Dataguard vs RAC
          Hemant K Chitale
          In Dataguard, the Standby database is a physically distinct database from the primary database, running on a different server and storage. Therefore, it protects you from site failure -- server and storage failure where the primary is running.
          RAC, normally, has all the nodes in the same site accessing a single database on shared storage. If the storage or site goes down, the database becomes unavailable.

          Hemant K Chitale
          • 2. Re: Dataguard vs RAC
            Hi Hemant,

            So, We can say that the RAC is to increase the performance (high-availablity) and Dataguard is for fail-over?

            Sarathy Kandaswamy
            • 3. Re: Dataguard vs RAC
              Hemant K Chitale
              RAC is for
              a) Protection from node failure (database instance keeps running and is available on other nodes in the cluster)
              b) horizontal scaling (distributing load across multiple nodes in the cluster)

              DataGuard is for
              a) Protection from site failure (server and/or storage failure, data centre failure)

              Thus, your Primary site could be running RAC for the RAC advantages but be protected from site failure with DataGuard running at another site (some X kilometres away)

              Hemant K Chitale
              • 4. Re: Dataguard vs RAC
                Ed Rudans

                Agree with Hemant about benefits of RAC, can only add that drawbacks are that if you place badly written application on the RAC the performance may get worst. So the application should be designed for RAC. Its good idea to check other users experience of you application running on RAC (I dont have experience with PeopleSoft)


                Also pls check articles on oracle-base, they are very good written and very helpful






                • 5. Re: Dataguard vs RAC
                  Arun Sankar

                  Dataguard is guarding the data from disasters by placing it in different server/storage far from the production.

                  RAC is the cluster solution form oracle for which is used to connect a database from different nodes (load balancing and scale up with out down time)


                  Arun Sankar