ASMLIB to AFD(ASM Filter Driver) 마이그레이션 (ASM SINGLE)

 

ASMLIB 보다 AFD를 권장(12.1.0.2 이후 버전) - Oracle AFD는 Oracle Grid와 함께 제공되므로 추가 다운로드 불필요하다. ASMLIB(oracleasm 구성)와 같이 초기 구성을 수행할 필요 없음 - 하나의 노드에 디스크를 추가 후 다른 노드에서 디스크를 스캔할 필요가 없음(oracleasm scandisks 불필요)

 

ASMLIB 로 구성되어 있는 ASM DISK를 AFD로 마이그레이션 테스트

-- asmlib 디스크 확인
[root@svr1 ~]# oracleasm listdisks
DATA
[root@svr1 ~]# oracleasm querydisk -p DATA
Disk "DATA" is a valid ASM disk
/dev/sdb1: LABEL="DATA" TYPE="oracleasm" 

-- AFD 확인
[root@svr1 ~]# su - grid
[grid@svr1 ~]$ asmcmd afd_state
ASMCMD-9530: The AFD state is 'NOT SUPPORTED'

-- asm disk 경로 확인
[grid@svr1 ~]$ asmcmd dsget
parameter:/dev/oracleasm/disks/*
profile:/dev/oracleasm/disks/*

-- asm disk 경로 추가
[grid@svr1 ~]$ asmcmd dsset '/dev/oracleasm/disks/*','AFD:*'
[grid@svr1 ~]$ asmcmd dsget
parameter:/dev/oracleasm/disks/*, AFD:*
profile:/dev/oracleasm/disks/*,AFD:*

SQL> show parameter string

NAME				     TYPE			       VALUE
------------------------------------ --------------------------------- ------------------------------
asm_diskstring			     string			       /dev/oracleasm/disks/*, AFD:*

-- grid stop
[root@svr1 ~]# crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'svr1'
CRS-2673: Attempting to stop 'ora.asmora.db' on 'svr1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'svr1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'svr1' succeeded
CRS-2677: Stop of 'ora.asmora.db' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'svr1'
CRS-2677: Stop of 'ora.DATA.dg' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'svr1'
CRS-2677: Stop of 'ora.asm' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'svr1'
CRS-2677: Stop of 'ora.evmd' on 'svr1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'svr1'
CRS-2677: Stop of 'ora.cssd' on 'svr1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'svr1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

-- asmlib unload
[root@svr1 ~]# oracleasm exit
Unmounting ASMlib driver filesystem: /dev/oracleasm
Unloading module "oracleasm": oracleasm


-- acsf stop ##acsf 사용 시
[root@svr1 ~]# acfsload stop

-- afd 구성
[root@svr1 ~]# asmcmd afd_configure
AFD-627: AFD distribution files found.
AFD-634: Removing previous AFD installation.
AFD-635: Previous AFD components successfully removed.
AFD-9294: updating file /etc/sysconfig/oracledrivers.conf
AFD-636: Installing requested AFD software.
AFD-637: Loading installed AFD drivers.
AFD-9321: Creating udev for AFD.
AFD-9323: Creating module dependencies - this may take some time.
AFD-9154: Loading 'oracleafd.ko' driver.
AFD-649: Verifying AFD devices.
AFD-9156: Detecting control device '/dev/oracleafd/admin'.
AFD-638: AFD installation correctness verified.
Modifying resource dependencies - this may take some time.

-- afd 상태 확인
[root@svr1 ~]# asmcmd afd_state
ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'ENABLED' on host 'svr1'

-- 12.1.0.2 이후 버전은 configure 과정에서 진행하므로 아래 단계 에러 발생
[root@svr1 ~]# asmcmd afd_label DATA /dev/sdb1
label name DATA is already in use
ASMCMD-9513: ASM disk label set operation failed.

-- asmfd disk 조회
[root@svr1 ~]# asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label                     Filtering   Path
================================================================================
DATA                        ENABLED   /dev/sdb1
[root@svr1 ~]# ls -l /dev/oracleafd/disks/
total 4
-rw-rw-r-- 1 grid oinstall 10 Jun  8 15:53 DATA

-- acsf start ##acsf 사용 시
[root@svr1 ~]# acfsload start
ACFS-9391: Checking for existing ADVM/ACFS installation.
ACFS-9392: Validating ADVM/ACFS installation files for operating system.
ACFS-9393: Verifying ASM Administrator setup.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9154: Loading 'oracleoks.ko' driver.
ACFS-9154: Loading 'oracleadvm.ko' driver.
ACFS-9154: Loading 'oracleacfs.ko' driver.
Use of uninitialized value $storage_mode in string ne at /ORA19/app/grid_base/grid/lib/osds_acfslib.pm line 1175.
ACFS-9325:     Driver OS kernel version = 4.1.12-112.16.4.el7uek.x86_64.
ACFS-9326:     Driver build number = 190222.
ACFS-9212:     Driver build version = 19.0.0.0.0 (19.3.0.0.0).
ACFS-9547:     Driver available build number = 190222.
ACFS-9548:     Driver available build version = 19.0.0.0.0 (19.3.0.0.0).
ACFS-9549:     Kernel and command versions.
Kernel:
    Build version: 19.0.0.0.0
    Build full version: 19.3.0.0.0
    Build hash:    9256567290
    Bug numbers:   NoTransactionInformation
Commands:
    Build version: 19.0.0.0.0
    Build full version: 19.3.0.0.0
    Build hash:    9256567290
    Bug numbers:   NoTransactionInformation
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
ACFS-9156: Detecting control device '/dev/ofsctl'.
ACFS-9294: updating file /etc/sysconfig/oracledrivers.conf
ACFS-9322: completed

-- grid start
[root@svr1 ~]# crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@svr1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       svr1                     STABLE
ora.LISTENER.lsnr
               ONLINE  INTERMEDIATE svr1                     Not All Endpoints Re
                                                             gistered,STABLE
ora.asm
               ONLINE  ONLINE       svr1                     Started,STABLE
ora.ons
               OFFLINE OFFLINE      svr1                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asmora.db
      1        ONLINE  ONLINE       svr1                     Open,HOME=/ORA19/app
                                                             /oracle/product/19.0
                                                             .0/db_1,STABLE
ora.cssd
      1        ONLINE  ONLINE       svr1                     STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.driver.afd
      1        ONLINE  ONLINE       svr1                     STABLE
ora.evmd
      1        ONLINE  ONLINE       svr1                     STABLE
--------------------------------------------------------------------------------


[root@svr1 ~]# su - grid
Last login: Wed Jun  8 16:12:31 KST 2022
[grid@svr1 ~]$ asmcmd dsget
parameter:/dev/oracleasm/disks/*, AFD:*
profile:/dev/oracleasm/disks/*,AFD:*

-- asmlib에서 사용했던 asm disk 경로 삭제
[grid@svr1 ~]$ asmcmd dsset 'AFD:*'
[grid@svr1 ~]$ asmcmd dsget
parameter:AFD:*
profile:AFD:*
[grid@svr1 ~]$