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

1. Virtual Box에서 disk 생성 및 추가 (머신 끄고 진행)

원하는 경로와 크기를 설정 후 만들기 // ASM 공유 디스크는 고정크기로 할당

반드시 공유 가능인지 확인할 것.

방금 등록한 FRA3.vdi 추가 << RAC 노드 모두 >>

2. 쉘 접속하여 파티션 등록 , ASM DISK 동기화

ls -al /dev/sd*

sdh는 아직 파티션 안됨 확인

fdisk /dev/sdh

n p 1 enter enter w

ls -al /dev/sd* → sdh1 생겼을 것

chown oracle:dba /dev/sd*

3. ASMFD 라벨 설정

현재 라벨 상태 확인

[RAC1|root:/root]> export ORACLE_HOME=$GRID_HOME
[RAC1|root:/root]> cd $ORACLE_HOME/bin
[RAC1|root:/u01/app/19.0.0.0/grid/bin]> 
[RAC1|root:/u01/app/19.0.0.0/grid/bin]> ./asmcmd afd_lslbl
--------------------------------------------------------------------------------
Label                     Duplicate  Path
================================================================================
CRS1                                  /dev/sdb1
CRS2                                  /dev/sdc1
CRS3                                  /dev/sdd1
DATA                                  /dev/sde1
FRA                                   /dev/sdf1
FRA2                                  /dev/sdg1

sdh1 disk label 설정

[RAC1|root:/u01/app/19.0.0.0/grid/bin]> ./asmcmd afd_label FRA3 /dev/sdh1
[RAC1|root:/u01/app/19.0.0.0/grid/bin]> ./asmcmd afd_lslbl
--------------------------------------------------------------------------------
Label                     Duplicate  Path
================================================================================
CRS1                                  /dev/sdb1
CRS2                                  /dev/sdc1
CRS3                                  /dev/sdd1
DATA                                  /dev/sde1
FRA                                   /dev/sdf1
FRA2                                  /dev/sdg1
FRA3                                  /dev/sdh1

<< 참조 >> 라벨링 지우는 커맨드

./asmcmd afd_unlabel '/dev/sdh1' -f --init

 

[RAC1|oracle:/home/oracle]> ls -al /dev/oracleafd/disks
total 28
drwxrwx---. 2 oracle dba 180 Feb  3 01:47 .
drwxrwx---. 3 oracle dba  80 Feb  3 01:31 ..
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:31 CRS1
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:31 CRS2
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:31 CRS3
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:31 DATA
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:31 FRA
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:31 FRA2
-rw-rw-r--. 1 oracle dba  10 Feb  3 01:47 FRA3

 

4. ASMCA 접속하여 디스크 추가

- asmca 실행 전 crs가 띄워져 있는지 확인할 것 (crsctl stat res -t)

su - oracle
[RAC1|oracle:/home/oracle]> export DISPLAY=[GUI 띄울 IP]:0.0
[RAC1|oracle:/home/oracle]> asmca

기다리기 .. -끝-

 

5. sql plus 접속하여 ASM DISK GROUP 상태 확인

SELECT GROUP_NUMBER NO,
       NAME,
       TOTAL_MB/1024 TOTAL_GB,
       ROUND((TOTAL_MB - USABLE_FILE_MB)/1024,2) USED_GB,
       USABLE_FILE_MB/1024 USABLE_FILE_GB,    
       FREE_MB/1024 FREE_GB,
       100-ROUND(FREE_MB/TOTAL_MB*100) "USGAE(%)",
       ((FREE_MB - REQUIRED_MIRROR_FREE_MB))/1024 USABLE_CALC_GB,
       TYPE, 
       STATE
FROM V$ASM_DISKGROUP;

SELECT B.NAME AS GROUP_NAME,
       A.NAME AS DISK_NAME,
       A.PATH,
       B.TYPE,
       B.STATE,
       A.FREE_MB/1024 FREE_GB
FROM V$ASM_DISK A, V$ASM_DISKGROUP B
WHERE A.GROUP_NUMBER = B.GROUP_NUMBER 
ORDER BY 1, 2;

6. FRA 크기 늘리기

현재 사용중인 FRA 크기 조회

SQL> show parameter db_recovery_file_dest_size ;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size	     big integer 5G

 

남은 용량 확인

.. 210MB 남음

SQL> set linesize 200
col name for a40
col space_limit_MB for 999,999,999
col space_used_MB for 999,999,999
col space_reclaimable_MB for 999,999,999
col number_of_files for 999,999,999
select name,
       round(space_limit/1024/1024) as space_limit_MB,
       round(space_used/1024/1024) as space_used_MB,
       round(space_reclaimable/1024/1024) as space_reclaimable_MB,
       number_of_files,
       con_id
from v$recovery_file_dest;


NAME					 SPACE_LIMIT_MB SPACE_USED_MB SPACE_RECLAIMABLE_MB NUMBER_OF_FILES     CON_ID
---------------------------------------- -------------- ------------- -------------------- --------------- ----------
+FRA						  5,120 	  210			 0		13	    0

증축 가즈아

alter system set db_recovery_file_dest_size=10G scope=both sid='*' ;

SQL> alter system set db_recovery_file_dest_size=10G scope=both sid='*' ;

System altered.

SQL> show parameter db_recovery_file_dest_size ;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size	     big integer 10G


SQL> select name,
       round(space_limit/1024/1024) as space_limit_MB,
       round(space_used/1024/1024) as space_used_MB,
       round(space_reclaimable/1024/1024) as space_reclaimable_MB,
       number_of_files,
       con_id
from v$recovery_file_dest;

NAME					 SPACE_LIMIT_MB SPACE_USED_MB SPACE_RECLAIMABLE_MB NUMBER_OF_FILES     CON_ID
---------------------------------------- -------------- ------------- -------------------- --------------- ----------
+FRA						 10,240 	  210			 0		13	    0