Oracle Cluster Registry (OCR) and Oracle Local Registry (OLR) Oracle Cluster Registry (OCR) and Oracle Local Registry (OLR) are two very important components of a Grid Infrastructure that help manage the cluster resources. OCR is what registry is for Windows. When exporting OCR, Oracle recommends including "ocr", the cluster name, and the timestamp in the name string. [root@NODE01 ~]# /u01/app/11.2.0.4/grid/bin/ocrconfig -delete +OCRVD_DG, 11. In addition to using the automatically created OCR backup files, you should also export OCR contents before and after making significant configuration changes, such as adding or deleting nodes from your environment, modifying Oracle Clusterware resources, and upgrading, downgrading or creating a database. If you run the ocrconfig -add | -repair | -replace command, then the device, file, or Oracle ASM disk group that you are adding must be accessible. If an Oracle ASM instance fails on any node, then OCR becomes unavailable on that particular node. Oracle Clusterware can manage up to five redundant OCR locations. This section describes how to back up OCR content and use it for recovery. Basic information about the resources, their location, permissions, current value, type, state, etc. Healthy nodes will have a continuous network and disk heartbeats exchanged between the nodes. When the clusterware stack is down on all nodes in the cluster, the backups that are listed by the ocrconfig -showbackup command may differ from node to node. Successful deletion of voting disk 0e3a9c8e306a2befaf5548b77231be3a. Restoring the Oracle Cluster Registry on Linux or UNIX Systems, Restoring the Oracle Cluster Registry on Windows Systems, Restoring the Oracle Cluster Registry in an Oracle Restart Environment. Voting files. Each node reads its KILL BLOCK once per second, if the kill block is not overwritten, the node commits suicide. I am installing two node Oracle 11gR1 RAC on Solaris. voting disk However, if you upgrade from a previous version of Oracle Clusterware, you can migrate OCR to reside on Oracle ASM, and take advantage of the improvements in managing Oracle Clusterware storage. However, each successive run must point to a different disk group. Managing Oracle Cluster Registry and Voting Disks Perform this operation on every voting disk as needed where voting_disk_name is the name of the active voting disk and backup_file_name is the name of the file to which you want to back up the voting disk contents: Run the following command to recover a voting disk where backup_file_name is the name of the voting disk backup file and voting_disk_name is the name of the active voting disk: Hope you like the information onvoting disks in RAC. on Oct 5 2010. This means that a device must exist. Helpful tips . In 10g, Oracle Clusterware can support 32 voting disks but in 11g R 2 supports 15 voting disks. In 10g, Oracle Clusterware can support 32 voting disks but in 11g R 2 supports 15 voting disks. An FRA diskgroup that holds archivelogs and backups. voting disk +OCRVD_DG/RAC-cluster/asmparameterfile/registry.183.284573136. Difference between Oracle Clusterware uses voting files to determine which nodes are members of a Move the OCR to new diskgroup. If we are not using a voting disk, then due to network failure, nodes are neither able to communicate with each other nor synchronize with the database, this situation is called a cluster SPLIT-BRAIN problem. A normal redundancy disk group must contain at least two failure groups but if you are storing your voting disks on Oracle ASM, then a normal redundancy disk group must contain at least three failure groups. To migrate OCR from Oracle ASM to another storage type: Create a file in a shared or cluster file system with the following permissions: root, oinstall, 640. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. The first method uses automatically generated OCR copies and the second method enables you to issue a backup command manually: Automatic backups: Oracle Clusterware automatically creates OCR backups every four hours. If the configurations match, ensure that the node can access all of the configured OCRs by running an ls command on Linux and UNIX systems. WebOCR and Voting Disk. For eg, if you have 5 voting disks, a node must be able to access at least 3 of the voting disks. Nodes with quorum will maintain active membership of the cluster and other nodes (s) will be fenced/rebooted. For example, the database cannot be started until the asm resource has come up, or the service resource doesnt start until the database has been started. If voting disks are stored on Oracle ASM with normal or high redundancy, and the storage hardware in one failure group suffers a failure, then if there is another disk available in a disk group in an unaffected failure group, Oracle ASM recovers the voting disk in the unaffected failure group. You can manually mirror OCR, as described in the "Adding an Oracle Cluster Registry Location" section, if you: Upgraded to Oracle Clusterware 11g release 2 (11.2) but did not choose to mirror OCR during the upgrade, Created only one OCR location during the Oracle Clusterware installation. It maintains and consists of important details about the cluster nodes membership, such as which node is part of the cluster, who (node) is joining the cluster, and who (node) is leaving the cluster. col name for a20 The voting disk is a file that manages information about node membership, and the OCR is a file that manages the cluster and Real Application Clusters (RAC) database configuration information. 3. OCR stores Oracle Clusterware and Oracle RAC database configuration information However, overriding the protection mechanism can result in the loss of data that was not available when the previous known good state was created. OCR and Voting Disk Restore Voting Disk Since we have restored OCR, we restored voting file as well. If the OCR mirror and OCR have been deleted, then it may be faster to restore the OCR using the OCR backups. Majority of the keys in the OCRDUMPFILE deal with the CRSd. If you have only one OCR location configured and online, then you must first add a new location and then delete the failed location, as follows: It may be necessary to repair OCR if your cluster configuration changes while that node is stopped and this node is the only member in the cluster. Oracle recommends that you do not use more than five voting files, Following are the steps to move OCR, Voting Disk and Spfile to new disk group. To downgrade, follow the downgrade instructions for each component and also downgrade OCR using the ocrconfig -downgrade command. Thus heartbeat of various nodes is recorded at different offsets in the voting disk. Helpful tips . Oracle recommends that you use either automatic or manual backups, and the ocrconfig -restore command instead of the ocrconfig -export and ocrconfig -import commands to restore OCR for the following reasons: A backup is a consistent snapshot of OCR, whereas an export is not. By default, redo logs and control files are mirrored to both the DATA and FRA diskgroups. 10. Remove an OCR location if, for example, your system experiences a performance degradation due to OCR processing or if you transfer your OCR to RAID storage devices and choose to no longer use multiple OCR locations, as described in the "Removing an Oracle Cluster Registry Location" section. Oracle High Availability Services uses this information. Check the Voting Disk Location OCR OCR Oracle Cluster Registry (OCR) which records cluster configuration information. The following example shows how to migrate OCR from Oracle ASM to block devices using OCRCONFIG. A small number of failure groups, or failure groups of uneven capacity, can create allocation problems that prevent full use of all of the available storage. OLR is located on local storage on each node in a cluster. acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structures & Algorithms in JavaScript, Data Structure & Algorithm-Self Paced(C++/JAVA), Full Stack Development with React & Node JS(Live), Android App Development with Kotlin(Live), Python Backend Development with Django(Live), DevOps Engineering - Planning to Production, GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam, Interview Preparation For Software Developers. You can list backups with the ocrconfig -showbackup command, whereas you must keep track of all generated exports. What is NETWORK and DISK HEARTBEAT and how does it register in VOTING DISKS/FILES? Database data files, temp files, redo logs and undo, SYSTEM, SYSAUX, DATA, INDEX, USERS, TEMP, UNDO, Shared or database-specific ASM diskgroups, ScaleIO volumes, ASM diskgroup, and database datafile relationship, ASM stripesize, coarse, and fine grained striping, ASM intelligent data placement and physical disk placement, ASM compaction and rebalance (ASM 11.1.0.7 and later), A DATA diskgroup to hold all data, index, undo and temp files, An FRA diskgroup that holds archivelogs and backups, Since Oracle Database 11gR2 it is recommended to store the OCR and Voting Files in a standalone ASM diskgroup, as shown in, Using VMDKs and ASM with Virtualized Databases. FAILGROUP fg03 DISK '/dev/oracleasm/disks/OCR_DISK13'; 6. Please contact us at contactus@smarttechways.com, How to get DDL of Tablespace present in OracleDatabase, Follow Smart way of Technology on WordPress.com, Exclude/Include option in EXPDP and IMPDP Datapump, Create & grant permission to directory in Oracle, Check the Undo tablespace Usage in Oracle, Check datafiles and tablespace information in Oracle, Check the Patch Applied to the Oracle Database, Stop the EXPDP/IMPDP Datapump Job in Oracle, Find top CPU Consuming Session or SQLs query in Oracle. Move the SPFILE to newdiskgroup. To add a new disk and remove the existing disk, run the following command, replacing the path_to_voting_diskB variable with the fully qualified path name of voting disk B: The -purge option deletes existing voting disks. Oracle Cluster Registry (OCR) and Oracle Local Registry (OLR) are two very important components of a Grid Infrastructure that help manage the clusterresources. To restore an OCR when clusterware is down. Its application is in google books, bank statements, business documents etc. The Oracle Clusterware (Oracle Grid Infrastructure GI stack in 11gR2) uses OCR to manage resources and node membership information.