본문 바로가기
DBMS/ORACLE

ASM DISK 추가/삭제 성능 테스트(신규추가, 기존삭제)

by 드바 2023. 10. 26.
오라클 버추얼박스
OS : oracle linux 7.5
DBMS : oracle 19.3
GRID : 19.3

 

테스트 시나리오
- 현재 10GB의 ASM DISK로 구성되어 있다
- 신규 DISK 추가 하고 기존 DISK를 제거하는 2가지 방법에 대한 테스트 이다
- 테스트는 여러번 진행 하였고 결과에 큰 차이는 없었음
방법1 : add disk -> rebalance -> drop disk -> rebalance (add 29초 + drop 23초)
방법2 : add disk / drop disk 동시 수행 -> rebalance (37초) 

 

방법 1

기존 10GB 디스크그룹에 신규 디스크(DATA02) 추가

총 10GB -> 20GB으로 10GB 짜리 2개에 각각 5GB 사용됨

SQL> select group_number, disk_number, name, mount_status, header_status, state, path, os_mb, total_mb, cold_used_mb, free_mb
from v$asm_disk
WHERE 1=1
order by 1,3 ;

GROUP_NUMBER DISK_NUMBER NAME		      MOUNT_STATUS	    HEADER_STATUS	 STATE		      PATH			OS_MB	TOTAL_MB COLD_USED_MB	 FREE_MB
------------ ----------- -------------------- --------------------- -------------------- -------------------- -------------------- ---------- ---------- ------------ ----------
	   0	       0		      CLOSED		    FORMER		 NORMAL 	      AFD:DATA02		10239	       0	    0	       0
	   1	       0 DATA		      CACHED		    MEMBER		 NORMAL 	      AFD:DATA			10239	   10236	10004	     232

SQL> alter diskgroup DATA add disk 'AFD:DATA02' ;

Diskgroup altered.

SQL> select group_number, disk_number, name, mount_status, header_status, state, path, os_mb, total_mb, cold_used_mb, free_mb
from v$asm_disk
WHERE 1=1
order by 1,3 ;

GROUP_NUMBER DISK_NUMBER NAME		      MOUNT_STATUS	    HEADER_STATUS	 STATE		      PATH			OS_MB	TOTAL_MB COLD_USED_MB	 FREE_MB
------------ ----------- -------------------- --------------------- -------------------- -------------------- -------------------- ---------- ---------- ------------ ----------
	   1	       0 DATA		      CACHED		    MEMBER		 NORMAL 	      AFD:DATA			10239	   10236	 5016	    5220
	   1	       1 DATA02 	      CACHED		    MEMBER		 NORMAL 	      AFD:DATA02		10239	   10236	 5000	    5236

SQL>

 

시작 : 2023-10-26T11:22:10.498237+09:00
종료 : 2023-10-26T11:22:39.572110+09:00
add disk : 29초
더보기 
2023-10-26T11:22:10.498237+09:00
SQL> alter diskgroup DATA add disk 'AFD:DATA02'  
2023-10-26T11:22:10.561247+09:00
NOTE: Assigning number (1,1) to disk (AFD:DATA02)
NOTE: requesting all-instance membership refresh for group=1
NOTE: Disk 1 in group 1 is assigned fgnum=2
NOTE: discarding redo for group 1 disk 1
NOTE: initializing header (replicated) on grp 1 disk DATA02
NOTE: initializing header on grp 1 disk DATA02
NOTE: requesting all-instance disk validation for group=1
2023-10-26T11:22:10.662338+09:00
NOTE: skipping rediscovery for group 1/0x4213138a (DATA) on local instance.
2023-10-26T11:22:10.663474+09:00
NOTE: requesting all-instance disk validation for group=1
2023-10-26T11:22:10.663525+09:00
NOTE: skipping rediscovery for group 1/0x4213138a (DATA) on local instance.
2023-10-26T11:22:10.663928+09:00
GMON updating for reconfiguration, group 1 at 43 for pid 24, osid 9530
2023-10-26T11:22:10.664483+09:00
NOTE: group 1 PST updated.
2023-10-26T11:22:10.664956+09:00
NOTE: membership refresh pending for group 1/0x4213138a (DATA)
2023-10-26T11:22:10.665494+09:00
GMON querying group 1 at 44 for pid 19, osid 8509
NOTE: cache opening disk 1 of grp 1: DATA02 label:DATA02
GMON querying group 1 at 45 for pid 19, osid 8509
2023-10-26T11:22:10.723201+09:00
SUCCESS: refreshed membership for 1/0x4213138a (DATA)
2023-10-26T11:22:10.723457+09:00
SUCCESS: alter diskgroup DATA add disk 'AFD:DATA02' 
2023-10-26T11:22:12.545583+09:00
NOTE: Attempting voting file refresh on diskgroup DATA
2023-10-26T11:22:12.550301+09:00
NOTE: starting rebalance of group 1/0x4213138a (DATA) at power 1
NOTE: starting process ARBA
Starting background process ARBA
NOTE: starting process ARB0
2023-10-26T11:22:12.555549+09:00
ARBA started with pid=26, OS id=16769 
Starting background process ARB0
2023-10-26T11:22:12.560202+09:00
ARB0 started with pid=28, OS id=16771 
NOTE: assigning ARBA to group 1/0x4213138a (DATA) to compute estimates
NOTE: assigning ARB0 to group 1/0x4213138a (DATA) with 1 parallel I/O
2023-10-26T11:22:33.558807+09:00
NOTE: Starting expel slave for group 1/0x4213138a (DATA)
2023-10-26T11:22:33.558886+09:00
NOTE: requesting all-instance membership refresh for group=1
2023-10-26T11:22:33.559062+09:00
NOTE: membership refresh pending for group 1/0x4213138a (DATA)
2023-10-26T11:22:33.562904+09:00
GMON querying group 1 at 46 for pid 19, osid 8509
2023-10-26T11:22:33.563253+09:00
SUCCESS: refreshed membership for 1/0x4213138a (DATA)
2023-10-26T11:22:36.570898+09:00
NOTE: Attempting voting file refresh on diskgroup DATA
2023-10-26T11:22:38.252219+09:00
NOTE: stopping process ARB0
NOTE: stopping process ARBA
2023-10-26T11:22:39.572110+09:00
SUCCESS: rebalance completed for group 1/0x4213138a (DATA)

기존에 있던 디스크(DATA) 제거 총 20GB -> 10GB

SQL> select group_number, disk_number, name, mount_status, header_status, state, path, os_mb, total_mb, cold_used_mb, free_mb
from v$asm_disk
WHERE 1=1
order by 1,3 ;  

GROUP_NUMBER DISK_NUMBER NAME		      MOUNT_STATUS	    HEADER_STATUS	 STATE		      PATH			OS_MB	TOTAL_MB COLD_USED_MB	 FREE_MB
------------ ----------- -------------------- --------------------- -------------------- -------------------- -------------------- ---------- ---------- ------------ ----------
	   1	       0 DATA		      CACHED		    MEMBER		 NORMAL 	      AFD:DATA			10239	   10236	 5016	    5220
	   1	       1 DATA02 	      CACHED		    MEMBER		 NORMAL 	      AFD:DATA02		10239	   10236	 5000	    5236

SQL> alter diskgroup DATA drop disk 'DATA' ;

Diskgroup altered.

SQL> select group_number, disk_number, name, mount_status, header_status, state, path, os_mb, total_mb, cold_used_mb, free_mb
from v$asm_disk
WHERE 1=1
order by 1,3 ;  

GROUP_NUMBER DISK_NUMBER NAME		      MOUNT_STATUS	    HEADER_STATUS	 STATE		      PATH			OS_MB	TOTAL_MB COLD_USED_MB	 FREE_MB
------------ ----------- -------------------- --------------------- -------------------- -------------------- -------------------- ---------- ---------- ------------ ----------
	   0	       0		      CLOSED		    FORMER		 NORMAL 	      AFD:DATA			10239	       0	    0	       0
	   1	       1 DATA02 	      CACHED		    MEMBER		 NORMAL 	      AFD:DATA02		10239	   10236	10004	     232

SQL>

 

시작 : 2023-10-26T11:24:58.576049+09:00
종료 : 2023-10-26T11:25:21.653321+09:00
drop disk : 23초
더보기 
2023-10-26T11:24:58.576049+09:00
SQL> alter diskgroup DATA drop disk 'DATA'  
2023-10-26T11:24:58.576471+09:00
NOTE: requesting all-instance membership refresh for group=1
2023-10-26T11:24:58.577075+09:00
NOTE: membership refresh pending for group 1/0x4213138a (DATA)
2023-10-26T11:24:58.577767+09:00
GMON querying group 1 at 47 for pid 19, osid 8509
2023-10-26T11:24:58.578047+09:00
SUCCESS: refreshed membership for 1/0x4213138a (DATA)
2023-10-26T11:24:58.578254+09:00
SUCCESS: alter diskgroup DATA drop disk 'DATA' 
2023-10-26T11:25:00.594199+09:00
NOTE: Attempting voting file refresh on diskgroup DATA
2023-10-26T11:25:00.644118+09:00
NOTE: starting rebalance of group 1/0x4213138a (DATA) at power 1
NOTE: starting process ARBA
Starting background process ARBA
2023-10-26T11:25:00.649449+09:00
ARBA started with pid=27, OS id=17161 
NOTE: starting process ARB0
Starting background process ARB0
2023-10-26T11:25:00.654155+09:00
ARB0 started with pid=28, OS id=17163 
NOTE: assigning ARBA to group 1/0x4213138a (DATA) to compute estimates
NOTE: assigning ARB0 to group 1/0x4213138a (DATA) with 1 parallel I/O
2023-10-26T11:25:00.721876+09:00
NOTE: F1X0 on disk 0 (fmt 2) relocated at fcn 0.33223: AU 10 -> AU 0
NOTE: header on disk 1 advanced to format #2 using fcn 0.0
NOTE: F1X0 on disk 1 (fmt 2) relocated at fcn 0.33223: AU 0 -> AU 1250
NOTE: 10/26/23 11:25:00 DATA.F1X0 copy 1 relocating from 0:10 to 1:1250 at FCN 0.33223
2023-10-26T11:25:18.700244+09:00
NOTE: stopping process ARB0
NOTE: stopping process ARBA
NOTE: Starting expel slave for group 1/0x4213138a (DATA)
2023-10-26T11:25:18.706523+09:00
NOTE: requesting all-instance membership refresh for group=1
2023-10-26T11:25:18.710473+09:00
GMON updating for reconfiguration, group 1 at 48 for pid 31, osid 16350
2023-10-26T11:25:18.710829+09:00
NOTE: group 1 PST updated.
SUCCESS: grp 1 disk DATA emptied
NOTE: process _x000_+asm (16350) initiating offline of disk 0.4042515333 (DATA) with mask 0x7e in group 1 (DATA) without client assisting
NOTE: initiating PST update: grp 1 (DATA), dsk = 0/0xf0f3e385, mask = 0x6a, op = clear mandatory
2023-10-26T11:25:18.864800+09:00
GMON updating disk modes for group 1 at 49 for pid 31, osid 16350
NOTE: group DATA: updated PST location: disks 0001 
2023-10-26T11:25:18.866052+09:00
NOTE: PST update grp = 1 completed successfully 
NOTE: initiating PST update: grp 1 (DATA), dsk = 0/0xf0f3e385, mask = 0x7e, op = clear mandatory
2023-10-26T11:25:18.866222+09:00
GMON updating disk modes for group 1 at 50 for pid 31, osid 16350
2023-10-26T11:25:18.866707+09:00
NOTE: cache closing disk 0 of grp 1: DATA
2023-10-26T11:25:18.867325+09:00
NOTE: cache closing disk 0 of grp 1: (not open) DATA
2023-10-26T11:25:18.867436+09:00
NOTE: PST update grp = 1 completed successfully 
2023-10-26T11:25:18.867571+09:00
GMON updating for reconfiguration, group 1 at 51 for pid 31, osid 16350
2023-10-26T11:25:18.867657+09:00
NOTE: cache closing disk 0 of grp 1: (not open) DATA
2023-10-26T11:25:18.868409+09:00
NOTE: group 1 PST updated.
NOTE: grp 1 disk 0 expelled from the PST.
NOTE: Erasing header on AFD:DATA
2023-10-26T11:25:18.949328+09:00
NOTE: membership refresh pending for group 1/0x4213138a (DATA)
2023-10-26T11:25:18.949919+09:00
GMON querying group 1 at 52 for pid 19, osid 8509
GMON querying group 1 at 53 for pid 19, osid 8509
2023-10-26T11:25:18.950490+09:00
NOTE: Disk DATA in mode 0x0 marked for de-assignment
SUCCESS: refreshed membership for 1/0x4213138a (DATA)
2023-10-26T11:25:21.653321+09:00
SUCCESS: rebalance completed for group 1/0x4213138a (DATA)
NOTE: Attempting voting file refresh on diskgroup DATA

 

방법 2

기존 10GB 디스크그룹에 신규 디스크(DATA) 추가 및 기존 디스크(DATA02) 제거 동시 진행

SQL> select group_number, disk_number, name, mount_status, header_status, state, path, os_mb, total_mb, cold_used_mb, free_mb
from v$asm_disk
WHERE 1=1
order by 1,3 ;

GROUP_NUMBER DISK_NUMBER NAME		      MOUNT_STATUS	    HEADER_STATUS	 STATE		      PATH			OS_MB	TOTAL_MB COLD_USED_MB	 FREE_MB
------------ ----------- -------------------- --------------------- -------------------- -------------------- -------------------- ---------- ---------- ------------ ----------
	   0	       0		      CLOSED		    FORMER		 NORMAL 	      AFD:DATA			10239	       0	    0	       0
	   1	       1 DATA02 	      CACHED		    MEMBER		 NORMAL 	      AFD:DATA02		10239	   10236	10004	     232

SQL> alter diskgroup DATA add disk 'AFD:DATA' drop disk 'DATA02' ;

Diskgroup altered.

SQL> select group_number, disk_number, name, mount_status, header_status, state, path, os_mb, total_mb, cold_used_mb, free_mb
from v$asm_disk
WHERE 1=1
order by 1,3 ;  

GROUP_NUMBER DISK_NUMBER NAME		      MOUNT_STATUS	    HEADER_STATUS	 STATE		      PATH			OS_MB	TOTAL_MB COLD_USED_MB	 FREE_MB
------------ ----------- -------------------- --------------------- -------------------- -------------------- -------------------- ---------- ---------- ------------ ----------
	   0	       0		      CLOSED		    FORMER		 NORMAL 	      AFD:DATA02		10239	       0	    0	       0
	   1	       0 DATA		      CACHED		    MEMBER		 NORMAL 	      AFD:DATA			10239	   10236	10004	     232

SQL>

 

시작 : 2023-10-26T11:29:08.493509+09:00
종료 : 2023-10-26T11:29:45.722427+09:00
add disk / drop disk : 37초
더보기 
2023-10-26T11:29:08.493509+09:00
SQL> alter diskgroup DATA add disk 'AFD:DATA' drop disk 'DATA02'  
2023-10-26T11:29:08.571837+09:00
NOTE: Assigning number (1,0) to disk (AFD:DATA)
NOTE: requesting all-instance membership refresh for group=1
NOTE: Disk 0 in group 1 is assigned fgnum=1
NOTE: discarding redo for group 1 disk 0
NOTE: initializing header (replicated) on grp 1 disk DATA
NOTE: initializing header on grp 1 disk DATA
NOTE: requesting all-instance disk validation for group=1
2023-10-26T11:29:08.680970+09:00
NOTE: skipping rediscovery for group 1/0x4213138a (DATA) on local instance.
2023-10-26T11:29:08.681730+09:00
NOTE: requesting all-instance disk validation for group=1
2023-10-26T11:29:08.681795+09:00
NOTE: skipping rediscovery for group 1/0x4213138a (DATA) on local instance.
2023-10-26T11:29:08.682308+09:00
GMON updating for reconfiguration, group 1 at 54 for pid 24, osid 9530
2023-10-26T11:29:08.683166+09:00
NOTE: group 1 PST updated.
2023-10-26T11:29:08.683580+09:00
NOTE: membership refresh pending for group 1/0x4213138a (DATA)
2023-10-26T11:29:08.684003+09:00
GMON querying group 1 at 55 for pid 19, osid 8509
NOTE: cache opening disk 0 of grp 1: DATA label:DATA
GMON querying group 1 at 56 for pid 19, osid 8509
2023-10-26T11:29:08.745080+09:00
SUCCESS: refreshed membership for 1/0x4213138a (DATA)
2023-10-26T11:29:08.745536+09:00
SUCCESS: alter diskgroup DATA add disk 'AFD:DATA' drop disk 'DATA02' 
2023-10-26T11:29:09.705520+09:00
NOTE: Attempting voting file refresh on diskgroup DATA
2023-10-26T11:29:09.710191+09:00
NOTE: starting rebalance of group 1/0x4213138a (DATA) at power 1
NOTE: starting process ARBA
Starting background process ARBA
2023-10-26T11:29:09.715859+09:00
ARBA started with pid=30, OS id=17652 
NOTE: starting process ARB0
Starting background process ARB0
2023-10-26T11:29:09.720627+09:00
ARB0 started with pid=32, OS id=17654 
NOTE: assigning ARBA to group 1/0x4213138a (DATA) to compute estimates
NOTE: assigning ARB0 to group 1/0x4213138a (DATA) with 1 parallel I/O
2023-10-26T11:29:09.852580+09:00
NOTE: header on disk 0 advanced to format #2 using fcn 0.0
NOTE: F1X0 on disk 0 (fmt 2) relocated at fcn 0.37008: AU 0 -> AU 10
NOTE: F1X0 on disk 1 (fmt 2) relocated at fcn 0.37008: AU 1250 -> AU 0
NOTE: 10/26/23 11:29:08 DATA.F1X0 copy 1 relocating from 1:1250 to 0:10 at FCN 0.37008
2023-10-26T11:29:43.379615+09:00
NOTE: stopping process ARB0
NOTE: stopping process ARBA
NOTE: Starting expel slave for group 1/0x4213138a (DATA)
2023-10-26T11:29:43.383410+09:00
NOTE: requesting all-instance membership refresh for group=1
2023-10-26T11:29:43.387198+09:00
GMON updating for reconfiguration, group 1 at 57 for pid 31, osid 16350
2023-10-26T11:29:43.387589+09:00
NOTE: group 1 PST updated.
SUCCESS: grp 1 disk DATA02 emptied
NOTE: process _x000_+asm (16350) initiating offline of disk 1.4042515335 (DATA02) with mask 0x7e in group 1 (DATA) without client assisting
NOTE: initiating PST update: grp 1 (DATA), dsk = 1/0xf0f3e387, mask = 0x6a, op = clear mandatory
2023-10-26T11:29:43.550383+09:00
GMON updating disk modes for group 1 at 58 for pid 31, osid 16350
NOTE: group DATA: updated PST location: disks 0000 
2023-10-26T11:29:43.551401+09:00
NOTE: PST update grp = 1 completed successfully 
NOTE: initiating PST update: grp 1 (DATA), dsk = 1/0xf0f3e387, mask = 0x7e, op = clear mandatory
2023-10-26T11:29:43.551588+09:00
GMON updating disk modes for group 1 at 59 for pid 31, osid 16350
2023-10-26T11:29:43.552071+09:00
NOTE: cache closing disk 1 of grp 1: DATA02
2023-10-26T11:29:43.552806+09:00
NOTE: cache closing disk 1 of grp 1: (not open) DATA02
2023-10-26T11:29:43.552892+09:00
NOTE: PST update grp = 1 completed successfully 
2023-10-26T11:29:43.553002+09:00
GMON updating for reconfiguration, group 1 at 60 for pid 31, osid 16350
2023-10-26T11:29:43.553093+09:00
NOTE: cache closing disk 1 of grp 1: (not open) DATA02
2023-10-26T11:29:43.553698+09:00
NOTE: group 1 PST updated.
NOTE: grp 1 disk 1 expelled from the PST.
NOTE: Erasing header on AFD:DATA02
2023-10-26T11:29:43.630724+09:00
NOTE: membership refresh pending for group 1/0x4213138a (DATA)
2023-10-26T11:29:43.631291+09:00
GMON querying group 1 at 61 for pid 19, osid 8509
GMON querying group 1 at 62 for pid 19, osid 8509
2023-10-26T11:29:43.631837+09:00
NOTE: Disk DATA02 in mode 0x0 marked for de-assignment
SUCCESS: refreshed membership for 1/0x4213138a (DATA)
2023-10-26T11:29:45.722427+09:00
SUCCESS: rebalance completed for group 1/0x4213138a (DATA)
NOTE: Attempting voting file refresh on diskgroup DATA

 

ASM DISK 추가/일시중지/재개 시 상태 변화

AFD disk 추가/삭제

ASM DISK 사이즈 다른 경우 DATAFILE 추가 테스트

'DBMS > ORACLE' 카테고리의 다른 글

oracle expdp 원격지(remote) 데이터 로컬로 가져오기  (0) 2023.12.01
ASM DISK 추가/일시중지/재개 시 상태 변화  (0) 2023.10.26
오라클 NTILE 함수 설명 및 사용법  (0) 2023.10.03
오라클 START WITH ... CONNECT BY(계층쿼리) 사용법  (0) 2023.09.15
오라클 EMP, DEPT 샘플 테이블 생성 스크립트  (0) 2023.09.15

관련글

댓글

티스토리툴바