lundi 10 septembre 2018

How to move OCR and VOTE file (Use case with ASM disks)





How to move OCR and VOTE file (Use Case)

OCR: It created at the time of Grid Infrastructure Installation. It stores information to manage Oracle clusterware and its component such as RAC Database, Listener, VIP, Scan IP and services. Minimum 1 and maximum 5 copies of OCR are possible.
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-eat across other note or voting disk, then that node will be evicted by Voting disk. Minimum 1 and maximum 15 copies of voting disk are possible.
Facts:
  • We can store OCR And Voting disk on ASM or certified cluster file system.
  • We can dynamically add or replace voting disk & OCR.
  • Backup of Voting disk using “dd” command not supported.
  • Voting disk and OCR can be keep in same disk-group or different disk-group
  • Voting disk and OCR automatic backup kept together in a single file.
  • Automatic backup of Voting disk and OCR happen after every four hours, end of the day, end of the week
  • You must have root or sudo privilege account to manage it.
In our case, both OCR and Voting disk are originally stored in an ASM diskgroup +DATA_DG
We have to move it in a diskgroup +RECO_DG.

Procedure to move OCR:
1.       Ensure the location of OCR and Voting Disks.
   Run the command ocrcheck as GRID or ROOT user.
-sh-4.1# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     409568
         Used space (kbytes)      :      10288
         Available space (kbytes) :     399280
         ID                       : 2126565911
         Device/File Name         :   +DATA_DG
                                    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 succeeded
-sh-4.1#

2.       Run the following commands as ROOT user:
[root@**********dbadm05 ~]# $GRID_HOME/bin/ocrconfig -add +RECO_DG
[root@**********dbadm05 ~]# $GRID_HOME/bin/ocrconfig -delete +DATA_DG
Output
-------------------------------------------
-sh-4.1# cd /u01/app/12.1.0.2/grid/bin/
-sh-4.1# ./ocrconfig -add +RECO_DG
-sh-4.1#
-sh-4.1# ./ocrconfig -delete +DATA_DG
-sh-4.1#

3.       Verify that OCR is now located on the diskgroup

-sh-4.1# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     409568
         Used space (kbytes)      :      10288
         Available space (kbytes) :     399280
         ID                       : 2126565911
         Device/File Name         :   +RECO_DG
                                    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 succeeded
-sh-4.1#





Procedure to move VOTE Disks

1.       As GRID user, verify the location of Vote disks
[grid@**********dbadm05 bin]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   bfd18f130e8d4f7abf635d221ff30bc2 (o/192.168.10.10/DATA_DG_CD_02_**********celadm06) [DATA_DG]
 2. ONLINE   8e4b44c4cb2f4ff5bf0c6925d6de502d (o/192.168.10.9/DATA_DG_CD_09_**********celadm05) [DATA_DG]
 3. ONLINE   5d0f52427b864fb1bfb10459c6d865eb (o/192.168.10.11/DATA_DG_CD_02_**********celadm07) [DATA_DG]
 4. ONLINE   e52a1489371d4fa1bfb80e98f37ca390 (o/192.168.10.5/DATA_DG_CD_02_**********cela**********) [DATA_DG]
 5. ONLINE   58db886482454f77bf10e8f9d37cf39c (o/192.168.10.6/DATA_DG_CD_02_**********celadm02) [DATA_DG]
Located 5 voting disk(s).
[grid@**********dbadm05 bin]$

2.       As GRID User, run the following command:

[grid@**********dbadm05 bin]$ crsctl replace votedisk +RECO_DG
Successful addition of voting disk 53c42c2a1d364f86bf2285c3fb24b869.
Successful addition of voting disk 858f1e5266aa4f0ebfb4558b1e7bfe6a.
Successful addition of voting disk eab7f715e7174f7fbfa280ea27764625.
Successful deletion of voting disk bfd18f130e8d4f7abf635d221ff30bc2.
Successful deletion of voting disk 8e4b44c4cb2f4ff5bf0c6925d6de502d.
Successful deletion of voting disk 5d0f52427b864fb1bfb10459c6d865eb.
Successful deletion of voting disk e52a1489371d4fa1bfb80e98f37ca390.
Successful deletion of voting disk 58db886482454f77bf10e8f9d37cf39c.
Successfully replaced voting disk group with +RECO_DG.
CRS-4266: Voting file(s) successfully replaced
[grid@**********dbadm05 bin]$

3.       Check the new location:
[grid@**********dbadm05 bin]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   53c42c2a1d364f86bf2285c3fb24b869 (o/192.168.10.10/RECO_DG_CD_09_**********celadm06) [RECO_DG]
 2. ONLINE   858f1e5266aa4f0ebfb4558b1e7bfe6a (o/192.168.10.11/RECO_DG_CD_02_**********celadm07) [RECO_DG]
 3. ONLINE   eab7f715e7174f7fbfa280ea27764625 (o/192.168.10.5/RECO_DG_CD_02_**********cela**********) [RECO_DG]
Located 3 voting disk(s).
[grid@**********dbadm05 bin]$

Aucun commentaire:

Enregistrer un commentaire

How to fix errors : -         ORA-38760: This database instance failed to turn on flashback database -         ORA-38780: Restore poin...