'ASM' 태그의 글 목록

ASMDISK (size : 7TB) 추가 작업 진행 하였습니다.

ASMDISK는 추가 시 새로운 DISK와 기존 DISK의 rebalance 작업이 이루어 집니다.

rebalance power(11.2.0.2 이상)는 1~1024 까지 설정 가능하며, 1024로 설정 시 disk I/O는 rebalance 작업 우선으로 서비스가 되지 않습니다.

참고로 낮은 값으로 설정 시 구글링 해보면 몇 일이 지나도 끝나지 않는다는 글들이 종종 보입니다.

저희는 최초 100으로 설정 후 영향이 없어 300으로 재 설정 하여 진행하였습니다.

시간은 15:55 ~ 20:22(약 4:20) 까지 소요 되었습니다.

asmdisk추가.sql

-- 가용량 확인

mpods01:/home/oracle>asmcmd

ASMCMD> lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 4096 4194304 19922792 282260 0 282260 0 N DATA/

-- lvs 확인

[root@mpods01 ~]# lvs

LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert

lvol_pre01 prevg01 -wi-ao---- 512.00g

lvol_pre01 prevg02 -wi-ao---- 512.00g

lvol_pre01 prevg03 -wi-ao---- 512.00g

lvol_pre01 prevg04 -wi-ao---- 512.00g

lvol_pre01 prevg05 -wi-ao---- 512.00g

lvol_pre01 prevg06 -wi-ao---- 512.00g

lvol_pre01 prevg07 -wi-ao---- 512.00g

lvol_pre01 prevg08 -wi-ao---- 512.00g

lvol_pre01 prevg09 -wi-ao---- 512.00g

lvol_pre01 prevg10 -wi-ao---- 512.00g

lvol_pre01 prevg11 -wi-ao---- 512.00g

lvol_pre01 prevg12 -wi-ao---- 512.00g

lvol_pre01 prevg13 -wi-ao---- 512.00g

lvol_pre01 prevg14 -wi-ao---- 512.00g

lvol_pre01 prevg15 -wi-ao---- 512.00g

lvol_pre01 prevg16 -wi-ao---- 512.00g

lvol_pre01 prevg17 -wi-ao---- 512.00g

lvol_pre01 prevg18 -wi-ao---- 512.00g

lvol_pre01 prevg19 -wi-ao---- 512.00g

lvol_pre01 prevg20 -wi-ao---- 512.00g

lvol_pre01 prevg21 -wi-ao---- 512.00g

lvol_pre01 prevg22 -wi-ao---- 512.00g

lvol_pre01 prevg23 -wi-ao---- 512.00g

lvol_pre01 prevg24 -wi-ao---- 512.00g

lvol_pre01 prevg25 -wi-ao---- 512.00g

lvol_pre01 prevg26 -wi-ao---- 512.00g

lvol_pre01 prevg27 -wi-ao---- 512.00g

lvol_pre01 prevg28 -wi-ao---- 512.00g

lvol_pre01 prevg29 -wi-ao---- 512.00g

lvol_pre01 prevg30 -wi-ao---- 512.00g

lvol_pre01 prevg31 -wi-ao---- 512.00g

lvol_pre01 prevg32 -wi-ao---- 512.00g

lvol_pre01 prevg33 -wi-ao---- 512.00g

lvol_pre01 prevg34 -wi-ao---- 512.00g

lvol_pre01 prevg35 -wi-ao---- 512.00g

lvol_pre01 prevg36 -wi-ao---- 512.00g

lvol_pre01 prevg37 -wi-ao---- 512.00g

lvol_pre01 prevg38 -wi-ao---- 512.00g

lvol_home vg01 -wi-ao---- 387.73g

lvol_splex vg01 -wi-ao---- 110.00g

lvol_backup vg02 -wi-ao---- 1.82t

-- 추가 후 lvs 확인

[root@mpods01 ~]# lvs

LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert

lvol_pre01 prevg01 -wi-ao---- 512.00g

lvol_pre01 prevg02 -wi-ao---- 512.00g

lvol_pre01 prevg03 -wi-ao---- 512.00g

lvol_pre01 prevg04 -wi-ao---- 512.00g

lvol_pre01 prevg05 -wi-ao---- 512.00g

lvol_pre01 prevg06 -wi-ao---- 512.00g

lvol_pre01 prevg07 -wi-ao---- 512.00g

lvol_pre01 prevg08 -wi-ao---- 512.00g

lvol_pre01 prevg09 -wi-ao---- 512.00g

lvol_pre01 prevg10 -wi-ao---- 512.00g

lvol_pre01 prevg11 -wi-ao---- 512.00g

lvol_pre01 prevg12 -wi-ao---- 512.00g

lvol_pre01 prevg13 -wi-ao---- 512.00g

lvol_pre01 prevg14 -wi-ao---- 512.00g

lvol_pre01 prevg15 -wi-ao---- 512.00g

lvol_pre01 prevg16 -wi-ao---- 512.00g

lvol_pre01 prevg17 -wi-ao---- 512.00g

lvol_pre01 prevg18 -wi-ao---- 512.00g

lvol_pre01 prevg19 -wi-ao---- 512.00g

lvol_pre01 prevg20 -wi-ao---- 512.00g

lvol_pre01 prevg21 -wi-ao---- 512.00g

lvol_pre01 prevg22 -wi-ao---- 512.00g

lvol_pre01 prevg23 -wi-ao---- 512.00g

lvol_pre01 prevg24 -wi-ao---- 512.00g

lvol_pre01 prevg25 -wi-ao---- 512.00g

lvol_pre01 prevg26 -wi-ao---- 512.00g

lvol_pre01 prevg27 -wi-ao---- 512.00g

lvol_pre01 prevg28 -wi-ao---- 512.00g

lvol_pre01 prevg29 -wi-ao---- 512.00g

lvol_pre01 prevg30 -wi-ao---- 512.00g

lvol_pre01 prevg31 -wi-ao---- 512.00g

lvol_pre01 prevg32 -wi-ao---- 512.00g

lvol_pre01 prevg33 -wi-ao---- 512.00g

lvol_pre01 prevg34 -wi-ao---- 512.00g

lvol_pre01 prevg35 -wi-ao---- 512.00g

lvol_pre01 prevg36 -wi-ao---- 512.00g

lvol_pre01 prevg37 -wi-ao---- 512.00g

lvol_pre01 prevg38 -wi-ao---- 512.00g

lvol_pre01 prevg39 -wi-a----- 512.00g

lvol_pre01 prevg40 -wi-a----- 512.00g

lvol_pre01 prevg41 -wi-a----- 512.00g

lvol_pre01 prevg42 -wi-a----- 512.00g

lvol_pre01 prevg43 -wi-a----- 512.00g

lvol_pre01 prevg44 -wi-a----- 512.00g

lvol_pre01 prevg45 -wi-a----- 512.00g

lvol_pre01 prevg46 -wi-a----- 512.00g

lvol_pre01 prevg47 -wi-a----- 512.00g

lvol_pre01 prevg48 -wi-a----- 512.00g

lvol_pre01 prevg49 -wi-a----- 512.00g

lvol_pre01 prevg50 -wi-a----- 512.00g

lvol_pre01 prevg51 -wi-a----- 512.00g

lvol_home vg01 -wi-ao---- 387.73g

lvol_splex vg01 -wi-ao---- 110.00g

lvol_backup vg02 -wi-ao---- 1.82t

[root@mpods01 mapper]# oracleasm listdisks

VOL01

VOL02

VOL03

VOL04

VOL05

VOL06

VOL07

VOL08

VOL09

VOL10

VOL11

VOL12

VOL13

VOL14

VOL15

VOL16

VOL17

VOL18

VOL19

VOL20

VOL21

VOL22

VOL23

VOL24

VOL25

VOL26

VOL27

VOL28

VOL29

VOL30

VOL31

VOL32

VOL33

VOL34

VOL35

VOL36

VOL37

VOL38

-- asm disk group & path 확인

set linesize 150

set pagesize 100

col path for a40

select group_number,mount_status,path,total_mb from v$asm_disk order by group_number, path;

GROUP_NUMBER MOUNT_STATUS PATH TOTAL_MB

------------ -------------- ---------------------------------------- ----------

1 CACHED /dev/oracleasm/disks/VOL01 524284

1 CACHED /dev/oracleasm/disks/VOL02 524284

1 CACHED /dev/oracleasm/disks/VOL03 524284

1 CACHED /dev/oracleasm/disks/VOL04 524284

1 CACHED /dev/oracleasm/disks/VOL05 524284

1 CACHED /dev/oracleasm/disks/VOL06 524284

1 CACHED /dev/oracleasm/disks/VOL07 524284

1 CACHED /dev/oracleasm/disks/VOL08 524284

1 CACHED /dev/oracleasm/disks/VOL09 524284

1 CACHED /dev/oracleasm/disks/VOL10 524284

1 CACHED /dev/oracleasm/disks/VOL11 524284

1 CACHED /dev/oracleasm/disks/VOL12 524284

1 CACHED /dev/oracleasm/disks/VOL13 524284

1 CACHED /dev/oracleasm/disks/VOL14 524284

1 CACHED /dev/oracleasm/disks/VOL15 524284

1 CACHED /dev/oracleasm/disks/VOL16 524284

1 CACHED /dev/oracleasm/disks/VOL17 524284

1 CACHED /dev/oracleasm/disks/VOL18 524284

1 CACHED /dev/oracleasm/disks/VOL19 524284

1 CACHED /dev/oracleasm/disks/VOL20 524284

1 CACHED /dev/oracleasm/disks/VOL21 524284

1 CACHED /dev/oracleasm/disks/VOL22 524284

1 CACHED /dev/oracleasm/disks/VOL23 524284

1 CACHED /dev/oracleasm/disks/VOL24 524284

1 CACHED /dev/oracleasm/disks/VOL25 524284

1 CACHED /dev/oracleasm/disks/VOL26 524284

1 CACHED /dev/oracleasm/disks/VOL27 524284

1 CACHED /dev/oracleasm/disks/VOL28 524284

1 CACHED /dev/oracleasm/disks/VOL29 524284

1 CACHED /dev/oracleasm/disks/VOL30 524284

1 CACHED /dev/oracleasm/disks/VOL31 524284

1 CACHED /dev/oracleasm/disks/VOL32 524284

1 CACHED /dev/oracleasm/disks/VOL33 524284

1 CACHED /dev/oracleasm/disks/VOL34 524284

1 CACHED /dev/oracleasm/disks/VOL35 524284

1 CACHED /dev/oracleasm/disks/VOL36 524284

1 CACHED /dev/oracleasm/disks/VOL37 524284

1 CACHED /dev/oracleasm/disks/VOL38 524284

38 rows selected.

-- oracleasm disk 추가

oracleasm createdisk VOL39 /dev/mapper/prevg39-lvol_pre01

oracleasm createdisk VOL40 /dev/mapper/prevg40-lvol_pre01

oracleasm createdisk VOL41 /dev/mapper/prevg41-lvol_pre01

oracleasm createdisk VOL42 /dev/mapper/prevg42-lvol_pre01

oracleasm createdisk VOL43 /dev/mapper/prevg43-lvol_pre01

oracleasm createdisk VOL44 /dev/mapper/prevg44-lvol_pre01

oracleasm createdisk VOL45 /dev/mapper/prevg45-lvol_pre01

oracleasm createdisk VOL46 /dev/mapper/prevg46-lvol_pre01

oracleasm createdisk VOL47 /dev/mapper/prevg47-lvol_pre01

oracleasm createdisk VOL48 /dev/mapper/prevg48-lvol_pre01

oracleasm createdisk VOL49 /dev/mapper/prevg49-lvol_pre01

oracleasm createdisk VOL50 /dev/mapper/prevg50-lvol_pre01

oracleasm createdisk VOL51 /dev/mapper/prevg51-lvol_pre01

-- oracleasm disk 추가 후 asm disk group & path 확인

SQL> select group_number,mount_status,path,total_mb from v$asm_disk order by group_number, path;

GROUP_NUMBER MOUNT_STATUS PATH TOTAL_MB

------------ -------------- ---------------------------------------- ----------

0 CLOSED /dev/oracleasm/disks/VOL39 0

0 CLOSED /dev/oracleasm/disks/VOL40 0

0 CLOSED /dev/oracleasm/disks/VOL41 0

0 CLOSED /dev/oracleasm/disks/VOL42 0

0 CLOSED /dev/oracleasm/disks/VOL43 0

0 CLOSED /dev/oracleasm/disks/VOL44 0

0 CLOSED /dev/oracleasm/disks/VOL45 0

0 CLOSED /dev/oracleasm/disks/VOL46 0

0 CLOSED /dev/oracleasm/disks/VOL47 0

0 CLOSED /dev/oracleasm/disks/VOL48 0

0 CLOSED /dev/oracleasm/disks/VOL49 0

0 CLOSED /dev/oracleasm/disks/VOL50 0

0 CLOSED /dev/oracleasm/disks/VOL51 0

1 CACHED /dev/oracleasm/disks/VOL01 524284

1 CACHED /dev/oracleasm/disks/VOL02 524284

1 CACHED /dev/oracleasm/disks/VOL03 524284

1 CACHED /dev/oracleasm/disks/VOL04 524284

1 CACHED /dev/oracleasm/disks/VOL05 524284

1 CACHED /dev/oracleasm/disks/VOL06 524284

1 CACHED /dev/oracleasm/disks/VOL07 524284

1 CACHED /dev/oracleasm/disks/VOL08 524284

1 CACHED /dev/oracleasm/disks/VOL09 524284

1 CACHED /dev/oracleasm/disks/VOL10 524284

1 CACHED /dev/oracleasm/disks/VOL11 524284

1 CACHED /dev/oracleasm/disks/VOL12 524284

1 CACHED /dev/oracleasm/disks/VOL13 524284

1 CACHED /dev/oracleasm/disks/VOL14 524284

1 CACHED /dev/oracleasm/disks/VOL15 524284

1 CACHED /dev/oracleasm/disks/VOL16 524284

1 CACHED /dev/oracleasm/disks/VOL17 524284

1 CACHED /dev/oracleasm/disks/VOL18 524284

1 CACHED /dev/oracleasm/disks/VOL19 524284

1 CACHED /dev/oracleasm/disks/VOL20 524284

1 CACHED /dev/oracleasm/disks/VOL21 524284

1 CACHED /dev/oracleasm/disks/VOL22 524284

1 CACHED /dev/oracleasm/disks/VOL23 524284

1 CACHED /dev/oracleasm/disks/VOL24 524284

1 CACHED /dev/oracleasm/disks/VOL25 524284

1 CACHED /dev/oracleasm/disks/VOL26 524284

1 CACHED /dev/oracleasm/disks/VOL27 524284

1 CACHED /dev/oracleasm/disks/VOL28 524284

1 CACHED /dev/oracleasm/disks/VOL29 524284

1 CACHED /dev/oracleasm/disks/VOL30 524284

1 CACHED /dev/oracleasm/disks/VOL31 524284

1 CACHED /dev/oracleasm/disks/VOL32 524284

1 CACHED /dev/oracleasm/disks/VOL33 524284

1 CACHED /dev/oracleasm/disks/VOL34 524284

1 CACHED /dev/oracleasm/disks/VOL35 524284

1 CACHED /dev/oracleasm/disks/VOL36 524284

1 CACHED /dev/oracleasm/disks/VOL37 524284

1 CACHED /dev/oracleasm/disks/VOL38 524284

51 rows selected.

-- ASM Operation 확인

set linesize 150

set pagesize 100

col name for a20

select d.name, o.operation, o.state, o.power, o.est_minutes

from v$asm_disk d, v$asm_operation o

where d.group_number=o.group_number order by 1;

-- ASM 그룹 디스크 추가 (15:55:39 시작)

alter diskgroup DATA

add disk '/dev/oracleasm/disks/VOL39','/dev/oracleasm/disks/VOL40','/dev/oracleasm/disks/VOL41','/dev/oracleasm/disks/VOL42',

'/dev/oracleasm/disks/VOL43','/dev/oracleasm/disks/VOL44','/dev/oracleasm/disks/VOL45','/dev/oracleasm/disks/VOL46',

'/dev/oracleasm/disks/VOL47','/dev/oracleasm/disks/VOL48','/dev/oracleasm/disks/VOL49','/dev/oracleasm/disks/VOL50',

'/dev/oracleasm/disks/VOL51'

rebalance power 100 wait;

-- ASM Operation 확인

set linesize 150

set pagesize 100

col name for a20

select d.name, o.operation, o.state, o.power, o.est_minutes

from v$asm_disk d, v$asm_operation o

where d.group_number=o.group_number order by 1;

NAME OPERATION STATE POWER EST_MINUTES

-------------------- ---------- -------- ---------- -----------

DATA_0000 REBAL WAIT 100 0

DATA_0000 REBAL RUN 100 147

DATA_0001 REBAL WAIT 100 0

DATA_0001 REBAL RUN 100 147

DATA_0002 REBAL RUN 100 147

DATA_0002 REBAL WAIT 100 0

DATA_0003 REBAL RUN 100 147

DATA_0003 REBAL WAIT 100 0

DATA_0004 REBAL RUN 100 147

DATA_0004 REBAL WAIT 100 0

DATA_0005 REBAL RUN 100 147

DATA_0005 REBAL WAIT 100 0

DATA_0006 REBAL RUN 100 147

DATA_0006 REBAL WAIT 100 0

DATA_0007 REBAL WAIT 100 0

DATA_0007 REBAL RUN 100 147

DATA_0008 REBAL RUN 100 147

DATA_0008 REBAL WAIT 100 0

DATA_0009 REBAL RUN 100 147

DATA_0009 REBAL WAIT 100 0

DATA_0010 REBAL WAIT 100 0

DATA_0010 REBAL RUN 100 147

DATA_0011 REBAL WAIT 100 0

DATA_0011 REBAL RUN 100 147

DATA_0012 REBAL WAIT 100 0

DATA_0012 REBAL RUN 100 147

DATA_0013 REBAL RUN 100 147

DATA_0013 REBAL WAIT 100 0

DATA_0014 REBAL WAIT 100 0

DATA_0014 REBAL RUN 100 147

DATA_0015 REBAL WAIT 100 0

DATA_0015 REBAL RUN 100 147

DATA_0016 REBAL WAIT 100 0

DATA_0016 REBAL RUN 100 147

DATA_0017 REBAL RUN 100 147

DATA_0017 REBAL WAIT 100 0

DATA_0018 REBAL RUN 100 147

DATA_0018 REBAL WAIT 100 0

DATA_0019 REBAL WAIT 100 0

DATA_0019 REBAL RUN 100 147

DATA_0020 REBAL RUN 100 147

DATA_0020 REBAL WAIT 100 0

DATA_0021 REBAL RUN 100 147

DATA_0021 REBAL WAIT 100 0

DATA_0022 REBAL RUN 100 147

DATA_0022 REBAL WAIT 100 0

DATA_0023 REBAL WAIT 100 0

DATA_0023 REBAL RUN 100 147

DATA_0024 REBAL RUN 100 147

DATA_0024 REBAL WAIT 100 0

DATA_0025 REBAL RUN 100 147

DATA_0025 REBAL WAIT 100 0

DATA_0026 REBAL RUN 100 147

DATA_0026 REBAL WAIT 100 0

DATA_0027 REBAL RUN 100 147

DATA_0027 REBAL WAIT 100 0

DATA_0028 REBAL RUN 100 147

DATA_0028 REBAL WAIT 100 0

DATA_0029 REBAL RUN 100 147

DATA_0029 REBAL WAIT 100 0

DATA_0030 REBAL RUN 100 147

DATA_0030 REBAL WAIT 100 0

DATA_0031 REBAL RUN 100 147

DATA_0031 REBAL WAIT 100 0

DATA_0032 REBAL RUN 100 147

DATA_0032 REBAL WAIT 100 0

DATA_0033 REBAL RUN 100 147

DATA_0033 REBAL WAIT 100 0

DATA_0034 REBAL WAIT 100 0

DATA_0034 REBAL RUN 100 147

DATA_0035 REBAL RUN 100 147

DATA_0035 REBAL WAIT 100 0

DATA_0036 REBAL RUN 100 147

DATA_0036 REBAL WAIT 100 0

DATA_0037 REBAL WAIT 100 0

DATA_0037 REBAL RUN 100 147

DATA_0038 REBAL WAIT 100 0

DATA_0038 REBAL RUN 100 147

DATA_0039 REBAL WAIT 100 0

DATA_0039 REBAL RUN 100 147

DATA_0040 REBAL WAIT 100 0

DATA_0040 REBAL RUN 100 147

DATA_0041 REBAL RUN 100 147

DATA_0041 REBAL WAIT 100 0

DATA_0042 REBAL RUN 100 147

DATA_0042 REBAL WAIT 100 0

DATA_0043 REBAL WAIT 100 0

DATA_0043 REBAL RUN 100 147

DATA_0044 REBAL RUN 100 147

DATA_0044 REBAL WAIT 100 0

DATA_0045 REBAL RUN 100 147

DATA_0045 REBAL WAIT 100 0

DATA_0046 REBAL WAIT 100 0

DATA_0046 REBAL RUN 100 147

DATA_0047 REBAL WAIT 100 0

DATA_0047 REBAL RUN 100 147

DATA_0048 REBAL RUN 100 147

NAME OPERATION STATE POWER EST_MINUTES

-------------------- ---------- -------- ---------- -----------

DATA_0048 REBAL WAIT 100 0

DATA_0049 REBAL RUN 100 147

DATA_0049 REBAL WAIT 100 0

DATA_0050 REBAL WAIT 100 0

DATA_0050 REBAL RUN 100 147

102 rows selected.

-- rebalance power 변경 (16:03:30 변경)

alter diskgroup data rebalance power 300;

-- 완료 (20:22:00)

-- asm disk group & path 확인

set linesize 150

set pagesize 100

col path for a40

select group_number,mount_status,path,total_mb from v$asm_disk order by group_number, path;

GROUP_NUMBER MOUNT_STATUS PATH TOTAL_MB

------------ -------------- ---------------------------------------- ----------

1 CACHED /dev/oracleasm/disks/VOL01 524284

1 CACHED /dev/oracleasm/disks/VOL02 524284

1 CACHED /dev/oracleasm/disks/VOL03 524284

1 CACHED /dev/oracleasm/disks/VOL04 524284

1 CACHED /dev/oracleasm/disks/VOL05 524284

1 CACHED /dev/oracleasm/disks/VOL06 524284

1 CACHED /dev/oracleasm/disks/VOL07 524284

1 CACHED /dev/oracleasm/disks/VOL08 524284

1 CACHED /dev/oracleasm/disks/VOL09 524284

1 CACHED /dev/oracleasm/disks/VOL10 524284

1 CACHED /dev/oracleasm/disks/VOL11 524284

1 CACHED /dev/oracleasm/disks/VOL12 524284

1 CACHED /dev/oracleasm/disks/VOL13 524284

1 CACHED /dev/oracleasm/disks/VOL14 524284

1 CACHED /dev/oracleasm/disks/VOL15 524284

1 CACHED /dev/oracleasm/disks/VOL16 524284

1 CACHED /dev/oracleasm/disks/VOL17 524284

1 CACHED /dev/oracleasm/disks/VOL18 524284

1 CACHED /dev/oracleasm/disks/VOL19 524284

1 CACHED /dev/oracleasm/disks/VOL20 524284

1 CACHED /dev/oracleasm/disks/VOL21 524284

1 CACHED /dev/oracleasm/disks/VOL22 524284

1 CACHED /dev/oracleasm/disks/VOL23 524284

1 CACHED /dev/oracleasm/disks/VOL24 524284

1 CACHED /dev/oracleasm/disks/VOL25 524284

1 CACHED /dev/oracleasm/disks/VOL26 524284

1 CACHED /dev/oracleasm/disks/VOL27 524284

1 CACHED /dev/oracleasm/disks/VOL28 524284

1 CACHED /dev/oracleasm/disks/VOL29 524284

1 CACHED /dev/oracleasm/disks/VOL30 524284

1 CACHED /dev/oracleasm/disks/VOL31 524284

1 CACHED /dev/oracleasm/disks/VOL32 524284

1 CACHED /dev/oracleasm/disks/VOL33 524284

1 CACHED /dev/oracleasm/disks/VOL34 524284

1 CACHED /dev/oracleasm/disks/VOL35 524284

1 CACHED /dev/oracleasm/disks/VOL36 524284

1 CACHED /dev/oracleasm/disks/VOL37 524284

1 CACHED /dev/oracleasm/disks/VOL38 524284

1 CACHED /dev/oracleasm/disks/VOL39 524284

1 CACHED /dev/oracleasm/disks/VOL40 524284

1 CACHED /dev/oracleasm/disks/VOL41 524284

1 CACHED /dev/oracleasm/disks/VOL42 524284

1 CACHED /dev/oracleasm/disks/VOL43 524284

1 CACHED /dev/oracleasm/disks/VOL44 524284

1 CACHED /dev/oracleasm/disks/VOL45 524284

1 CACHED /dev/oracleasm/disks/VOL46 524284

1 CACHED /dev/oracleasm/disks/VOL47 524284

1 CACHED /dev/oracleasm/disks/VOL48 524284

1 CACHED /dev/oracleasm/disks/VOL49 524284

1 CACHED /dev/oracleasm/disks/VOL50 524284

1 CACHED /dev/oracleasm/disks/VOL51 524284

51 rows selected.

-- 가용량 확인

ASMCMD> lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 4096 4194304 26738484 7097796 0 7097796 0 N DATA/

저작자표시 비영리 변경금지

'OraclE > ASM' 카테고리의 다른 글

ASM DISK 추가 하기 (0)	2016.03.25

OS : Oracle Linux Server release 6.5

ORACLE : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0

-- 기존 경로 정보 확인

# oracleasm querydisk -p VOL1

Disk "VOL1" is a valid ASM disk

/dev/mapper/vgora04-lvora04: LABEL="VOL1" TYPE="oracleasm"

-- asm disk 만들기

# oracleasm createdisk VOL6 /dev/mapper/vgora06-lvora06

# oracleasm createdisk VOL7 /dev/mapper/vgora07-lvora07

# oracleasm createdisk VOL8 /dev/mapper/vgora08-lvora08

-- asm disk 조회

SQL> select group_number, disk_number, name, mount_status, path, total_mb

from v$asm_disk

order by path;

GROUP_NUMBER DISK_NUMBER NAME MOUNT_S PATH TOTAL_MB

------------ ----------- -------------------- ------- ------------------------------ ----------

1 0 VOL1 CACHED ORCL:VOL1 1048568

1 1 VOL2 CACHED ORCL:VOL2 1048568

1 2 VOL3 CACHED ORCL:VOL3 1048568

1 3 VOL4 CACHED ORCL:VOL4 1048568

1 4 VOL5 CACHED ORCL:VOL5 1048568

0 0 CLOSED ORCL:VOL6 0

0 1 CLOSED ORCL:VOL7 0

0 2 CLOSED ORCL:VOL8 0

8 rows selected.

-- asm disk 를 그룹에 추가

$ sqlplus "/as sysadm"

SQL> select NAME, COMPATIBILITY from v$asm_diskgroup;

NAME COMPATIBILITY

-------------------- ------------------------------

DATA 11.2.0.0.0

※ rebalance power 설정시 COMPATIBLE.ASM disk group attribute가 11.2.0.2 이상은 0~1024, 11.2.0.1 이하는 0~11로 설정한다.

SQL> alter diskgroup DATA add disk 'ORCL:VOL6','ORCL:VOL7','ORCL:VOL8' rebalance power 11;

SQL> select group_number, disk_number, name, mount_status, path, total_mb

from v$asm_disk

order by path;

GROUP_NUMBER DISK_NUMBER NAME MOUNT_S PATH TOTAL_MB

------------ ----------- -------------------- ------- ------------------------------ ----------

1 0 VOL1 CACHED ORCL:VOL1 1048568

1 1 VOL2 CACHED ORCL:VOL2 1048568

1 2 VOL3 CACHED ORCL:VOL3 1048568

1 3 VOL4 CACHED ORCL:VOL4 1048568

1 4 VOL5 CACHED ORCL:VOL5 1048568

1 5 VOL6 CACHED ORCL:VOL6 1023992

1 6 VOL7 CACHED ORCL:VOL7 1023992

1 7 VOL8 CACHED ORCL:VOL8 1023984

8 rows selected.

SQL> select d.name, o.operation, o.state, o.power, o.est_minutes

from v$asm_disk d, v$asm_operation o

where d.group_number=o.group_number

order by 1;

NAME OPERA STAT POWER EST_MINUTES

------------------------------ ----- ---- ---------- -----------

VOL1 REBAL RUN 11 112

VOL2 REBAL RUN 11 112

VOL3 REBAL RUN 11 112

VOL4 REBAL RUN 11 112

VOL5 REBAL RUN 11 112

VOL6 REBAL RUN 11 112

VOL7 REBAL RUN 11 112

VOL8 REBAL RUN 11 112

8 rows selected.

-- 거의 완료 된 상태에서 파워 변경 11->8

SQL> alter diskgroup DATA rebalance power 8;

SQL> select d.name, o.operation, o.state, o.power, o.est_minutes

from v$asm_disk d, v$asm_operation o

where d.group_number=o.group_number

order by 1;

NAME OPERA STAT POWER EST_MINUTES

------------------------------ ----- ---- ---------- -----------

VOL1 REBAL RUN 8 8

VOL2 REBAL RUN 8 8

VOL3 REBAL RUN 8 8

VOL4 REBAL RUN 8 8

VOL5 REBAL RUN 8 8

VOL6 REBAL RUN 8 8

VOL7 REBAL RUN 8 8

VOL8 REBAL RUN 8 8

8 rows selected.

완료시 위 결과가 아무것도 안나옴.

-- 4.7TB/5TB 에 3TB 추가시 약 150분 소요 (transaction 없음)

저작자표시 비영리 변경금지

'OraclE > ASM' 카테고리의 다른 글

ASM DISK 추가 하기 2 (0)	2017.04.21

기술노트[53회] 11g_NF_ASM.pdf

'OraclE > 기술노트' 카테고리의 다른 글

[기술노트 52회] Oracle 11gR2 RAC to RAC 구축방법. (1)	2011.06.18
[기술노트 54회] 11g Flashback Versions Query에 대한 기능소개입니다. (0)	2011.06.18
[기술노트 55회] ORACLE 11g R2(11.2.0.2) RAC install for HP-UX 방법 (0)	2011.06.18
[기술노트 56회] Oracle11g RAC Architecture (0)	2011.06.18
[기술노트 57회] 11g R2 RAC Command (0)	2011.06.18

[출처] http://cafe.naver.com/sf2dark.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=11

VM->Setting->HardDisk->Add->8GB->name set(b,c,d,e,f,g 등 6개 디스크 생성)

root/oracle 로그인

부팅 완료후 버전 확인

[root@ocp ~]# uname -rm
2.6.9-42.ELsmp i686

VM->Setting->Options->Shared Folders->Add->Next->공유된 폴더 연결, 이름지정->Next->Finish

->Forder Sharing->Always enabled (check)->OK

[root@ocp hgfs]# cd /mnt/hgfs/shared/

오라클 사이트에서 ASM 패키지 다운로드
http://www.oracle.com/technology/software/tech/linux/asmlib/rhel4.html

패키지 저장할 디렉토리 생성
[root@ocp shared]# mkdir /asm/

패키지를 /asm 디렉토리로 복사

[root@ocp shared]#cp *.rpm /asm/

패키지 설치

[root@ocp shared]# cd /asm/

/asm/에서 확인
[root@ocp asm]# ll
total 184
-rwxr-xr-x 1 root root 129218 May 11 01:44 oracleasm-2.6.9-42.ELsmp-2.0.3-1.i686.rpm
-rwxr-xr-x 1 root root 12948 May 11 01:44 oracleasmlib-2.0.2-1.i386.rpm
-rwxr-xr-x 1 root root 22662 May 11 01:44 oracleasm-support-2.0.3-1.i386.rpm

순서대로 설치

[root@ocp asm]# rpm -Uvh oracleasm-support-2.0.3-1.i386.rpm
Preparing... ########################################### [100%]

[root@ocp asm]# rpm -Uvh oracleasm-2.6.9-42.ELsmp-2.0.3-1.i686.rpm
Preparing... ########################################### [100%]
[root@ocp asm]# rpm -Uvh oracleasmlib-2.0.2-1.i386.rpm
Preparing... ########################################### [100%]

ASM 구성 설정
[root@ocp asm]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration:           [ OK ]
Creating /dev/oracleasm mount point:                       [ OK ]
Loading module "oracleasm":                                [ OK ]
Mounting ASMlib driver filesystem:                         [ OK ]
Scanning system for ASM disks:                             [ OK ]

ASM 활성화
[root@ocp asm]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Scanning system for ASM disks: [ OK ]

터미널 창 open 아래와 같은 작업 진행.

파티션 설정
[root@ocp ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

The number of cylinders for this disk is set to 1044.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n

Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1044, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1044, default 1044):
Using default value 1044

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

[root@ocp ~]# fdisk /dev/sdc

.

[root@ocp ~]# fdisk /dev/sdd

파티션 확인
[root@ocp ~]# fdisk /dev/sdb

The number of cylinders for this disk is set to 1044.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): p

Disk /dev/sdb: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 1044 8385898+ 83 Linux

Command (m for help): q

파일시스템 생성
[root@ocp ~]# mke2fs -j /dev/sdb1
mke2fs 1.35 (28-Feb-2004)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
1048576 inodes, 2096474 blocks
104823 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2147483648
64 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632

Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 25 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

ASM 디스크 구성
[root@ocp dev]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk "/dev/sde1" as an ASM disk:                   [ OK ]
[root@ocp dev]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
Marking disk "/dev/sdf1" as an ASM disk:                   [ OK ]
[root@ocp dev]# /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1
Marking disk "/dev/sdg1" as an ASM disk:                   [ OK ]

구성확인

[root@ocp dev]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
root 사용자 로그 오프

oracle 사용자로 로그인후 터미널창 에서

[oracle@ocp ~]$ . .bash_profile
ocp@orcl : /home/oracle> dbca

0. Welcome -> Next
1. operations -> Create a Database -> Next
2. Database Templates -> General Purpose -> Next
3. Database Identification -> orcl2 -> Next
4. Management Options -> Next
5. Database Credentials -> Password 설정(oracle) -> Next
6. Storage Options -> ASM -> Next

터미널창 열기

    ocp@orcl : /home/oracle> su -
    Password:oracle
    [root@ocp ~]# /u01/app/oracle/product/10.2.0/db_1/bin/localconfig add
    /etc/oracle does not exist. Creating it now.
    Successfully accumulated necessary OCR keys.
    Creating OCR keys for user 'root', privgrp 'root'..
    Operation successful.
    Configuration for local CSS has been initialized

    Adding to inittab
    Startup will be queued to init within 90 seconds.
    Checking the status of new Oracle init process...
    Expecting the CRS daemons to be up within 600 seconds.

    CSS is active on these nodes.
            ocp
    CSS is active on all nodes.
    Oracle CSS service is installed and running under init(1M)

[root@ocp ~]#exit
-> OK -> Next
7. Create ASM Instance -> ASM Password 설정(oracle) -> Next

DBCA가 ASM 시작 -> OK ->
ASM Disk Groups -> Next ->
ASM Disk Groups -> Create New
Create Disk Group -> Disk Group Name: DATA1
     - High: 데이타를 2중으로 미러링
     - Normal: 기본적인 미러링
     - External: ASM의 디스크를 미러링 하지 않음, 하드웨어 RAID Array 구성된 경우에 사용.
Change Disk Discovery Path -> ORCL:* -> OK

DISK 모두 선택 -> OK

ASM Disk Groups -> 체크박스를 클릭 -> Next

8. Database File Locations -> Use Oracle-Managed Files: +DATA1 확인 -> Next
9. Recovery Configuration
    Specify Flash Recovery Area를 선택합니다.
     - Flash Recovery Area: +DATA1
     - Flash Recovery Area Size: 2048

- Enable Archiving 체크

-> Next

10. Database Content
Sample Schemas 체크 -> Next

Language->KO16MSWIN949

Date->Korea

11. Initialization Parameters -> Next
12. Database Storage -> Next
13. Creation Options -> Create Database 체크 -> Finish
    Confirmation -> Database Details -> OK
     DB 설치
     Enterprise Manager URL을 확인 -> Exit

'OraclE' 카테고리의 다른 글

ORA-29275 : 부분 다중 바이트 문자 (0)	2009.09.07
LOCAL_LISTENER and ORA-12545 (0)	2009.09.06
오라클 암호화 복호화 초간단 예제(dbms_obfuscation_toolkit 편) (1)	2009.08.28
Oradim Utility (0)	2009.08.07
Oracle10g R2부터 Group By절에 의한 자동정렬이 안되는 이유 (0)	2009.06.12

JJON's StorY

ASM

ASM DISK 추가 하기 2

'OraclE > ASM' 카테고리의 다른 글

ASM DISK 추가 하기

'OraclE > ASM' 카테고리의 다른 글

[기술노트 53회] 11g ASM Improvemet 소개

'OraclE > 기술노트' 카테고리의 다른 글

ASM 구성방법(ASM 설치)

'OraclE' 카테고리의 다른 글

+ Recent posts

티스토리툴바