Tuesday, May 24, 2022

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high.

1) Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files. 

[root@stg-odb-01 ~]# lsblk
NAME               MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
fd0                  2:0    1    4K  0 disk
sda                  8:0    0   50G  0 disk
├─sda1               8:1    0  512M  0 part /boot
└─sda2               8:2    0 49.5G  0 part
  ├─vg_system-root 253:0    0 27.5G  0 lvm  /
  ├─vg_system-swap 253:1    0    2G  0 lvm  [SWAP]
  ├─vg_system-var  253:4    0   18G  0 lvm  /var
  └─vg_system-tmp  253:5    0    2G  0 lvm  /var/tmp
sdb                  8:16   0  150G  0 disk
└─vg_app1-lv_app1  253:3    0  150G  0 lvm  /u01
sdc                  8:32   0  200G  0 disk
└─vg_app2-lv_app2  253:2    0  200G  0 lvm  /bkp
sdd                  8:48   0   20G  0 disk [SWAP]
sde                  8:64   0   15G  0 disk
sdf                  8:80   0   10G  0 disk
└─sdf1               8:81   0   10G  0 part
sdg                  8:96   0   10G  0 disk
└─sdg1               8:97   0   10G  0 part
sdh                  8:112  0   10G  0 disk
└─sdh1               8:113  0   10G  0 part
sdi                  8:128  0  200G  0 disk
└─sdi1               8:129  0  200G  0 part
sdj                  8:144  0  200G  0 disk
└─sdj1               8:145  0  200G  0 part
sdk                  8:160  0  100G  0 disk
└─sdk1               8:161  0  100G  0 part
sdl                  8:176  0   50G  0 disk
sdm                  8:192  0   50G  0 disk
sdn                  8:208  0   50G  0 disk
sdo                  8:224  0   50G  0 disk
sdp                  8:240  0   50G  0 disk
sdq                 65:0    0  200G  0 disk
sdr                 65:16   0  200G  0 disk
sds                 65:32   0   15G  0 disk
sdt                 65:48   0   15G  0 disk
sr0                 11:0    1 1024M  0 rom
[root@stg-odb-01 ~]#
[root@stg-odb-01 ~]# oracleasm createdisk ocrdg1 /dev/sdl1
Writing disk header: done
Instantiating disk: done
[root@stg-odb-01 ~]# oracleasm createdisk ocrdg2 /dev/sdm1
Writing disk header: done
Instantiating disk: done
[root@stg-odb-01 ~]# oracleasm createdisk ocrdg3 /dev/sdn1
Writing disk header: done
Instantiating disk: done
[root@stg-odb-01 ~]# oracleasm createdisk ocrdg4 /dev/sdo1
Writing disk header: done
Instantiating disk: done
[root@stg-odb-01 ~]# oracleasm createdisk ocrdg5 /dev/sdp1
Writing disk header: done
Instantiating disk: done
[root@stg-odb-01 ~]# oracleasm listdisks
DATA
FRA
MGMT
OCR1
OCR2
OCR3
OCRDG1
OCRDG2
OCRDG3
OCRDG4
OCRDG5
[root@stg-odb-01 ~]#


2) Ensure that the new diskgroup is mounted on all cluster nodes.


SQL> select name, state, type from v$asm_diskgroup;


NAME                           STATE       TYPE
------------------------------ ----------- ------
CRS                            MOUNTED     EXTERN
DATA                           MOUNTED     EXTERN
FRA                            MOUNTED     EXTERN
MGMT                           MOUNTED     EXTERN
OCRVOTE                        MOUNTED     HIGH
REDO                           MOUNTED     EXTERN
CTRL                           MOUNTED     EXTERN

7 rows selected.

SQL>


3) Move OCR and Vote file from <Current diskgroup> to <CRS>.

[root@stg-odb-01 ~]# . grid.env
[root@stg-odb-01 ~]# echo $ORACLE_HOME/
/u01/app/19c/grid/

[root@stg-odb-01 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   5514c6244e044f18bffd1d6339668864 (/dev/oracleasm/disks/OCR3) [CRS]

[root@stg-odb-01 ~]# $ORACLE_HOME/bin/ocrconfig -add +OCRVOTE
[root@stg-odb-01 ~]# $ORACLE_HOME/bin/ocrconfig -delete +CRS
[root@stg-odb-01 ~]# $ORACLE_HOME/bin/crsctl replace votedisk +OCRVOTE
Successful addition of voting disk 05b11d58ce5f4facbfb4ca63ab85a61c.
Successful addition of voting disk 4dcd2003d16a4f31bf593978387af8d0.
Successful addition of voting disk 943b16d7e1b74f54bfc432362509f5d0.
Successful addition of voting disk e9706bb9dd0b4f5cbf80181bcddbae24.
Successful addition of voting disk ff808ea40b124f65bff7ca4cec6eeb56.
Successful deletion of voting disk 5514c6244e044f18bffd1d6339668864.
Successfully replaced voting disk group with +OCRVOTE.
CRS-4266: Voting file(s) successfully replaced
[root@stg-odb-01 ~]#


4)  Change ASM SPFILE location from <current diskgroup> to <CRS> Diskgroup.

Login as SYSASM using SQLPLUS into ASM instance on one node and run below commands:

SQL> create pfile='/tmp/initnew.ora' from spfile;

SQL> create spfile='+OCRVOTE' from pfile='/tmp/initnew.ora';

That can be verified by below command :  (As grid user or root) 

Now GPNPTOOL will get updated with new ASM SPFILE location.

$ORACLE_HOME/bin/gpnptool get

5) Restart CRS in all nodes to startup CRS using new SPFILE from <CRS> diskgroup 

$> crsctl stop crs
$> crsctl start crs



Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts