ASM 구성

ASM 인스턴스 및 디스크 그룹 생성

grid_env
asmca -silent -configureASM -sysAsmPassword <SYSASM 암호> -asmsnmpPassword <ASMSNMP 암호> -diskString 'ORCL:*' -diskGroupName CRS -diskList 'ORCL:CRS1,ORCL:CRS2,ORCL:CRS3' -redundancy NORMAL



[racdb1:/home/oracle]> grid_env

[+ASM1:/home/oracle]> asmca -silent -configureASM -sysAsmPassword oracle_4U -asmsnmpPassword oracle_4U -diskString 'ORCL:*' -diskGroupName CRS -diskList 'ORCL:CRS1,ORCL:CRS2,ORCL:CRS3' -redundancy NORMAL

ASM이 성공적으로 생성되고 시작되었습니다.

디스크 그룹 CRS이(가) 성공적으로 생성되었습니다.

[root@rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.asm
               ONLINE  ONLINE       rac1                     Started
               ONLINE  ONLINE       rac2                     Started
ora.gsd
               OFFLINE OFFLINE      rac1
               OFFLINE OFFLINE      rac2
ora.net1.network
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.ons
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac1
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac1
ora.cvu
      1        ONLINE  ONLINE       rac1
ora.oc4j
      1        ONLINE  ONLINE       rac1
ora.rac1.vip
      1        ONLINE  ONLINE       rac1
ora.rac2.vip
      1        ONLINE  ONLINE       rac2
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open
      2        ONLINE  ONLINE       rac2                     Open
ora.scan1.vip
      1        ONLINE  ONLINE       rac2
ora.scan2.vip
      1        ONLINE  ONLINE       rac1
ora.scan3.vip
      1        ONLINE  ONLINE       rac1





asmca -silent -createDiskGroup -diskString 'ORCL:*' -diskGroupName DATA -disk 'ORCL:DATA' -redundancy EXTERNAL
asmca -silent -createDiskGroup -diskString 'ORCL:*' -diskGroupName FRA -disk 'ORCL:FRA' -redundancy EXTERNAL



[+ASM1:/home/oracle]> asmca -silent -createDiskGroup -diskString 'ORCL:*' -diskGroupName DATA -disk 'ORCL:DATA' -redundancy EXTERNAL

디스크 그룹 DATA이(가) 성공적으로 생성되었습니다.

[+ASM1:/home/oracle]> asmca -silent -createDiskGroup -diskString 'ORCL:*' -diskGroupName FRA -disk 'ORCL:FRA' -redundancy EXTERNAL

디스크 그룹 FRA이(가) 성공적으로 생성되었습니다.

[root@rac2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.DATA.dg
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.FRA.dg
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.asm
               ONLINE  ONLINE       rac1                     Started
               ONLINE  ONLINE       rac2                     Started
ora.gsd
               OFFLINE OFFLINE      rac1
               OFFLINE OFFLINE      rac2
ora.net1.network
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.ons
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac1
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac1
ora.cvu
      1        ONLINE  ONLINE       rac1
ora.oc4j
      1        ONLINE  ONLINE       rac1
ora.rac1.vip
      1        ONLINE  ONLINE       rac1
ora.rac2.vip
      1        ONLINE  ONLINE       rac2
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open
      2        ONLINE  ONLINE       rac2                     Open
ora.scan1.vip
      1        ONLINE  ONLINE       rac2
ora.scan2.vip
      1        ONLINE  ONLINE       rac1
ora.scan3.vip
      1        ONLINE  ONLINE       rac1




CRS 및 Vote 영역 ASM으로 이관

ocrconfig -add +CRS
ocrconfig -delete /dev/raw/raw1
ocrconfig -delete /dev/raw/raw2
ocrcheck



[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3020
         Available space (kbytes) :     259100
         ID                       :  934357259
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded
         Device/File Name         : /dev/raw/raw2
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check succeeded

[root@rac1 ~]# ocrconfig -add +CRS

[root@rac1 ~]# ocrconfig -delete /dev/raw/raw1

[root@rac1 ~]# ocrconfig -delete /dev/raw/raw2

[root@rac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3020
         Available space (kbytes) :     259100
         ID                       :  934357259
         Device/File Name         :       +CRS
                                    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





crsctl replace votedisk +CRS
crsctl query css votedisk



[root@rac1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   a4c3ccb126b64f4dbf3d89ae84d163a2 (/dev/raw/raw3) []
 2. ONLINE   31693ea2d7774f83bfd26b71d8173078 (/dev/raw/raw4) []
 3. ONLINE   7527b0194b634f7abfbc3c3501a8a6f4 (/dev/raw/raw5) []
Located 3 voting disk(s).

[root@rac1 ~]# crsctl replace votedisk +CRS
CRS-4256: Updating the profile
Successful addition of voting disk d10cbc0b84bb4fa1bf868c98b6cb9463.
Successful addition of voting disk 6d485ec847b34f48bf3cd1462e0ba114.
Successful addition of voting disk e42528b7cab34f88bf51951976a27e4a.
Successful deletion of voting disk a4c3ccb126b64f4dbf3d89ae84d163a2.
Successful deletion of voting disk 31693ea2d7774f83bfd26b71d8173078.
Successful deletion of voting disk 7527b0194b634f7abfbc3c3501a8a6f4.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced

[root@rac1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   d10cbc0b84bb4fa1bf868c98b6cb9463 (ORCL:CRS1) [CRS]
 2. ONLINE   6d485ec847b34f48bf3cd1462e0ba114 (ORCL:CRS2) [CRS]
 3. ONLINE   e42528b7cab34f88bf51951976a27e4a (ORCL:CRS3) [CRS]
Located 3 voting disk(s).




ASM 호환성 변경

asmcmd setattr -G CRS compatible.asm 11.2.0.2.0
asmcmd setattr -G DATA compatible.asm 11.2.0.2.0
asmcmd setattr -G FRA compatible.asm 11.2.0.2.0
asmcmd lsattr -G CRS -lm compatible.asm
asmcmd lsattr -G DATA -lm compatible.asm
asmcmd lsattr -G FRA -lm compatible.asm



[+ASM1:/home/oracle]> asmcmd lsattr -G CRS -lm compatible.asm
Group_Name  Name            Value       RO  Sys
CRS         compatible.asm  11.2.0.0.0  N   Y

[+ASM1:/home/oracle]> asmcmd lsattr -G DATA -lm compatible.asm
Group_Name  Name            Value       RO  Sys
DATA        compatible.asm  11.2.0.0.0  N   Y

[+ASM1:/home/oracle]> asmcmd lsattr -G FRA -lm compatible.asm
Group_Name  Name            Value       RO  Sys
FRA         compatible.asm  11.2.0.0.0  N   Y

[+ASM1:/home/oracle]> asmcmd setattr -G CRS compatible.asm 11.2.0.2.0
[+ASM1:/home/oracle]> asmcmd setattr -G DATA compatible.asm 11.2.0.2.0
[+ASM1:/home/oracle]> asmcmd setattr -G FRA compatible.asm 11.2.0.2.0

[+ASM1:/home/oracle]> asmcmd lsattr -G CRS -lm compatible.asm
Group_Name  Name            Value       RO  Sys
CRS         compatible.asm  11.2.0.2.0  N   Y

[+ASM1:/home/oracle]> asmcmd lsattr -G DATA -lm compatible.asm
Group_Name  Name            Value       RO  Sys
DATA        compatible.asm  11.2.0.2.0  N   Y

[+ASM1:/home/oracle]> asmcmd lsattr -G FRA -lm compatible.asm
Group_Name  Name            Value       RO  Sys
FRA         compatible.asm  11.2.0.2.0  N   Y



11g R2의 ASM을 19c로 업그레이드 하기 위해서는 ASM의 최소 호환성은 11.2.0.2 이상이어야 합니다.

ASM으로 Database 이관