1. 디스크 파티션 작업
| 파티션명 | 파티션 크기 | 용도 |
|---|---|---|
| /dev/sdb1 | 15G | Raw Device 영역으로 세부 분할하여 사용 |
| /dev/sdb2 | 5G | OCFS2 영역으로 할당하여 Fast Recovery Area로 사용 (OCFS2를 이용한 공유 영역) |
A) 디스크 파티션 생성
root 유저로 수행
fdisk /dev/sdb
[root@rac1 ~]# ls /dev/sd*
/dev/sda /dev/sda1 /dev/sda2 /dev/sdb
[root@rac1 ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x71c49a77.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-2610, default 2610): +15G
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 2
First cylinder (1960-2610, default 1960):
Using default value 1960
Last cylinder, +cylinders or +size{K,M,G} (1960-2610, default 2610):
Using default value 2610
Command (m for help): p
Disk /dev/sdb: 21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x71c49a77
Device Boot Start End Blocks Id System
/dev/sdb1 1 1959 15735636 83 Linux
/dev/sdb2 1960 2610 5229157+ 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac1 ~]# ls /dev/sd*
/dev/sda /dev/sda1 /dev/sda2 /dev/sdb /dev/sdb1 /dev/sdb2
fdisk 명령어로 Raw Device로 사용할 디스크의 파티션을 생성합니다.
각 프롬프트에서 n → p → 1 → "엔터(기본값 1)" → "+15G" → n → p → 2 → "엔터(기본값 1960)" → "엔터(기본값 2610)" → p → w 를 입력하여 파티션 분할
B) 디스크 파티션 확인
root 유저로 수행
fdisk -l /dev/sdb
[root@rac1 ~]# fdisk -l /dev/sdb Disk /dev/sdb: 21.5 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x71c49a77 Device Boot Start End Blocks Id System /dev/sdb1 1 1959 15735636 83 Linux /dev/sdb2 1960 2610 5229157+ 83 Linux
생성한 파티션은 fdisk의 l 옵션으로 확인할 수 있습니다.
2. Raw Device 설정
Raw Device의 이름과 크기는 다음의 표와 같이 분할하여 할당합니다.
| 논리 볼륨명 | 크기 | Raw Device 명 | 용도 |
|---|---|---|---|
| ocr01 | 300MB | /dev/raw/raw1 | Oracle Cluster Registry 1번 |
| ocr02 | 300MB | /dev/raw/raw2 | Oracle Cluster Registry 2번 |
| vote01 | 300MB | /dev/raw/raw3 | Voting Disk 1번 |
| vote02 | 300MB | /dev/raw/raw4 | Voting Disk 2번 |
| vote03 | 300MB | /dev/raw/raw5 | Voting Disk 3번 |
| system | 1024MB | /dev/raw/raw6 | system 테이블스페이스 |
| sysaux | 1024MB | /dev/raw/raw7 | sysaux 테이블스페이스 |
| users | 1024MB | /dev/raw/raw8 | users 테이블스페이스 |
| temp | 700MB | /dev/raw/raw9 | temp 테이블스페이스 |
| undotbs1 | 1024MB | /dev/raw/raw10 | 1번 노드 undo 테이블스페이스 |
| undotbs2 | 1024MB | /dev/raw/raw11 | 2번 노드 undo 테이블스페이스 |
| control01 | 100MB | /dev/raw/raw12 | 컨트롤파일 1번 |
| control02 | 100MB | /dev/raw/raw13 | 컨트롤파일 2번 |
| redo01 | 200MB | /dev/raw/raw14 | 리두 로그 1번 그룹 |
| redo02 | 200MB | /dev/raw/raw15 | 리두 로그 2번 그룹 |
| redo03 | 200MB | /dev/raw/raw16 | 리두 로그 3번 그룹 |
| redo04 | 200MB | /dev/raw/raw17 | 리두 로그 4번 그룹 |
| redo05 | 200MB | /dev/raw/raw18 | 리두 로그 5번 그룹 |
| redo06 | 200MB | /dev/raw/raw19 | 리두 로그 6번 그룹 |
| spfile | 200MB | /dev/raw/raw20 | 파라미터 파일 |
A) 물리 볼륨 생성
root 유저로 수행
pvcreate /dev/sdb1
[root@rac1 ~]# pvcreate /dev/sdb1 Physical volume "/dev/sdb1" successfully created
파티션을 pvcreate 명령어로 물리 볼륨으로 생성합니다.
B) 물리 볼륨 확인
root 유저로 수행
pvdisplay /dev/sdb1
[root@rac1 ~]# pvdisplay /dev/sdb1 "/dev/sdb1" is a new physical volume of "15.01 GiB" --- NEW Physical volume --- PV Name /dev/sdb1 VG Name PV Size 15.01 GiB Allocatable NO PE Size 0 Total PE 0 Free PE 0 Allocated PE 0 PV UUID z91Jgt-E254-UQGX-RMLd-FIzn-npCL-Cjo30R
생성된 물리 볼륨은 pvdisplay 명령어로 확인할 수 있습니다.
C) 볼륨 그룹 생성
root 유저로 수행
vgcreate rac /dev/sdb1
[root@rac1 ~]# vgcreate rac /dev/sdb1 Volume group "rac" successfully created
vgcreate 명령어로 물리 볼륨을 볼륨 그룹으로 생성합니다.
D) 볼륨 그룹 확인
root 유저로 수행
vgdisplay rac
[root@rac1 ~]# vgdisplay rac --- Volume group --- VG Name rac System ID Format lvm2 Metadata Areas 1 Metadata Sequence No 1 VG Access read/write VG Status resizable MAX LV 0 Cur LV 0 Open LV 0 Max PV 0 Cur PV 1 Act PV 1 VG Size 15.00 GiB PE Size 4.00 MiB Total PE 3841 Alloc PE / Size 0 / 0 Free PE / Size 3841 / 15.00 GiB VG UUID EE23Lq-Ctgg-2JJN-bHw6-sCA3-Ou26-15aFXs
볼륨 그룸은 vgdisplay 명령어로 확인할 수 있습니다.
E) 논리 볼륨 생성
root 유저로 수행
lvcreate -L 300M -n ocr01 rac lvcreate -L 300M -n ocr02 rac lvcreate -L 300M -n vote01 rac lvcreate -L 300M -n vote02 rac lvcreate -L 300M -n vote03 rac lvcreate -L 1024M -n system rac lvcreate -L 1024M -n sysaux rac lvcreate -L 1024M -n users rac lvcreate -L 700M -n temp rac lvcreate -L 1024M -n undotbs1 rac lvcreate -L 1024M -n undotbs2 rac lvcreate -L 100M -n control01 rac lvcreate -L 100M -n control02 rac lvcreate -L 200M -n redo01 rac lvcreate -L 200M -n redo02 rac lvcreate -L 200M -n redo03 rac lvcreate -L 200M -n redo04 rac lvcreate -L 200M -n redo05 rac lvcreate -L 200M -n redo06 rac lvcreate -L 200M -n spfile rac
[root@rac1 ~]# lvcreate -L 300M -n ocr01 rac Logical volume "ocr01" created. [root@rac1 ~]# lvcreate -L 300M -n ocr02 rac Logical volume "ocr02" created. [root@rac1 ~]# lvcreate -L 300M -n vote01 rac Logical volume "vote01" created. [root@rac1 ~]# lvcreate -L 300M -n vote02 rac Logical volume "vote02" created. [root@rac1 ~]# lvcreate -L 300M -n vote03 rac Logical volume "vote03" created. [root@rac1 ~]# lvcreate -L 1024M -n system rac Logical volume "system" created. [root@rac1 ~]# lvcreate -L 1024M -n sysaux rac Logical volume "sysaux" created. [root@rac1 ~]# lvcreate -L 1024M -n users rac Logical volume "users" created. [root@rac1 ~]# lvcreate -L 700M -n temp rac Logical volume "temp" created. [root@rac1 ~]# lvcreate -L 1024M -n undotbs1 rac Logical volume "undotbs1" created. [root@rac1 ~]# lvcreate -L 1024M -n undotbs2 rac Logical volume "undotbs2" created. [root@rac1 ~]# lvcreate -L 100M -n control01 rac Logical volume "control01" created. [root@rac1 ~]# lvcreate -L 100M -n control02 rac Logical volume "control02" created. [root@rac1 ~]# lvcreate -L 200M -n redo01 rac Logical volume "redo01" created. [root@rac1 ~]# lvcreate -L 200M -n redo02 rac Logical volume "redo02" created. [root@rac1 ~]# lvcreate -L 200M -n redo03 rac Logical volume "redo03" created. [root@rac1 ~]# lvcreate -L 200M -n redo04 rac Logical volume "redo04" created. [root@rac1 ~]# lvcreate -L 200M -n redo05 rac Logical volume "redo05" created. [root@rac1 ~]# lvcreate -L 200M -n redo06 rac Logical volume "redo06" created. [root@rac1 ~]# lvcreate -L 200M -n spfile rac Logical volume "spfile" created.
볼륨 그룹에서 논리 볼륨을 lvcreate 명령어로 생성합니다.
각 논리 볼륨을 데이터베이스에서 사용할 크기에 맞게 분할합니다.
F) 논리 볼륨 확인
root 유저로 확인
lvdisplay
[root@rac1 ~]# lvdisplay --- Logical volume --- LV Path /dev/rac/ocr01 LV Name ocr01 VG Name rac LV UUID 2A6pwH-TC3c-ZvEW-gG0x-Optj-cnVh-VvEvGy LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:38 +0900 LV Status available # open 0 LV Size 300.00 MiB Current LE 75 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:0 --- Logical volume --- LV Path /dev/rac/ocr02 LV Name ocr02 VG Name rac LV UUID 5efRaq-GIK5-W3mf-Z65P-ei23-DIJN-WjMBQ3 LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:38 +0900 LV Status available # open 0 LV Size 300.00 MiB Current LE 75 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:1 --- Logical volume --- LV Path /dev/rac/vote01 LV Name vote01 VG Name rac LV UUID mSwKQF-QfFh-zrfz-JLIf-3fph-rKBc-iy5JKy LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:38 +0900 LV Status available # open 0 LV Size 300.00 MiB Current LE 75 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:2 --- Logical volume --- LV Path /dev/rac/vote02 LV Name vote02 VG Name rac LV UUID XfS7eI-4YqP-DgAM-wEZC-msD0-QCQw-erlZr9 LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:38 +0900 LV Status available # open 0 LV Size 300.00 MiB Current LE 75 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:3 --- Logical volume --- LV Path /dev/rac/vote03 LV Name vote03 VG Name rac LV UUID bPw7UB-ynRH-u4mR-37nV-u91W-bI25-Y0ebRd LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:39 +0900 LV Status available # open 0 LV Size 300.00 MiB Current LE 75 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:4 --- Logical volume --- LV Path /dev/rac/system LV Name system VG Name rac LV UUID 30EWd9-7dem-f7m3-K9cX-ht20-otLL-6cJ3Mi LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:39 +0900 LV Status available # open 0 LV Size 1.00 GiB Current LE 256 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:5 --- Logical volume --- LV Path /dev/rac/sysaux LV Name sysaux VG Name rac LV UUID wKOofc-aUji-KqbE-lGAW-vmcH-NSW2-CUZrRb LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:39 +0900 LV Status available # open 0 LV Size 1.00 GiB Current LE 256 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:6 --- Logical volume --- LV Path /dev/rac/users LV Name users VG Name rac LV UUID iTZHnk-0PLo-uUY3-c4wy-6RWL-b5T8-0MWchs LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:40 +0900 LV Status available # open 0 LV Size 1.00 GiB Current LE 256 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:7 --- Logical volume --- LV Path /dev/rac/temp LV Name temp VG Name rac LV UUID DNPNyS-j3IZ-c95S-HZOi-CTSa-0bFe-CorXNh LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:40 +0900 LV Status available # open 0 LV Size 700.00 MiB Current LE 175 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:8 --- Logical volume --- LV Path /dev/rac/undotbs1 LV Name undotbs1 VG Name rac LV UUID 7ulYU2-109x-kkLZ-qKpR-nZXy-P5VD-UdKK05 LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:40 +0900 LV Status available # open 0 LV Size 1.00 GiB Current LE 256 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:9 --- Logical volume --- LV Path /dev/rac/undotbs2 LV Name undotbs2 VG Name rac LV UUID FBJ6yJ-mwAM-5G4N-DaHb-03NQ-L70B-StdMbq LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:41 +0900 LV Status available # open 0 LV Size 1.00 GiB Current LE 256 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:10 --- Logical volume --- LV Path /dev/rac/control01 LV Name control01 VG Name rac LV UUID pryjEM-C98N-kDtt-sEJG-1Ioz-0MYe-eLovRw LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:41 +0900 LV Status available # open 0 LV Size 100.00 MiB Current LE 25 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:11 --- Logical volume --- LV Path /dev/rac/control02 LV Name control02 VG Name rac LV UUID c0OVqY-qBIM-l0Vt-9Uvh-RWnM-pJqU-lcINs1 LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:41 +0900 LV Status available # open 0 LV Size 100.00 MiB Current LE 25 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:12 --- Logical volume --- LV Path /dev/rac/redo01 LV Name redo01 VG Name rac LV UUID Inf829-loyW-81Z9-Qnhk-rlzV-yE2z-cdafKN LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:42 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:13 --- Logical volume --- LV Path /dev/rac/redo02 LV Name redo02 VG Name rac LV UUID 5vt942-Ae1R-CVBf-JUKX-eo5y-ce7N-2j7N1o LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:42 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:14 --- Logical volume --- LV Path /dev/rac/redo03 LV Name redo03 VG Name rac LV UUID shcaEp-2Hok-VoUL-QAXY-KkHz-j8GW-OQj3Ir LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:42 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:15 --- Logical volume --- LV Path /dev/rac/redo04 LV Name redo04 VG Name rac LV UUID BUlOLg-7Y53-RfD7-6DxZ-eHFx-M5FW-S76dsj LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:42 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:16 --- Logical volume --- LV Path /dev/rac/redo05 LV Name redo05 VG Name rac LV UUID ihsSZY-dYBb-VzVP-zfHs-1p7r-wIFW-L6Sldr LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:43 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:17 --- Logical volume --- LV Path /dev/rac/redo06 LV Name redo06 VG Name rac LV UUID MGspjs-6JcA-vd9f-0fG5-nf48-QNqX-xOKBdq LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:43 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:18 --- Logical volume --- LV Path /dev/rac/spfile LV Name spfile VG Name rac LV UUID 188sIa-Ijtj-qy65-QdEE-9yXs-TMg2-XgzyTv LV Write Access read/write LV Creation host, time rac1, 2020-09-10 13:28:44 +0900 LV Status available # open 0 LV Size 200.00 MiB Current LE 50 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 251:19
분할 생성된 논리 볼륨은 lvdisplay 명령어로 확인할 수 있습니다.
G) 논리 볼륨을 Raw Device로 변환
root 유저로 vi /etc/rc.d/rc.local 실행 후 추가
raw /dev/raw/raw1 /dev/rac/ocr01 raw /dev/raw/raw2 /dev/rac/ocr02 raw /dev/raw/raw3 /dev/rac/vote01 raw /dev/raw/raw4 /dev/rac/vote02 raw /dev/raw/raw5 /dev/rac/vote03 raw /dev/raw/raw6 /dev/rac/system raw /dev/raw/raw7 /dev/rac/sysaux raw /dev/raw/raw8 /dev/rac/users raw /dev/raw/raw9 /dev/rac/temp raw /dev/raw/raw10 /dev/rac/undotbs1 raw /dev/raw/raw11 /dev/rac/undotbs2 raw /dev/raw/raw12 /dev/rac/control01 raw /dev/raw/raw13 /dev/rac/control02 raw /dev/raw/raw14 /dev/rac/redo01 raw /dev/raw/raw15 /dev/rac/redo02 raw /dev/raw/raw16 /dev/rac/redo03 raw /dev/raw/raw17 /dev/rac/redo04 raw /dev/raw/raw18 /dev/rac/redo05 raw /dev/raw/raw19 /dev/rac/redo06 raw /dev/raw/raw20 /dev/rac/spfile
[root@rac1 ~]# raw /dev/raw/raw1 /dev/rac/ocr01 /dev/raw/raw1: bound to major 249, minor 0 [root@rac1 ~]# raw /dev/raw/raw2 /dev/rac/ocr02 /dev/raw/raw2: bound to major 249, minor 1 [root@rac1 ~]# raw /dev/raw/raw3 /dev/rac/vote01 /dev/raw/raw3: bound to major 249, minor 2 [root@rac1 ~]# raw /dev/raw/raw4 /dev/rac/vote02 /dev/raw/raw4: bound to major 249, minor 3 [root@rac1 ~]# raw /dev/raw/raw5 /dev/rac/vote03 /dev/raw/raw5: bound to major 249, minor 4 [root@rac1 ~]# raw /dev/raw/raw6 /dev/rac/system /dev/raw/raw6: bound to major 249, minor 5 [root@rac1 ~]# raw /dev/raw/raw7 /dev/rac/sysaux /dev/raw/raw7: bound to major 249, minor 6 [root@rac1 ~]# raw /dev/raw/raw8 /dev/rac/users /dev/raw/raw8: bound to major 249, minor 7 [root@rac1 ~]# raw /dev/raw/raw9 /dev/rac/temp /dev/raw/raw9: bound to major 249, minor 8 [root@rac1 ~]# raw /dev/raw/raw10 /dev/rac/undotbs1 /dev/raw/raw10: bound to major 249, minor 9 [root@rac1 ~]# raw /dev/raw/raw11 /dev/rac/undotbs2 /dev/raw/raw11: bound to major 249, minor 10 [root@rac1 ~]# raw /dev/raw/raw12 /dev/rac/control01 /dev/raw/raw12: bound to major 249, minor 11 [root@rac1 ~]# raw /dev/raw/raw13 /dev/rac/control02 /dev/raw/raw13: bound to major 249, minor 12 [root@rac1 ~]# raw /dev/raw/raw14 /dev/rac/redo01 /dev/raw/raw14: bound to major 249, minor 13 [root@rac1 ~]# raw /dev/raw/raw15 /dev/rac/redo02 /dev/raw/raw15: bound to major 249, minor 14 [root@rac1 ~]# raw /dev/raw/raw16 /dev/rac/redo03 /dev/raw/raw16: bound to major 249, minor 15 [root@rac1 ~]# raw /dev/raw/raw17 /dev/rac/redo04 /dev/raw/raw17: bound to major 249, minor 16 [root@rac1 ~]# raw /dev/raw/raw18 /dev/rac/redo05 /dev/raw/raw18: bound to major 249, minor 17 [root@rac1 ~]# raw /dev/raw/raw19 /dev/rac/redo06 /dev/raw/raw19: bound to major 249, minor 18 [root@rac1 ~]# raw /dev/raw/raw20 /dev/rac/spfile /dev/raw/raw20: bound to major 249, minor 19
쉘에서 수행할 경우 서버를 재부팅하게 되면 초기화되므로 /etc/rc.d/rc.local에 등록합니다.
H) Raw Device 소유자, 그룹 및 권한 정의
root 유저로 vi /etc/udev/rules.d/60-raw.rules 추가
ACTION=="add", KERNEL=="raw*", OWNER=="grid", GROUP=="dba", MODE=="0660" #ACTION=="add", KERNEL=="raw*", OWNER=="oracle", GROUP=="dba", MODE=="0660"
Raw Device 의 소유자, 그룹 및 권한 설정이 재부팅시에도 적용될 수 있도록 rules에 추가합니다.
{"enableNumbering":true}
