Wings of Destiny Today: 12    Total Posts: 10677

Moderator: Benzion


Create Thread

[Help] Top 10 Oracle RAC Interview Questions!

[Copy link] 0/27

Posted on 11/21/20 6:01:38 AM | Show thread starter's posts only

One of the most exciting new features in Oracle Database is Real Application Clusters (RAC). The Oracle RAC solution offers 24/7 database availability, performance, and scalability.

1Q) Describe the Oracle Real Application Clusters Architecture?
Ans: Oracle RAC consists of a database that is represented in a clustered manner in the architecture. The cluster is the collection or pool of independent servers that make up one single system.

Cluster architecture provides more flexibility to manage and follow a modular incremental approach to improve fault errors and provide an incremental system.

This architecture provides maximum security in terms of ensuring the high availability of the resources to the users.

It provides the resources on-demand and provides hardware architecture such as failure at a single point is being removed.

The architecture provides the decoupling of the Oracle instance like the process and memory that are running on the server from the Oracle database.

2Q) What was the main purpose of Oracle Real Application Clusters (RAC)?
Ans: Oracle Real Application (RAC) provides the interaction of executable file with the Oracle database.
It allows the running of any packaged or custom-built application with Oracle DB that is running on a server pool. It provides a very high level of availability, flexibility, and scalability to run the application and store it to the database.
It creates the database such that if the pool fails then the database is continued to run from the remaining servers and the load can be distributed. It makes it easier for the administrator to maintain many servers at the same time by load-balancing techniques and providing provision to add more and more servers when the load increases.

3Q) Differentiate Crash recovery and Instance recovery?
Ans: When an instance crashes in a single node database on startup a crash recovery takes place. In a RAC environment, the same recovery for an instance is performed by the surviving nodes called Instance recovery.
Inclined to build a profession as Oracle RAC? Then here is the blog post on, explore "Oracle RAC Training"
4Q) What is the interconnect used for?
Ans: A private N/W is used to ship data blocks from one instance to another for cache fusion. The physical data blocks as well as data dictionary blocks are shared across this interconnect.

5Q) How do you determine what protocol is being used for Interconnect traffic?
Ans: One of the ways is to look at the DB alert log for the time period when the DB was started up.

6Q) What methods are available to keep the time synchronized on all nodes in the cluster?
Ans: Either the Network Time Protocol(NTP) can be configured or in 11gr2, Cluster Time Synchronization Service (CTSS) can be used.

7Q) What files components in RAC must reside on shared storage?
Ans: Spfiles, ControlFiles, Datafiles, and Redolog files should be created.

8Q) How do you find out what OCR backups are available?
Ans: The OCR config -show backup can be run to find out the automatic and manually run backups.

9Q) If your OCR is corrupted what options do have to resolve this?
Ans: You can use either the logical or the physical OCR backup copy to restore the Repository.

10Q) How do you find out what object has its blocks being shipped across the instance the most?
Ans: You can use the dba_hist_seg_stats.

These Oracle RAC Interview Questions and Answers will help you to get success in your next interview success.