Compare the Difference Between Similar Terms

Difference Between

Home / Technology / IT / Database / Difference Between ORACLE Dataguard and Real Application Cluster (RAC)

Difference Between ORACLE Dataguard and Real Application Cluster (RAC)

November 22, 2011 Posted by Admin

ORACLE Dataguard vs Real Application Cluster (RAC)
 

RAC and Data guard are very important topics in Oracle High Availability. Both of these architectures have many enhancements in Oracle 11gR2 than the 10g and 9i. ORACLE recommends having a combination of RAC and data guard to get the maximum benefit of data level and system level protection. 

What is RAC?

RAC stands for Real Application Cluster. This is a cluster of a database. That means single database utilizes resources of two or more servers. In other words, two or more instances are running on two or more servers (nodes) connecting to a same database. All of these instances have the read write access to the database. If one of these nodes of the systems goes down, the database never goes down. Users still have access to the database through the other nodes (automatically directs the connections coming to the failed server, to a running node). Cluster ware software and shared disks are used to keep the connection and communication between these multiple servers. RAC is a good solution for hardware failures, system failures, and software failures.

What is Data Guard?

Data guard is a configuration, which has at least one standby database of the primary database. The primary database can have one or more standby databases. This whole configuration is called the data guard. The standby databases can be running on the following modes, if the primary database has at least one of these database modes.

  1. Maximum protection mode
  2. Maximum availability mode
  3. Maximum performance mode

Both the primary and the standby databases together is called the data guard. There are two types of standby databases too. They are,

  1. Physical Standby Databases
  2. Logical Standby Databases

Both of these standby databases are always synchronizing with their primary databases. Standby databases can be on the same site or a separate site (recommended) of the primary database.  Therefore, data guards are good solutions for the SITE failures rather than instance failures, software failures and hardware failures.

 

What is the difference between Oracle RAC and Data Guard?

• RAC has one database and several instances associates with it, but data guard has several databases (one primary and others standby databases).

• RAC is the recommended solution for instance, software and hardware level failures. Data guard is the recommended solution for the SITE failures.

• Cluster ware software is used to keep the connection and communication between all nodes of the RAC, but in data guard, cluster ware software is not used. (if the data guard is not for a RAC)

• RAC must have a shared storage, which can be accessed from all the nodes of the system, but in data guard there is no shared storage, which is common for all the sites.

• RAC can have maximum of 100 nodes. Data guard can have maximum nine standby databases.

 

Related posts:

Difference Between Inner Join and Outer Join Difference Between ODBC and JDBC Difference Between Delete and Drop Difference Between Archival and Backup Difference Between Stored Procedure and Function

Filed Under: Database Tagged With: Data guard, Oracle Data guard, Oracle RAC, Oracle Real Application Cluster, RAC, Real Application Cluster

About the Author: Admin

Coming from Engineering cum Human Resource Development background, has over 10 years experience in content developmet and management.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Request Article

Featured Posts

Difference Between Coronavirus and Cold Symptoms

Difference Between Coronavirus and Cold Symptoms

Difference Between Coronavirus and SARS

Difference Between Coronavirus and SARS

Difference Between Coronavirus and Influenza

Difference Between Coronavirus and Influenza

Difference Between Coronavirus and Covid 19

Difference Between Coronavirus and Covid 19

You May Like

Difference Between Maroon and Burgundy

Difference Between Complex Salt and Double Salt

Difference Between Complex Salt and Double Salt

Difference Between Lithosphere and Crust

Difference Between Lithosphere and Crust

Difference Between Highlights and Streaks

Difference Between Nodule and Cyst

Difference Between Nodule and Cyst

Latest Posts

  • What is the Difference Between COPD and Lung Cancer
  • What is the Difference Between Silk and Cotton
  • What is the Difference Between Galactosemia and Lactose Intolerance
  • What is the Difference Between Glycosuria and Glucosuria
  • What is the Difference Between Menkes and Wilson’s Disease
  • What is the Difference Between Xerophthalmia and Keratomalacia
  • Home
  • Vacancies
  • About
  • Request Article
  • Contact Us

Copyright © 2010-2018 Difference Between. All rights reserved. Terms of Use and Privacy Policy: Legal.