What questions are asked in the RAC interview?
Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
- What is the difference between Crash recovery and Instance recovery?
- What is the interconnect used for?
- How do you determine what protocol is being used for Interconnect traffic?
What is RAC interview?
RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance failover, media failover features.
What is split brain in RAC?
Split Brain is often used to describe the scenario when two or more nodes in a cluster, lose connectivity with one another but then continue to operate independently of each other, including acquiring logical or physical resources, under the incorrect assumption that the other process(es) are no longer operational or …
What is OCR in Oracle RAC?
The purpose of the Oracle Cluster Registry (OCR) is to hold cluster and database configuration information for RAC and Cluster Ready Services (CRS) such as the cluster node list, and cluster database instance to node mapping, and CRS application resource profiles.
What is Oracle RAC cluster?
Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage.
What is OCR and OLR in RAC?
ORACLE LOCAL REGISTRY(OLR) contains node-specific information required by OHASD . As OCRs files are present in ASM diskgroup, While starting the CRS, it wont be able to Access OCR file to find the cluster resource information. Because at this point ASM instance would also be down.
What Oracle RAC stands for?
Oracle Real Application Clusters
Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage.
What is cache coherence in RAC?
Maintaining the consistency of data blocks in the buffer caches of multiple instances is called cache coherency. Thus, cache coherency is maintained in the RAC system by coordinating buffer caches located on separate instances. GCS ensures that the data blocks cached in different cache buffers are maintained globally.
What is scan IP in RAC?
SCAN works by replacing a hostname or IP list with virtual IP addresses (VIP). Because SCAN determines the actual node and listener which accepts the connection, SCAN provides location independence for the databases. A SCAN database connection does not require any details about a particular node on instance.
What do you need to know about Oracle RAC?
Oracle RAC is a cluster database with a shared cache architecture that overcomes the limitations of traditional shared-nothing and shared-disk approaches to provide a highly scalable and available database solution for all your business applications. Oracle RAC provides the foundation for enterprise grid computing.
What’s the difference between 10g and 11g RAC?
Well, there is not much difference between 10g and 11gR (1) RAC. But there is a significant difference in 11gR2. Prior to 11gR1 (10g) RAC, the following were managed by Oracle CRS From 11gR2 (onwards) its completed HA stack managing and providing the following resources as like the other cluster software like VCS etc.
What is single client access name in RAC 11g?
Single Client Access Name (SCAN) is a new Oracle Real Application Clusters (RAC) 11g Release 2, feature that provides a single name for clients to access an Oracle Database running in a cluster. The benefit is clients using SCAN do not need to change if you add or remove nodes in the cluster.
How many instances can read and write in RAC?
Online redo logfile only one instance can write, but other instances can read during recovery and archiving. Alert log and trace files are private to each instance. Other instance never write or read to those files 12) Mention what is split brain syndrome in RAC?
