[기존 환경 확인]
[oracle@rac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 15 14:07:48 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +OCR/rac/ASMPARAMETERFILE/registry.253.1081948961
SQL> set linesize 150
SQL> col name for a20
SQL> col state for a10
SQL> col path for a40
SQL> select name, group_number "g_no", disk_number "d_no", state, redundancy, path from v$asm_disk order by 2;
NAME g_no d_no STATE REDUNDA PATH
-------------------- ---------- ---------- ---------- ------- ----------------------------------------
0 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk6
0 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk9
0 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk7
0 3 NORMAL UNKNOWN /dev/oracleasm/asm-disk8
DATA_0000 1 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk4
OCR_0000 2 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk1
OCR_0002 2 2 NORMAL UNKNOWN /dev/oracleasm/asm-disk3
OCR_0001 2 1 NORMAL UNKNOWN /dev/oracleasm/asm-disk2
OGG_0000 3 0 NORMAL UNKNOWN /dev/oracleasm/asm-disk5
9 rows selected.
SQL>
--신규 ASM Diskgroup 생성
[oracle@rac1 ~]$ sqlplus "/as sysasm"
SQL> create diskgroup OCRVOTE normal redundancy disk '/dev/oracleasm/asm-disk7' ,'/dev/oracleasm/asm-disk8' ,'/dev/oracleasm/asm-disk9' attribute 'compatible.rdbms'='19.0.0.0', 'compatible.asm'='19.0.0.0', 'au_size'='4M';
--기존 OCR/Vote 확인
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 901284
Used space (kbytes) : 84420
Available space (kbytes) : 816864
ID : 1506319257
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 succeeded
[root@rac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 79e105a1de7d4f6ebf0b83a4ddaf2cdd (/dev/oracleasm/asm-disk1) [OCR]
2. ONLINE 376b031ec3134ff9bf86a7fa85182990 (/dev/oracleasm/asm-disk2) [OCR]
3. ONLINE 01fe3ee7634c4f0abf310e15a97a2fde (/dev/oracleasm/asm-disk3) [OCR]
[OCR/VOTE Migration 및 확인]
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@rac1 bin]# ./ocrconfig -add +OCRVOTE
[root@rac1 bin]# ./ocrconfig -delete +OCR
[root@rac1 bin]# ./crsctl replace votedisk +OCRVOTE
Successful addition of voting disk 4a613638d60f4f15bf2bd0115c6e9a49.
Successful addition of voting disk 5f4d8540a9424fd2bf3a5c65249130a6.
Successful addition of voting disk acbbe1dd19454fe2bfa48781899cd1f8.
Successful deletion of voting disk 79e105a1de7d4f6ebf0b83a4ddaf2cdd.
Successful deletion of voting disk 376b031ec3134ff9bf86a7fa85182990.
Successful deletion of voting disk 01fe3ee7634c4f0abf310e15a97a2fde.
Successfully replaced voting disk group with +OCRVOTE.
CRS-4266: Voting file(s) successfully replaced
[root@rac1 bin]#
--OCR/VOTE변경 확인
[root@rac1 bin]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@rac1 bin]#
[root@rac1 bin]# pwd
/u01/app/19.0.0/grid/bin
[root@rac1 bin]#
[root@rac1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 901284
Used space (kbytes) : 84420
Available space (kbytes) : 816864
ID : 1506319257
Device/File Name : +OCRVOTE
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
[root@rac1 bin]# ./crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 4a613638d60f4f15bf2bd0115c6e9a49 (/dev/oracleasm/asm-disk7) [OCRVOTE]
2. ONLINE 5f4d8540a9424fd2bf3a5c65249130a6 (/dev/oracleasm/asm-disk8) [OCRVOTE]
3. ONLINE acbbe1dd19454fe2bfa48781899cd1f8 (/dev/oracleasm/asm-disk9) [OCRVOTE]
Located 3 voting disk(s).
[root@rac1 bin]#
[Oracle ASM SPFile 위치 변경]
--ASM spfile 이동
[oracle@rac1 DATASYNCXML]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 DATASYNCXML]$ pwd
/home/oracle/DATASYNCXML
[oracle@rac1 DATASYNCXML]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 DATASYNCXML]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 15 16:00:05 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> create pfile='/home/oracle/DATASYNCXML/initasm.ora' from spfile;
File created.
SQL> !ls
initasm.ora stop.txt
SQL> create spfile='+OCRVOTE' from pfile='/home/oracle/DATASYNCXML/initasm.ora';
File created.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@rac1 DATASYNCXML]$
[변경사항 확인 및 후속작업]
[oracle@rac1 DATASYNCXML]$ cd $ORACLE_HOME/bin
[oracle@rac1 bin]$ pwd
/u01/app/19.0.0/grid/bin
[oracle@rac1 bin]$ ./gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
./gpnptool.bin get -o-
<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="6" ClusterUId="11fd2242cacadff5ffb30b5fbc27e40f" ClusterName="rac" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.56.0" Adapter="enp0s8" Use="public"/><gpnp:Network id="net2" IP="192.168.10.0" Adapter="enp0s9" Use="asm,cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/oracleasm/*" SPFile="+OCRVOTE/rac/ASMPARAMETERFILE/registry.253.1088697629" Mode="remote" Extended="false"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>Ur5kuZgxkcFQhgXx1ZU+03Gse4U=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>VZw5Tw5YSo0L5SbRhpm5ju/RkoRDd9S+/mLkhMfNKGPaD0z6SZxCY5sIi3Wi5eCDAACdxGnPD6HIq7MaRbVRxG6+HmGJeGDcWq55Y7yxV0ehBPIDkc2zZ5rMxU3XxXwv81WrHka1V3rXhys6Pvsq2FOfWpFJHpAEH4rlKje0efcqU3mpGZUXSJK3DuJ6/Nf5
gURo7p6xci4rHZ2ky2BgrPRYCv4hXJ8FCrv5h7bCif6QjqQcsvFVaCKOydvRynEZ9+coH1n17yugVm6aDN/lM2EXSYpk1xuGVYhj9oIHxk6Z0tBmvdLyFJAoVL/Kw0iMyF7LltvXsXFsWsCJ5ouUCg==</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.
[oracle@rac1 bin]$
--Oracle CRS 재기동
[root@rac1 bin]# ./crsctl stop crs
[root@rac1 bin]# ./crsctl start crs
--기존 DIsk group 삭제
[oracle@rac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@rac1 ~]$ env | grep SID
ORACLE_SID=+ASM1
[oracle@rac1 ~]$ srvctl stop diskgroup -g OCR
[oracle@rac1 ~]$ srvctl remove diskgroup -g OCR