ASM disk 추가/삭제

[ASM disk 추가 방법]

0. ASM disk 조회 및 rebalance 모니터링

 

- disk 모니터링

SQL> select * from v$asm_operation; 

SQL> select est_work from v$asm_estimate;

 

- 적용 확인

SQL>select group_number, name, allocation_unit_size alloc_unit_size, state, type, total_mb,usable_file_mb

       from v$asm_diskgroup;

 

1. raw device

-- ASM disk 추가 

 

$ export ORACLE_SID=+ASM1

$ export ORACLE_HOME=$GRID_HOME

$ sqlplus / as sysasm

 

SQL> alter diskgroup OCR add disk '/dev/raw/raw15','/dev/raw/raw14','/dev/raw/raw13' rebalance power 1024;

SQL> alter diskgroup DATA add disk '/dev/raw/raw4','/dev/raw/raw3' rebalance power 1024;

SQL> alter diskgroup MGMT add disk '/dev/raw/raw1','/dev/raw/raw2' rebalance power 1024;

 

 

-- ASM disk 삭제

 

$ export ORACLE_SID=+ASM1

$ export ORACLE_HOME=$GRID_HOME

$ sqlplus / as sysasm

 

## 삭제시 경로 명이 아닌 name 으로 진행해야 한다. ( v$asm_disk -> name 컬럼 조회)

SQL> alter diskgroup OCR drop disk 'OCR_0001','OCR_0000','OCR_0002' rebalance power 1024;

SQL> alter diskgroup DATA drop disk 'DATA_0001','DATA_0000' rebalance power 1024;

SQL> alter diskgroup MGMT drop disk 'MGMT_0000','MGMT_0001' rebalance power 1024;

 

 

 

2. ASM device (oracleasm)

-- ASM disk 추가 

 

$ export ORACLE_SID=+ASM1

$ export ORACLE_HOME=$GRID_HOME

$ sqlplus / as sysasm

 

alter diskgroup OCR add disk 'OCR_0001','OCR_0000','OCR_0002' rebalance power 1024;

alter diskgroup DATA add disk 'DATA_0001','DATA_0000' rebalance power 1024;

alter diskgroup MGMT add disk 'MGMT_0000','MGMT_0001' rebalance power 1024;

 

 

-- ASM disk 삭제

 

 

$ export ORACLE_SID=+ASM1

$ export ORACLE_HOME=$GRID_HOME

$ sqlplus / as sysasm

 

alter diskgroup DATA drop disk 'ORCL:DATA101','ORCL:DATA102','ORCL:DATA103' rebalance power 1024;

alter diskgroup RECO drop disk 'ORCL:RECO201','ORCL:RECO202','ORCL:RECO203' rebalance power 1024;

alter diskgroup CRS drop disk 'ORCL:CRS301','ORCL:CRS302','ORCL:CRS303' rebalance power 1024;

alter diskgroup MGMT drop disk 'ORCL:GIMR401','ORCL:GIMR402','ORCL:GIMR403' rebalance power 1024;