• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Find Oracle RAC OCR & voting disk location

by admin

Voting Disk

It manages information about node membership. Each voting disk must be accessible by all nodes in the cluster. If any node is not passing heat-beat across other note or voting disk, then that node will be evicted by the Voting disk. Minimum 1 and maximum 15 copies of the voting disk is possible.

View voting disk location

To check voting disk location, run the below command:

crsctl query css votedisk

Sample Output:

$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   5d89f9b9a2d24f6cbfed2335d94877ed (/dev/oracleasm/disks/OCR_VOTE01) [OCR_VOTE]
 2. ONLINE   35a0cb950d9f4fbdbfcde2a044d56567 (/dev/oracleasm/disks/OCR_VOTE02) [OCR_VOTE]
 3. ONLINE   a5a60eddd3074f2bbfe091f6f26413ef (/dev/oracleasm/disks/OCR_VOTE03) [OCR_VOTE]

OCR

It is created at the time of Grid Installation. It’s store information to manage Oracle cluster-ware and its component such as RAC database, listener, VIP, Scan IP & Services. Minimum 1 and maximum 5 copy of OCR is possible.

Check OCR location

Run below command to view the OCR location:

$ ocrcheck
$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3720
         Available space (kbytes) :     258400
         ID                       : 1001500416
         Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured

         Cluster registry integrity check succeeded
         Logical corruption check bypassed due to non-privileged user

Here if you see the OCR is located on the ASM disk group “OCR_VOTE”.

Similarly you can also view the configuration file /etc/oracle/ocr.loc to get the OCR location. For example:

$ cat /etc/oracle/ocr.loc
ocrconfig_loc=+OCR_VOTE
local_only=FALSE

How to move the OCR location?

For Oracle RAC 10g Release 1

1. stop the CRS stack on all nodes using “init.crs stop”
2. Edit /var/opt/oracle/ocr.loc on all nodes and set up ocrconfig_loc=new OCR device
3. Restore from one of the automatic physical backups using ocrconfig -restore.
4. Run ocrcheck to verify.
5. reboot to restart the CRS stack.

For Oracle RAC 10g Release 2 or later

Please use the OCR command to replace the OCR with the new location:

# ocrconfig -replace ocr /dev/newocr
# ocrconfig -replace ocrmirror /dev/newocrmirror

Manual editing of ocr.loc or equivalent is not recommended, and will not work.

Filed Under: oracle, RAC

Some more articles you might also be interested in …

  1. How to relocate the redo log files to a different location on disk
  2. How to Move OCR, Vote Disk File, ASM SPILE to new Diskgroup
  3. How to recreate Control file in Oracle Database
  4. How to shrink a Temporary Tablespace datafile in Oracle
  5. How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments
  6. How to Create or Remove Restore Point on Oracle Standby database
  7. How to Remove or delete a Weblogic Server (WLS) Domain
  8. How to Audit Alter Tablespace in Oracle 12c database
  9. Database Crashed With ORA-19815, ORA-19809, ORA-16038
  10. How to list all the named events set for a database

You May Also Like

Primary Sidebar

Recent Posts

  • powertop Command Examples in Linux
  • powertop: command not found
  • powerstat: command not found
  • powerstat Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright