ORACLE 12c RAC 환경 ASMlib DISK GROUP에 DISK 추가하기 (Virtual Box, sqlplus 환경)

https://devcami.tistory.com/23 

ORACLE 19c RAC 환경 ASMFD DISK GROUP에 DISK 추가하기 (Virtual Box, asmca gui 환경)

VM에서 물리적인 디스크 생성방법 참조

CRS4로 30기가 생성 후 추가함

[rac2|root:/root]> ls -al /dev/sd*
brw-rw----. 1 root disk 8,  0 Mar 20 13:50 /dev/sda
brw-rw----. 1 root disk 8,  1 Mar 20 13:50 /dev/sda1
brw-rw----. 1 root disk 8,  2 Mar 20 13:50 /dev/sda2
brw-rw----. 1 root disk 8, 16 Mar 20 13:50 /dev/sdb
brw-rw----. 1 root disk 8, 17 Mar 20 13:50 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Mar 20 13:50 /dev/sdc
brw-rw----. 1 root disk 8, 33 Mar 20 13:50 /dev/sdc1
brw-rw----. 1 root disk 8, 48 Mar 20 13:50 /dev/sdd
brw-rw----. 1 root disk 8, 49 Mar 20 13:50 /dev/sdd1
brw-rw----. 1 root disk 8, 64 Mar 20 13:50 /dev/sde
brw-rw----. 1 root disk 8, 65 Mar 20 13:50 /dev/sde1
brw-rw----. 1 root disk 8, 80 Mar 20 13:50 /dev/sdf
brw-rw----. 1 root disk 8, 81 Mar 20 13:50 /dev/sdf1
brw-rw----. 1 root disk 8, 96 Mar 20 13:50 /dev/sdg

-> 여기서 sdg에 해당하는 새로 추가한 디스크 (CRS4)를 디스크그룹 CRS에 추가할것임

[rac1|root:/root]> fdisk /dev/sdg
Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.

Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xa0fb2ea9.

Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): 
Using default response p
Partition number (1-4, default 1): 
First sector (2048-62914559, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559): 
Using default value 62914559
Partition 1 of type Linux and of size 30 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[rac1|root:/root]> ls -al /dev/sd*
brw-rw----. 1 root disk 8,  0 Mar 20 13:29 /dev/sda
brw-rw----. 1 root disk 8,  1 Mar 20 13:29 /dev/sda1
brw-rw----. 1 root disk 8,  2 Mar 20 13:29 /dev/sda2
brw-rw----. 1 root disk 8, 16 Mar 20 13:29 /dev/sdb
brw-rw----. 1 root disk 8, 17 Mar 20 13:29 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Mar 20 13:29 /dev/sdc
brw-rw----. 1 root disk 8, 33 Mar 20 13:29 /dev/sdc1
brw-rw----. 1 root disk 8, 48 Mar 20 13:29 /dev/sdd
brw-rw----. 1 root disk 8, 49 Mar 20 13:29 /dev/sdd1
brw-rw----. 1 root disk 8, 64 Mar 20 13:29 /dev/sde
brw-rw----. 1 root disk 8, 65 Mar 20 13:29 /dev/sde1
brw-rw----. 1 root disk 8, 80 Mar 20 13:29 /dev/sdf
brw-rw----. 1 root disk 8, 81 Mar 20 13:29 /dev/sdf1
brw-rw----. 1 root disk 8, 96 Mar 20 13:30 /dev/sdg
brw-rw----. 1 root disk 8, 97 Mar 20 13:30 /dev/sdg1

CRS 중지 < 모든 노드 >

[rac2|root:/root]> crsctl stop crs

 

ORACLE ASM 에 디스크 추가

# 디스크 생성 - 노드 1에서만 진행
[rac1|root:/root]> oracleasm createdisk CRS4 /dev/sdg1
Writing disk header: done
Instantiating disk: done

# 디스크 스캔 - 노드 1, 2 모두 진행
[rac1|root:/root]> oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...

[rac2|root:/root]> oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "CRS4"


# 확인 - 노드 1, 2 모두 진행
[rac1|root:/root]> oracleasm listdisks
CRS1
CRS2
CRS3
CRS4
DATA
FRA

[rac2|root:/root]> oracleasm listdisks
CRS1
CRS2
CRS3
CRS4
DATA
FRA

CRS 시작 < 모든 노드 >

[rac2|root:/root]> crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

 

asm sqlplus로 접속하여 디스크 추가

[+ASM1|oracle:/home/oracle]> sqlplus / as sysasm
SQL> set sqlprompt "_connect_identifier> "

# 사용되지 않는 asm disk 조회
set line 200
col path for a15
select group_number, mount_status, path, total_mb
from v$asm_disk where mount_status='CLOSED';

GROUP_NUMBER MOUNT_S PATH	       TOTAL_MB
------------ ------- --------------- ----------
	   0 CLOSED  /dev/sda		      0
	   0 CLOSED  /dev/sdg		      0
	   0 CLOSED  /dev/sdb		      0
	   0 CLOSED  ORCL:CRS4		      0
	   0 CLOSED  /dev/sda2		      0
	   0 CLOSED  /dev/sdf		      0
	   0 CLOSED  /dev/sdd		      0
	   0 CLOSED  /dev/sda1		      0
	   0 CLOSED  /dev/sde		      0
   	   0 CLOSED  /dev/sdc		      0
   
# diskgroup CRS에 CRS4 디스크 추가
+ASM1> alter diskgroup CRS add disk 'ORCL:CRS4' ;

Diskgroup altered.

 

상태 조회

# DISK 상태 조회
+ASM1> select group_number, disk_number, name, mount_status, path, total_mb
from v$asm_disk;

# CRS4 추가된 것 확인 가능
GROUP_NUMBER DISK_NUMBER NAME				MOUNT_S PATH		  TOTAL_MB
------------ ----------- ------------------------------ ------- --------------- ---------
	   1	       0 CRS1				CACHED	ORCL:CRS1	      3071
	   1	       1 CRS2				CACHED	ORCL:CRS2	      3071
	   1	       2 CRS3				CACHED	ORCL:CRS3	      3071
	   1	       3 CRS4				CACHED	ORCL:CRS4	     30719
	   2	       0 DATA				CACHED	ORCL:DATA	     51199
	   3	       0 FRA				CACHED	ORCL:FRA	     30719

# GROUP 상태 조회
col name for a10
col compatibility for a20
SELECT GROUP_NUMBER,  NAME, TYPE, TOTAL_MB/1024 TOTAL_GB, FREE_MB/1024 FREE_GB, COMPATIBILITY 
FROM V$ASM_DISKGROUP;
 

GROUP_NUMBER NAME	TYPE	 TOTAL_GB    FREE_GB COMPATIBILITY
------------ ---------- ------ ---------- ---------- --------------------
	   3 FRA	EXTERN 29.9990234 29.6757813 12.1.0.0.0
	   2 DATA	EXTERN 49.9990234 47.7617188 12.1.0.0.0
	   1 CRS	EXTERN 38.9960938 34.6054688 12.1.0.0.0

CRS DISKGROUP이 9기가에서 39로 늘어남 !