1. ASM 구성
A) 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
{}
DATA 및 FRA 디스크 그룹 추가 생성
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
B) CRS 및 Vote 영역 ASM으로 이관
ASM으로 OCR 영역 이관
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
ASM으로 Vote 영역 이관
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).
C) ASM 호환성 변경
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 이상이어야 합니다.
