()

What is Cluster and How can we find if a Database is running on Cluster

Oracle Real Application Cluster provides its users to run a single database into multiple servers. These multiple servers act as a single system. It provides fast recovery at the time of any site failure. To avoid the outage and provide High Availability, redundancy for its users in case of instances/databases crash. Hence Users connected to these databases will be sharing shared storage. The benefit of having multiple instances access a single database is just to avoid the server from failure for a single point. Compare to single instances, RAC is a bit costlier. As it’s having a scalable environment to support Critical Applications of any Organization. If you’re planning to deploy RAC then without code changes also it can work.

The below-mentioned query we can use to check if the database is running on Single Instance or RAC ( Real Application Cluster).


To check if the Database is configured with Cluster. Click here for sample output.

SET LINES 200
SET PAGES 200
COL NAME FORMAT A19
COL VALUE FORMAT A19
SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME='cluster_database';
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$

If the result is coming as ‘TRUE‘ then the Database has enabled with cluster services running as one or more than one Instance and in-case if the result is coming out as ‘FALSE‘ then it’s a standalone Instance Database.


To check active DB status with RAC”s instance name along with the connected server. Click here for sample output.

SET LINES 200
SET PAGES 200
COL INST_NAME FORMAT A40
SELECT * FROM GV$ACTIVE_INSTANCES;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$

This document is only for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.


Hope so you like this article
!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the latest update. Click here to know more about our pursuit.

 

Loading

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Suryapriya Majumdar

Hello and welcome to DBsGuru,I'm Suryapriya Majumdar and currently working as an Oracle DBA in an MNC for the past 3 years. These 3 years gave me gather knowledge in Oracle Database for various OS like Linux, HPUX, AIX and also in windows servers.I've good hands-on experience in the mentioned topics- table, schema, and Database refresh using the data-pump utility, backup, and recovery using RMAN, tablespace management, Database installation, Database Patching and upgrade, Performance tuning, database cloning, GG replication and lag issues, storage management in both ASM and file system.Every day there is a new learning path waiting for all of us to enhance our knowledge. So kudos to learning.Thanks for the visits!Share Learn Grow!

2 thoughts on “What is Cluster and How can we find if a Database is running on Cluster

    1. Hi Tejaswini,
      Thanks for your feedback.
      Kindly visit our website for regular updates and do share your valuable feedbacks with us.
      Thanks,
      Team DBsGuru.

Comments are closed.