Oracle Database Administrator Interview Questions on RAC

Oracle RAC (Voting Disk ) FAQ’s


1.What is Voting Disk?


Voting Disk is a file that maintains node membership details.
All members in the Cluster read and write Heartbeat Information in Voting Disk.


2. What Information is stored in Voting Disk?


Voting disks contain static and dynamic data.
Static data : Info about nodes in the cluster
Dynamic data : Disk heartbeat logging
It maintains and consists of important details about the cluster nodes membership, such as
– which node is part of the cluster,
– which node is joining the cluster, and
– which node is leaving the cluster.


3. Why do we need Voting Disk?


CSSD processes (Cluster Services Synchronization Daemon) monitor the health of  RAC nodes employing two distinct heart 


beats: Network heart beat and Disk heart beat. Healthy nodes will have continuous network and disk heartbeats exchanged 


between the  nodes. Break in heart beat indicates a possible error scenario. There are few different scenarios possible 


with missing heart beats:
1. Network heart beat is successful, but disk heart beat is missed.
2. Disk heart beat is successful, but network heart beat is missed.
3. Both heart beats failed.
In addition, with numerous nodes, there are other possible scenarios too. Few possible scenarios:
1. Nodes have split in to N sets of nodes, communicating within the set, but not with members in other set.
2. Just one node is unhealthy.
Nodes with quorum will maintain active membership of the cluster and other node(s) will be fenced/rebooted.


4.Why do we have odd number of voting disks?


Odd number of Voting disks are required to prevent Split Brain Syndrome.
A node must be able to access more than half of the voting disks in order to decide which node can be evicted incase of 


failure.


5. How to backup Voting Disk?


Prior to Oracle 11g R2 version, Voting Disk is backed up using dd command


From 11g R2, no need to manually backup voting disk.
It is automatically backup along with OCR  whenever there is a configuration change.


In 11g R2, Restoring Voting disk from a manually copied backupfile may prevent cluster services from starting up.

31 thoughts on “Oracle Database Administrator Interview Questions on RAC”

  1. You’re so awesome! I don’t believe I have read a single thing like that before. So great to find someone with some original thoughts on this topic. Really.. thank you for starting this up. This website is something that is needed on the internet, someone with a little originality!

  2. Wow, marvelous weblog structure! How long have you ever been running a blog for? you make running a blog glance easy. The overall look of your web site is wonderful, as smartly as the content material!

  3. I like the valuable info you provide to your articles. I will bookmark your weblog and check once more here regularly. I am reasonably sure I’ll be told lots of new stuff proper right here! Best of luck for the following!

  4. Hey just wanted to give you a quick heads up and let you know a few of the images aren’t loading properly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same results.

  5. What i do not understood is actually how you’re no longer really much more well-preferred than you may be now. You’re very intelligent. You know thus significantly in terms of this subject, made me personally believe it from a lot of numerous angles. http://www.kayswell.com Its like men and women aren’t interested unless it’s something to do with Girl gaga! Your individual stuffs great. At all times deal with it up!

  6. What’s Going down i’m new to this, I stumbled upon this I have discovered It absolutely useful and it has aided me out loads. I am hoping to give a contribution & assist other users like its helped me. Great job.

  7. Right here is the perfect blog for everyone who hopes to find out about this topic. You understand so much its almost hard to argue with you (not that I actually will need to…HaHa). You definitely put a freshspin on a topic that has been written about for decades.Excellent stuff, just great!

  8. I know this if off topic but I’m looking into starting my own blog and was curious what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? http://www.ifashionstyles.com I’m not very web savvy so I’m not 100 sure. Any recommendations or advice would be greatly appreciated. Thanks

  9. Right here is the perfect blog for everyone who hopes to find out about this topic. You understand so much its almost hard to argue with you (not that I actually will need to…HaHa). You definitely put a freshspin on a topic that has been written about for decades.Excellent stuff, just great!

  10. Hi there, just became alert to your blog through Google,and found that it is truly informative. I am gonna watch outfor brussels. I’ll be grateful if you continue this in future.Lots of people will be benefited from your writing.Cheers!

  11. I’m not sure if this is a format issue or something to do with internet browser compatibility but I figured I’d post to let you know. The style and design look great though! Hope you get the issue fixed soon. Many thanks

Leave a Reply

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