Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Oracle RAC
open-in-new
<h2 id="functionality">Functionality</h2> <p>Oracle RAC allows multiple computers to run Oracle <a href="/facts/Relational_database_management_system/pEKGmJLy">RDBMS</a> software simultaneously while accessing a single <a href="/facts/Database/VYcpkevb">database</a>, thus providing <a href="/facts/Computer_cluster/mT7S1BcX">clustering</a>. </p><p>In a non-RAC Oracle database, a single <a href="/facts/Instance_(computer_science)/5zPBGdX1">instance</a> accesses a single database. The <i>database</i> consists of a collection of <a href="/facts/Data_file/S9oFvf2z">data files</a>, control files, and <a href="/facts/Redo_log/3cIJH6Vu">redo logs</a> located on <a href="/facts/Disk_storage/hnsXRb5X">disk</a>. The <i>instance</i> comprises the collection of Oracle-related memory and background processes that run on a computer system. </p><p>In an Oracle RAC environment, 2 or more instances concurrently access a single database. This allows an application or user to connect to either computer and have access to a single coordinated set of data. The instances are connected with each other through an "Interconnect" which enables all the instances to be in sync in accessing the data. </p> <h2 id="aims">Aims</h2> <p>The main aim of Oracle RAC is to implement a clustered database to provide performance, <a href="/facts/Database_scalability/48GTKykX">scalability</a> and resilience & high availability of data at instance level. </p> <h2 id="implementation">Implementation</h2> <p>Oracle RAC depends on the <a href="/facts/Infrastructure/QJvbsSpl">infrastructure</a> component <a href="/facts/Oracle_Clusterware/H7dxQkhP">Oracle Clusterware</a> to coordinate multiple servers and their sharing of data storage.<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a> The FAN (Fast Application Notification) technology detects down-states.<a class="footnote-ref" id="fnref:4" href="#fn:4"><sup>4</sup></a> RAC administrators can use the srvctl tool to manage RAC configurations,<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a> </p> <h3>Cache Fusion</h3> <p>Prior to Oracle 9, network-clustered Oracle databases used a storage device as the data-transfer medium (meaning that one node would write a data block to disk and another node would read that data from the same disk), which had the inherent disadvantage of lackluster performance. Oracle 9i addressed this issue: RAC uses a dedicated network connection for communications internal to the cluster. </p><p>Since all computers/instances in a RAC access the same database, the overall system must guarantee the coordination of data changes on different computers such that whenever a computer queries data, it receives the current version — even if another computer recently modified that data. Oracle RAC refers to this functionality as <i>Cache Fusion</i>. Cache Fusion involves the ability of Oracle RAC to "fuse" the in-memory data <a href="/facts/Database_cache/9pakVo8M">cached</a> physically separately on each computer into a single, global cache. </p> <h3>Networking</h3> <p>The Oracle Grid Naming Service (GNS) handles <a href="/facts/Name_resolution_(computer_systems)/VSGGb0cq">name resolution</a> in the cluster registry.<a class="footnote-ref" id="fnref:6" href="#fn:6"><sup>6</sup></a> </p> <h3>Diagnostics</h3> <p>The Trace File Analyzer (TFA) aids in collecting RAC diagnostic data.<a class="footnote-ref" id="fnref:7" href="#fn:7"><sup>7</sup></a> </p> <h2 id="versions">Versions</h2> <ul><li>Oracle Real Application Clusters 12c Release 1 Enterprise Edition.<a class="footnote-ref" id="fnref:8" href="#fn:8"><sup>8</sup></a></li> <li>Oracle Real Application Clusters One Node (RAC One Node) applies RAC to single-node installations running Oracle Database 11g Release 2 Enterprise Edition.<a class="footnote-ref" id="fnref:9" href="#fn:9"><sup>9</sup></a></li></ul> <h2 id="evolution">Evolution</h2> <p>Relative to the single-instance Oracle database, Oracle RAC adds additional complexity. While <a href="/facts/Database_automation/86tgW5Nf">database automation</a> makes sense for single-instance databases, it becomes even more necessary for clustered databases because of their increased complexity. </p><p>Oracle Real Application Clusters (RAC), introduced with Oracle 9i in 2001, supersedes the Oracle Parallel Server (OPS) database option. Whereas Oracle9i required an external clusterware (known as vendor clusterware like <a href="/facts/TruCluster/bP8uvb9Q">TruCluster</a> <a href="/facts/Veritas_Cluster_Server/T331XIsI">Veritas Cluster Server</a> or <a href="/facts/Sun_Cluster/wo4xoMrE">Sun Cluster</a>) for most of the Unix flavors (except for Linux and Windows where Oracle provided free clusterware called <i>Cluster Ready Services</i> or <i>CRS</i>), as of Oracle 10g, Oracle's clusterware product was available for all operating systems. With the release of Oracle Database 10g Release 2 (10.2), Cluster Ready Services was renamed to Oracle Clusterware. When using Oracle 10g or higher, Oracle Clusterware is the only clusterware that you need for most platforms on which Oracle RAC operates (except for Tru cluster, in which case you need vendor clusterware). You can still use clusterware from other vendors, if the clusterware is certified for Oracle RAC. </p><p>In RAC, the write-transaction must take ownership of the relevant area of the database: typically, this involves a request across the cluster interconnection (local IP network) to transfer the <a href="/facts/Block_(data_storage)/S3vT7c6N">data-block</a> ownership from another node to the one wishing to do the write. This takes a relatively long time (from a few to tens of <a href="/facts/Millisecond/xHCyv235">milliseconds</a>) compared to single database-node using in-memory operations. For multiple types of applications, the time spent coordinating block access across systems is low relative to the multiple operations on the system, and RAC will <a href="/facts/Scalability/jh7JomPa">scale</a> comparably to a single system. Moreover, high read-transactional databases (such as <a href="/facts/Data_warehousing/we5rblq9">data-warehousing</a> applications) work very well under RAC, as no need for ownership-transfer exists. (Oracle 11g has made a number of enhancements in this area and performs a lot better than earlier versions for read-only workloads.) </p><p>The overhead on the resource mastering (or ownership-transfer) is minimal for fewer than three nodes, as the request for any resource in the cluster can be obtained in a maximum of three hops (owner-master-requestor). This makes Oracle RAC horizontally scalable with a number of nodes. Application vendors (such as <a href="/facts/SAP_AG/pVwH8lks">SAP</a>) use Oracle RAC to demonstrate the scalability of their application. Most of the biggest <a href="/facts/Online_transaction_processing/zTIGyx1t">OLTP</a> benchmarks are on Oracle RAC. Oracle RAC 11g supports up to 100 nodes.<a class="footnote-ref" id="fnref:10" href="#fn:10"><sup>10</sup></a> </p><p>For some[<i>which?</i>] applications, RAC may require careful application partitioning to enhance <a href="/facts/Performance/LoPW1hxp">performance</a>. An application that scales <a href="/facts/Linearly/fChtg3KC">linearly</a> on an <a href="/facts/Symmetric_multiprocessing/T9CahUsN">SMP</a> machine may scale linearly under RAC. However, if the application cannot scale linearly on SMP, it will not scale when ported to RAC. In short, the application <a href="/facts/Scalability/jh7JomPa">scalability</a> is based on how well the application scales in a single <a href="/facts/Instance_(computer_science)/5zPBGdX1">instance</a>. </p> <h2 id="competitive-context">Competitive context</h2> <p><a href="/facts/Shared_nothing_architecture/EXvXTQ6E">Shared-nothing</a> and shared-everything architectures each have advantages over the other. DBMS vendors and industry analysts regularly debate the matter; for example, <a href="/facts/Microsoft/nGIDDXdx">Microsoft</a> touts a comparison of its <a href="/facts/Microsoft_SQL_Server/eCdt2JBL">SQL Server 2005</a> with Oracle 10g RAC.<a class="footnote-ref" id="fnref:11" href="#fn:11"><sup>11</sup></a> </p><p>Oracle Corporation offered a Shared Nothing architecture RDBMS with the advent of the IBM SP and SP2 with the release of 7.x MPP editions, in which virtual shared drives (VSD) were used to create a Shared Everything implementation on a Shared Nothing architecture. </p> <h3>Shared-Everything</h3> <p><i>Shared-everything</i> architectures share both data on disk and data in memory between nodes in the cluster. This is in contrast to "shared-nothing" architectures that share none of them. </p><p>Some commercially available databases offer a "shared-everything" architecture. <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a> for <a href="/facts/Z%2fOS/amLCAlgV">z/OS</a> (the <a href="/facts/IBM/QszA7nwd">IBM</a> mainframe operating-system) has provided a high-performance data-sharing option since the mid-1990s when IBM released its mainframe hardware and software-clustering infrastructure. In late 2009, IBM announced DB2 pureScale, a shared-disk clustering scheme for DB2 9.8 on AIX that mimics the parallel <a href="/facts/Sysplex/lTI1aQ9R">sysplex</a> implementation behind Db2 data sharing on the mainframe. </p><p>In February 2008, <a href="/facts/Sybase/2U3d6RUt">Sybase</a> released its <a href="/facts/Adaptive_Server_Enterprise/eocfB6I6">Adaptive Server Enterprise</a>, Cluster Edition. It resembles Oracle RAC in its shared-everything design.<a class="footnote-ref" id="fnref:12" href="#fn:12"><sup>12</sup></a> </p><p>Although technically not shared-everything, Sybase also provides a column-based relational database focused on analytic and datawarehouse applications called <a href="/facts/Sybase_IQ/XLsYXDac">Sybase IQ</a> that can be configured to run in a shared disk mode. </p><p>Cloud Native Databases, such as <a href="/facts/Amazon_Aurora/9Y5Gs369">Amazon Aurora</a> and POLARDB of <a href="/facts/Alibaba_Cloud/bjsIg9aG">Alibaba Cloud</a>, are implemented with "shared-everything" architecture on top of cloud-based distributed file system.<a class="footnote-ref" id="fnref:13" href="#fn:13"><sup>13</sup></a><a class="footnote-ref" id="fnref:14" href="#fn:14"><sup>14</sup></a> </p> <h3>Shared-nothing</h3> <p><a href="/facts/Shared_nothing_architecture/EXvXTQ6E"><i>Shared-nothing</i></a> architectures share neither the data on disk nor the data in memory between nodes in the cluster. This is in contrast to "shared-everything" architectures, which share both. </p><p>Competitive products offering shared-nothing architectures include: </p> <ul><li><a href="/facts/EnterpriseDB/1C5h543u">EDB Postgres Distributed</a> available for PostgreSQL, EDB Postgres Extended Server and EDB Postgres Advanced Server (which provides native compatibility with Oracle)</li> <li><a href="/facts/MySQL_Cluster/BwXDHev6">MySQL Cluster</a> (Oracle Corporation has owned MySQL since 2009)<a class="footnote-ref" id="fnref:15" href="#fn:15"><sup>15</sup></a></li> <li><a href="/facts/ScaleBase/h7KSFJbj">ScaleBase</a><a class="footnote-ref" id="fnref:16" href="#fn:16"><sup>16</sup></a></li> <li><a href="/facts/Clustrix/Uf0LwIJT">Clustrix</a></li> <li>HP <a href="/facts/NonStop_(server_computers)/VuLrDEUQ">NonStop</a></li> <li><a href="/facts/IBM_InfoSphere/gqFkXsFk">IBM InfoSphere</a> Warehouse editions that include the Database Partitioning Feature (formerly known as DB2 Extended Enterprise Edition)</li> <li><a href="/facts/MarkLogic/m8zDvtIB">MarkLogic</a></li> <li><a href="/facts/Greenplum/CNIAxda2">Greenplum</a></li> <li><a href="/facts/Oracle_NoSQL_Database/p9gLC1V7">Oracle NoSQL Database</a></li> <li><a href="/facts/Paraccel/PaU6CN0Q">Paraccel</a></li> <li><a href="/facts/Netezza/jVU2WM4f">Netezza</a> (aka. Netezza Performance Server)</li> <li><a href="/facts/Teradata/sarnALYT">Teradata</a></li> <li><a href="/facts/Vertica/SGJBWtrr">Vertica</a></li> <li><a href="/facts/Apache_Cassandra/WCJyV4rA">Apache Cassandra</a>, wide column store NoSQL database.</li> <li><a href="/facts/Apache_HBase/D4XU1dqK">Apache HBase</a></li> <li><a href="/facts/MongoDB/9myQKGoY">MongoDB</a>, document-oriented database.</li> <li><a href="/facts/Couchbase_Server/zJA7EJMQ">Couchbase Server</a></li> <li><a href="/facts/Riak/zhRLQHh8">Riak</a></li> <li><a href="/facts/SAP_HANA/QUmJmqtj">SAP HANA</a></li> <li><a href="/facts/CUBRID/CG12Vv3p">CUBRID</a></li></ul> <h2 id="see-also">See also</h2> <ul><li><a href="/facts/Oracle_Data_Guard/JP47j0pW">Oracle Data Guard</a></li> <li><a href="/facts/Oracle_Active_Data_Guard/JP47j0pW">Oracle Active Data Guard</a></li> <li><a href="/facts/Database_scalability/48GTKykX">Database scalability</a></li></ul> <h2 id="external-links">External links</h2> <ul><li><a href="http://www.sysdba.de/oracle-dokumentation/11.1/rac.111/b28254/toc.htm">Oracle RAC Documentation</a></li> <li><a href="http://www.oracle.com/us/products/database/options/real-application-clusters/overview/index.html">Oracle Real Application Clusters</a> (official website from <a href="/facts/Oracle_Corporation/0z14FygH">Oracle Corporation</a>)</li> <li><a href="http://www.oracle.com/technetwork/articles/oem/haskins-rac-project-guide-099429.html">A Step-By-Step Project Guide for Implementing Oracle RAC</a></li> <li><a href="http://mvdirona.com/jrh/talksAndPapers/OracleRAC.pdf">Oracle Real Application Clusters and Industry Trends in Cluster Parallelism and Availability</a></li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>Options and Packs <a href="http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#CIHGHJBE" target="_blank">http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#CIHGHJBE</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>Oracle Database Editions <a href="http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm" target="_blank">http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>Introduction to Oracle Real Application Clusters <a href="http://download.oracle.com/docs/cd/B28359_01/rac.111/b28254/admcon.htm#i1058057" target="_blank">http://download.oracle.com/docs/cd/B28359_01/rac.111/b28254/admcon.htm#i1058057</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>Mensah, Kuassi (2006). Oracle database programming using Java and Web services. Digital Press. p. 400; 1087. ISBN 978-1-55558-329-3. Retrieved 2011-09-11. The Fast Application Notification (FAN) mechanism [...] allows the rapid detection of "Instance DOWN" or "Node DOWN events [...] <a href="978-1-55558-329-3" target="_blank">978-1-55558-329-3</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> <li id="fn:5"><p>Stoever, Edward (2006). Personal Oracle RAC Clusters: Create Oracle 10g Grid Computing At Home. Oracle In-focus Series. Rampant TechPress. p. 119. ISBN 9780976157380. Retrieved 2013-05-30. An RAC database configuration requires extra tools to manage the software and its instances. One such tool is srvctl, used to startup, shutdown and check the status [of] a RAC database. <a href="9780976157380" target="_blank">9780976157380</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li> <li id="fn:6"><p>Prusinski, Ben; Hussain, Syed Jaffer (23 May 2011). Oracle 11g R1/R2 Real Application Clusters Essentials. Birmingham: Packt Publishing Ltd (published 2011). ISBN 9781849682671. Retrieved 2018-03-23. Oracle 11g R2 RAC introduced several new clusterware background processes. [...] The Oracle Grid Naming Service (GNS) functions as a gateway between the cluster mDNS and external DNS servers. The GNS process performs the name resolution within Oracle Cluster registry architecture for Oracle 11g RAC. <a href="9781849682671" target="_blank">9781849682671</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></p></li> <li id="fn:7"><p>Farooq, Tariq; Kim, Charles; Vengurlekar, Nitin; Avantsa, Sridhar; Harrison, Guy; Hussain, Syed Jaffar (12 June 2015). "Troubleshooting and Tuning RAC". Oracle Exadata Expert's Handbook. Addison-Wesley Professional (published 2015). ISBN 9780133780987. Retrieved 2017-06-29. Released with v11.2.0.4, the Trace File Analyzer (TFA) Collector utility is the new all-encompassing utility that simplifies collection of RAC diagnostic information. <a href="9780133780987" target="_blank">9780133780987</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></p></li> <li id="fn:8"><p>"Oracle 12c RAC: New Features". Find White Papers. 2015-07-24. Retrieved 2015-07-24. From among the 500+ New Features released with Oracle 12c Database, a number of very useful features are Oracle RAC specific. View the top 12c RAC New Features including Oracle ASM Flex, ASM Disk Scrubbing, faster Disk Resync Checkpoint, higher Resync Power limit and more. <a href="http://www.vitalsofttech.com/oracle-12c-rac/" target="_blank">http://www.vitalsofttech.com/oracle-12c-rac/</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></p></li> <li id="fn:9"><p>"Oracle Real Application Clusters One Node: Better Virtualization for Databases". Find White Papers. 2009-12-09. Retrieved 2010-04-19. Oracle RAC One Node provides: . Always on single-instance database services . Better consolidation for database servers . Enhanced server virtualization . [,,,] should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption. [...] Oracle Real Application Clusters (RAC) One Node is a new option to Oracle Database 11g Release 2 Enterprise Edition. It provides enhanced high availability for singleinstance databases, <a href="http://www.findwhitepapers.com/content7516/" target="_blank">http://www.findwhitepapers.com/content7516/</a> <a href="#fnref:9" class="footnote-back-ref">↩</a></p></li> <li id="fn:10"><p>"clustering" (PDF). Oracle.com. Retrieved 2012-11-07. <a href="http://www.oracle.com/technology/products/database/clustering/pdf/ds_rac11g.pdf" target="_blank">http://www.oracle.com/technology/products/database/clustering/pdf/ds_rac11g.pdf</a> <a href="#fnref:10" class="footnote-back-ref">↩</a></p></li> <li id="fn:11"><p>Thomas, Bryan (2006-05-30). "Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies" (PDF). Microsoft. Retrieved 2007-09-09. <a href="http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/OracleRAC.pdf" target="_blank">http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/OracleRAC.pdf</a> <a href="#fnref:11" class="footnote-back-ref">↩</a></p></li> <li id="fn:12"><p>"Sybase.com". Sybase.com. Retrieved 2012-11-07. <a href="http://www.sybase.com/detail?id=1056349" target="_blank">http://www.sybase.com/detail?id=1056349</a> <a href="#fnref:12" class="footnote-back-ref">↩</a></p></li> <li id="fn:13"><p>"Amazon Aurora storage and reliability - Amazon Aurora". <a href="https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html" target="_blank">https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html</a> <a href="#fnref:13" class="footnote-back-ref">↩</a></p></li> <li id="fn:14"><p>"PolarFS: An Ultra-low Latency and Failure Resilient Distributed File System for Shared Storage Cloud Database". ACM DIGITAL LIBRARY. <a href="https://dl.acm.org/citation.cfm?id=3275552" target="_blank">https://dl.acm.org/citation.cfm?id=3275552</a> <a href="#fnref:14" class="footnote-back-ref">↩</a></p></li> <li id="fn:15"><p>"Oracle buys Finnish open-source developer". InfoWorld. October 7, 2005. "Oracle Buys SUN; MySQL is Forked". Linux Magazine. April 20, 2009. <a href="http://www.infoworld.com/d/data-management/oracle-buys-finnish-open-source-developer-519" target="_blank">http://www.infoworld.com/d/data-management/oracle-buys-finnish-open-source-developer-519</a> <a href="#fnref:15" class="footnote-back-ref">↩</a></p></li> <li id="fn:16"><p>"Database Load Balancing | MySQL High Availability | Scalebase". www.scalebase.com. Archived from the original on 2012-06-29. <a href="https://web.archive.org/web/20120629222757/http://www.scalebase.com/products/product-architecture" target="_blank">https://web.archive.org/web/20120629222757/http://www.scalebase.com/products/product-architecture</a> <a href="#fnref:16" class="footnote-back-ref">↩</a></p></li> </ol>