오라클 19c vote 디스크 위치 변경 방법

OS 환경 : Oracle Linux 8.4 (64bit)

 

DB 환경 : Oracle Database 19.27.0.0

 

방법 : 오라클 19c vote 디스크 위치 변경 방법

설치시 ocr과 vote를 나누기 위해 vote 디스크그룹을 따로 추가한 경우 본문과 같은 절차로 vote 디스크를 다른 디스크그룹으로 변경할수 있음
현재 grid 설치시 asm 디스크를 ocr로 설정한 상태임
ocr도 +OCR로 설정되어있고, vote도 +OCR로 설정되어있음

 

 

현재 ocr 위치 확인

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

$ ocrcheck Status of Oracle Cluster Registry is as follows :          Version                  :          4          Total space (kbytes)     :     901284          Used space (kbytes)      :      84372          Available space (kbytes) :     816912          ID                       : 1645669115          Device/File Name         :       +OCR                                     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

+ocr에 존재함

 

 

현재 votedisk 위치 확인

1 2 3 4 5 6

$ crsctl query css votedisk ##  STATE    File Universal Id                File Name Disk group --  -----    -----------------                --------- ---------  1. ONLINE   7af4d351969b4fafbf3820a280eda284 (/dev/oracleasm/disks/OCR1) [OCR]  2. ONLINE   bfc984baab224f3dbf95225711a3735d (/dev/oracleasm/disks/OCR2) [OCR]  3. ONLINE   a4f208fc8d054f79bfedf9c512ef5514 (/dev/oracleasm/disks/OCR3) [OCR]

+ocr에 존재함

 

 

vote용 디스크그룹 생성

1 2 3 4 5 6 7 8

$ export ORACLE_SID=+ASM1 $ export ORACLE_HOME=$GRID_HOME $ sqlplus / as sysasm SQL> create diskgroup vote normal redundancy disk '/dev/oracleasm/disks/VOTE1','/dev/oracleasm/disks/VOTE2','/dev/oracleasm/disks/VOTE3' attribute 'compatible.asm'='19.0.0.0.0', 'compatible.rdbms'='10.1.0.0.0', 'au_size'='4m';   Diskgroup created.

 

 

디스크그룹 확인

1 2 3 4 5 6 7 8

SQL> select inst_id, name, state, type from gv$asm_diskgroup      INST_ID NAME                 STATE       TYPE ---------- -------------------- ----------- ------          1 OCR                  MOUNTED     NORMAL          1 VOTE                 MOUNTED     NORMAL          2 OCR                  MOUNTED     NORMAL          2 VOTE                 DISMOUNTED

2번 인스턴스에서는 아직 마운트되어있지 않음

 

 

2번 노드에서 mount 수행

1 2 3 4 5 6

$ export ORACLE_SID=+ASM2 $ export ORACLE_HOME=$GRID_HOME $ sqlplus / as sysasm SQL> alter diskgroup vote mount;   Diskgroup altered.

 

 

디스크그룹 재확인

1 2 3 4 5 6 7 8

SQL> select inst_id, name, state, type from gv$asm_diskgroup      INST_ID NAME                 STATE       TYPE ---------- -------------------- ----------- ------          1 OCR                  MOUNTED     NORMAL          1 VOTE                 MOUNTED     NORMAL          2 OCR                  MOUNTED     NORMAL          2 VOTE                 MOUNTED     NORMAL

정상적으로 마운트됨

 

 

votedisk의 디스크그룹 변경

1 2 3 4 5 6 7 8 9

$ crsctl replace votedisk +VOTE Successful addition of voting disk cbf4fb6df0f74f0abf837753f6ba09a7. Successful addition of voting disk b11b725601094f8dbf461a937a2bdccd. Successful addition of voting disk e1875e40a1274f26bf8cc6dd9b74d368. Successful deletion of voting disk 7af4d351969b4fafbf3820a280eda284. Successful deletion of voting disk bfc984baab224f3dbf95225711a3735d. Successful deletion of voting disk a4f208fc8d054f79bfedf9c512ef5514. Successfully replaced voting disk group with +VOTE. CRS-4266: Voting file(s) successfully replaced

변경됨

 

 

votedisk 확인

1 2 3 4 5 6

$ crsctl query css votedisk ##  STATE    File Universal Id                File Name Disk group --  -----    -----------------                --------- ---------  1. ONLINE   cbf4fb6df0f74f0abf837753f6ba09a7 (/dev/oracleasm/disks/VOTE1) [VOTE]  2. ONLINE   b11b725601094f8dbf461a937a2bdccd (/dev/oracleasm/disks/VOTE2) [VOTE]  3. ONLINE   e1875e40a1274f26bf8cc6dd9b74d368 (/dev/oracleasm/disks/VOTE3) [VOTE]

정상적으로 변경됨

 

 

참조 : 

https://positivemh.tistory.com/301

https://positivemh.tistory.com/594