Overview of Oracle RAC
A cluster comprises multiple interconnected computers or servers that appear as if they are one server to end users and applications. Oracle RAC enables you to cluster Oracle databases. Oracle RAC uses Oracle Clusterware for the infrastructure to bind multiple servers so they operate as a single system.
Oracle Clusterware is a portable cluster management solution that is integrated with Oracle Database. Oracle Clusterware is also a required component for using Oracle RAC. In addition, Oracle Clusterware enables both single-instance Oracle databases and Oracle RAC databases to use the Oracle high-availability infrastructure. Oracle Clusterware enables you to create a clustered pool of storage to be used by any combination of single-instance and Oracle RAC databases.
Oracle Clusterware is the only clusterware that you need for most platforms on which Oracle RAC operates. You can also use clusterware from other vendors if the clusterware is certified for Oracle RAC.
Reference what is cluster?
A cluster is referred to a group of independent, but connected servers that behaves as a single system.
Indication what is the volume management techniques used in Oracle RAC?
Volume management techniques used in Oracle RAC is that,
- Oracle RAC provides dynamic volume manager. It has a file system that consists of information of the cluster file system
- Cluster file system in Oracle is known as OCFS. It has the connection with the databases that provide raw devices and command line features.
Reference what is new feature in Oracle ASM 12c?
The new feature added in Oracle ASM 12c is Oracle Flex ASM. Its a new ASM deployment model which increases instance database availability and reduces the Oracle ASM related resource consumption.
Reference how Oracle Flex ASM works?
Oracle Flex ASM instance when fails on a particular node, then the Oracle Flex ASM instance is passed over to another node in the cluster.
Reference what are the key characteristics of RAC or why to use RAC?
The key characteristics of RAC are,
- Reliability: Eliminates the database server from a single point of failure. If an instance fails, the remaining instances in the cluster remain active and open.
- Error Detection: Provides fast detection of problems in the environment. It automatically recovers from failures even before user’s notice that a failure has occurred.
- Recoverability: Easy to recover from various types of failures.
- Continuous Operations: provides continuous service for both unplanned and planned outages
Mention what is the function of Cache Fusion in Oracle RAC?
Cache function is used to show the storage of the information in the clustered network with the Oracle database. It involves two nodes, one writes the data to the same disk, and other reads the data block from the disk. For its network connection, RAC uses a dedicated server for its network, and cache function is an internal part of the cluster.
Difference between single instance environment and RAC environment?
| Single Instance Environment | RAC Environment |
| · Instance has its own SGA (System Global Area) | · Each instance has its own SGA |
| · Datafiles and control files are accessed by only one instance | · Datafiles and control files shared by all instances |
| · Online redo logfile dedicated for read/write to only one instance | · Online redo logfile only one instance can write, but other instances can read during recovery and archiving. |
| · Flash recovery log accessed by only one instance | · Flash recovery log shared by all instances |
| · Alert log and trace files dedicated to the instance | · Alert log and trace files are private to each instance. Other instance never writes or read to those files |
Reference what is split brain syndrome in RAC?
In Oracle RAC, all the instances/servers communicate with each other using a private network. When the instance members in a RAC fail to ping/connect to each other via this private network and continue to process data block independently. Then this process is referred as Split-Brain Syndrome.
What happens if you keep split brain syndrome in RAC unresolved? How it can be resolved?
If you keep split brain syndrome unresolved, then there would be data integrity issue. The blocks changed in one instance will not be locked and could be over-written by another instance. It is resolved by using the voting disk, it will decide which node(s) will survive and which node(s) will be evicted.
Discussion how can you determine what protocol is being used for Interconnect traffic?
To determine what protocol is being used for Interconnect traffic you can look at the database alert log for the time period when the database was started up.
Discussion in RAC what files should be created on shared storage?
In RAC ControlFiles, Spfiles, Redolog files, and Datafiles should be created on shared storage.
Mention what are the tools provided in Oracle Enterprise Manager?
Tools provided in Oracle Enterprise Manager are,
Grid Control-
- It is used to deliver the centralized management system and provides configuration and administration capabilities.
- It provides the cost reduction plans and provides higher efficiency
Database Control-
- It is used as a graphical management tool to manage the database to make it configure automatically.
- It is related to the Oracle Clusterware. It is used to maintain the services of the Oracle RAC.
- It also manages the server pools that are being created with the Oracle Clusterware and provision to manage it from a single place.
Mention what is the difference between Instance recovery and Crash recovery?
A crash recovery takes place when an instance crashes in a single node database on startup. When the same recovery for an instance is performed in RAC environment by the surviving nodes then it is called Instance recovery.
What if your OCR (Oracle Cluster Registry) is corrupted?
if your OCR is corrupted, you can either use the logical or physical OCR backup copy to restore the repository.
Mention what is OLR?
ORL stands for Oracle Local Repository (OLR). It consists of information which enables the cluster programs to initiate with the OCR in the ASM Storage. Until the grid process are started, the ASM file is unavailable. In such case, a local copy of the data of the OCR is required, that is stored in OLR.
Reference what is Oracle Real Application Clusters?
RAC or Real Application Cluster is a component of the database product that enables the database to be installed across multiple servers. Oracle RAC uses Oracle Clusterware for the infrastructure to bind multiple servers, so they operate as a single system.
Reference what are the main components of an Oracle RAC system?
The main elements of an Oracle RAC system are,
- Shared disk system
- Oracle Clusterware
- Cluster Interconnects
- Oracle Kernel Components
Reference what are the benefits of Oracle RAC?
Benefits of RAC is that
- Business Continuity and High Availability
- Workload Management with least expense
- Agility and Scalability
- System management and Standardized deployment
Reference what are the file storage options provided by Oracle Database for Oracle RAC?
The file storage options provided by Oracle Database for Oracle RAC are,
- Automatic Storage Management (ASM)
- OCFS2 and Oracle Cluster File System (OCFS)
- A network file system
- Raw devices