Skip to Main Content
  • Questions
  • Difference between RAC and RAC one node

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Rajesh.

Asked: September 30, 2020 - 9:14 am UTC

Last updated: October 07, 2020 - 2:19 am UTC

Version: 19C

Viewed 10K+ times! This question is

You Asked

Hello Tom,

Can you please help me to know the difference between RAC and RAC one node.

Thanks,
Rajesh

and Connor said...

Lets work our way up

1 server, no RAC
============
Whilst that server is running, all is fine. If that server crashes, or you need to do maintenance....your application is down.

2 servers, no RAC but has clustering
===========================
Both servers are running, but only 1 server is doing any work. The other sits idle. If the main server crashes, the other one starts a database, transfers over facilities and resumes workload. Typically this could be 5-10mins, or longer if any manual steps are needed.

2 servers, RAC One Node
===================
Both servers are running, but only 1 server is doing any work. The other sits idle however, because it is running RAC, it already "knows" about all of the facilities on the other node. If the main server crashes, the other node can immediately take over facilities and workload. Typically this could be 30 seconds or even less, and applications can be insulated from this, ie, they just see a small delay rather than an error

2 (or more) servers, Full RAC
=====================
*ALL* nodes can be processing queries/DML at the same time. If a node dies, the other node(s) sort out any mess (roll back or reply transactions) so generally users won't even notice that there is/was an service interruption.




Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, October 04, 2020 - 8:04 pm UTC

what is difference between RAC and data guard?
does RAC is high availability and data guard is disaster recovery?
or they both need to be used for HADR solution ?

Thanks


Thanks that helps

A reader, October 06, 2020 - 8:44 pm UTC


Connor McDonald
October 07, 2020 - 2:19 am UTC

Glad we could help

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database