TutorialDBA - Support | Training | Consultant

1. Where are the Clusterware files stored on a RAC environment? The Clusterware is installed on each node (on an Oracle Home) and on the shared disks (the voting disks and the CSR file) 2. Where are the database software files stored on a RAC environment? The base software is installed on each node of the cluster and the database storage on the shared disks. 3. What kind of storage we can use for the shared Clusterware files? - OCFS (Release 1 or 2) - raw devices - third party cluster file system such as GPFS or Veritas 4. What kind of storage we can use for the RAC database storage? - OCFS (Release 1 or 2) - ASM - raw devices - third party cluster file system such as GPFS or Veritas 5. What is a CFS? A cluster File System (CFS) is a file system that may be accessed (read and write) by all members in a cluster at the same time. This implies that all members of a cluster have the same view. 6. What is an OCFS2? The OCFS2 is the Oracle (version 2) Cluster File System which ...

Describe the Oracle Real Application Clusters Architecture? 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 the fault errors and provide an incremental system. This architecture provides the maximum security in terms of ensuring high availability of the resources to the users. It provides the resources on demand and provides hardware architecture such that a single point of failure 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. What is the main purpose of Oracle Real Application Clusters (RAC)? Oracle Real Application (RAC) provides the interaction of executable file with the Oracle database. It al...

1.What is cache fusion? Cache fusion is nothing but a mapping of remote memory of oracle buffers, which is shared between the caches participating nodes in the cluster. It is very easy to gain the block image from the instance that contain the block in its SGA instead of reading from the disk, this happens when the block of data is read from data file by an instance in the cluster and when another instance require the same block. 2.What are the components of clusterware? Oracle cluster registry (OCR):  It contains all information about instances, services, state information, cluster configuration, nodes and ASM storage if needed.  The OCR should occupy on a shared disk, which is accessible by all the nodes in your cluster. In OCR, the daemon OCSSd is used to manage the configuration and in the registry, it maintains the changes to the cluster. Voting Disk:  It helps to verify, if a node has failed, which means it got separated from the majority, then it is reboo...

1) Mention what is cluster? A cluster is referred to a group of independent, but connected servers that behaves as a single system. 2) Mention 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. 3) Mention 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 4) Mention 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 5) Mention what are the file storage options provided by Oracle Database for Oracle RAC? The file storage...