💡 ASM 디스크 그룹이란
- 여러 개의 물리적 디스크를 하나의 논리적 단위로 묶어서 관리하는 스토리지 풀
- Oracle 데이터베이스가 data file, control file, redo log file 등을 저장할 때 사용하는 가상화된 스토리지 공간이라고 할 수 있음
[실습1] asm 디스크 그룹에 디스크 추가하기
col path for a20
set pages 4000
select group_number, mount_status, path, total_mb
from v$asm_disk;
상태가 CLOSED 나오는것은 다 써도 되는것입니다.
0 CLOSED ORCL:ASMDISK13 0
select name, total_mb, free_mb
from v$asm_diskgroup;
alter diskgroup data
add disk 'ORCL:ASMDISK13' rebalance power 2;
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type
오라클 db 인스턴스에 접속해서 위의 명령어를 수행하면 안되고
asm 인스턴스 쪽으로 접속해서 수행해야합니다.
[orcl:~]$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[+ASM:~]$ sqlplus / as sysasm
SQL> alter diskgroup data
add disk 'ORCL:ASMDISK13' rebalance power 2;
추가한 디스크에 기존 디스크의 data 를 분배를 하는데 2개의 프로세서가
분배를 합니다. 빨리 분배되게 하려면 이 숫자값을 크게 주면 됩니다.
SQL> select name, total_mb, free_mb
from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
DATA 11520 8085
FRA 9216 8982
SQL>
col path for a20
set pages 4000
select group_number, mount_status, path, total_mb
from v$asm_disk;
SQL> SQL>
GROUP_NUMBER MOUNT_S PATH TOTAL_MB
0 CLOSED ORCL:ASMDISK09 0
0 CLOSED ORCL:ASMDISK10 0
0 CLOSED ORCL:ASMDISK11 0
0 CLOSED ORCL:ASMDISK12 0
1 CACHED ORCL:ASMDISK01 2304
1 CACHED ORCL:ASMDISK02 2304
1 CACHED ORCL:ASMDISK03 2304
1 CACHED ORCL:ASMDISK04 2304
2 CACHED ORCL:ASMDISK05 2304
2 CACHED ORCL:ASMDISK06 2304
2 CACHED ORCL:ASMDISK07 2304
2 CACHED ORCL:ASMDISK08 2304
1 CACHED ORCL:ASMDISK13 2304
13 rows selected.
문제1. asm 인스턴스를 위한 alert log file 을 찾아서 별도의 putty 창에서 tail -f 로 실시간 모니터링하시오
SQL> show parameter background
NAME TYPE VALUE
background_core_dump string partial
background_dump_dest string /u01/app/oracle/diag/asm/ +asm/
+ASM/trace
SQL>
SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
[+ASM:~]$ cd /u01/app/oracle/diag/asm/+asm/+ASM/trace
[+ASM:trace]$
[+ASM:trace]$ tail -f alert*
kfdp_updateBg(): 12
NOTE: PST update grp = 1 completed successfully
NOTE: initiating PST update: grp = 1
kfdp_update(): 13
kfdp_updateBg(): 13
NOTE: PST update grp = 1 completed successfully
NOTE: membership refresh pending for group 1/0x1a85005 (DATA)
kfdp_query(DATA): 14
kfdp_queryBg(): 14
SUCCESS: refreshed membership for 1/0x1a85005 (DATA)
문제2. fra 디스크 그룹에 남는 디스크를 하나 추가하시오
SQL> col path for a20
set pages 4000
select group_number, mount_status, path, total_mb
from v$asm_disk;
SQL> SQL> 2
GROUP_NUMBER MOUNT_S PATH TOTAL_MB
1 CACHED ORCL:ASMDISK01 2304
1 CACHED ORCL:ASMDISK02 2304
1 CACHED ORCL:ASMDISK03 2304
1 CACHED ORCL:ASMDISK04 2304
2 CACHED ORCL:ASMDISK05 2304
2 CACHED ORCL:ASMDISK06 2304
2 CACHED ORCL:ASMDISK07 2304
2 CACHED ORCL:ASMDISK08 2304
1 CACHED ORCL:ASMDISK13 2304
0 CLOSED ORCL:ASMDISK12 0
0 CLOSED ORCL:ASMDISK11 0
0 CLOSED ORCL:ASMDISK10 0
0 CLOSED ORCL:ASMDISK09 0
13 rows selected.
SQL> select name, total_mb, free_mb
from v$asm_diskgroup;
2
NAME TOTAL_MB FREE_MB
DATA 11520 8063
FRA 9216 8982
SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[orcl:~]$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
[+ASM:~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 14:26:49 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> alter diskgroup fra
2 add disk 'ORCL:ASMDISK12' rebalance power 2;
Diskgroup altered.
SQL> select name, total_mb, free_mb
from v$asm_diskgroup; 2
NAME TOTAL_MB FREE_MB
DATA 11520 8063
FRA 11520 11284
SQL> col path for a20
set pages 4000
select group_number, mount_status, path, total_mb
from v$asm_disk;
SQL> SQL> 2
GROUP_NUMBER MOUNT_S PATH TOTAL_MB
0 CLOSED ORCL:ASMDISK09 0
0 CLOSED ORCL:ASMDISK10 0
0 CLOSED ORCL:ASMDISK11 0
1 CACHED ORCL:ASMDISK01 2304
1 CACHED ORCL:ASMDISK02 2304
1 CACHED ORCL:ASMDISK03 2304
1 CACHED ORCL:ASMDISK04 2304
2 CACHED ORCL:ASMDISK05 2304
2 CACHED ORCL:ASMDISK06 2304
2 CACHED ORCL:ASMDISK07 2304
2 CACHED ORCL:ASMDISK08 2304
2 CACHED ORCL:ASMDISK12 2304
1 CACHED ORCL:ASMDISK13 2304
13 rows selected.
SQL>
