Add and drop some disk in ASM

Adding and dropping disk in ASM

sqlplus "/as sysasm"

set lines 200

set pages 1000

col path format a36

col name format a22

col failgroup format a20

col label format a15

col type format a15

col header_status format a20

To see information about disk 

select GROUP_NUMBER,DISK_NUMBER,PATH,NAME,FAILGROUP,MOUNT_STATUS,HEADER_STATUS,STATE,TOTAL_MB,FREE_MB from v$asm_disk;

select GROUP_NUMBER,NAME,BLOCK_SIZE,STATE,TYPE,TOTAL_MB,FREE_MB,USABLE_FILE_MB,REQUIRED_MIRROR_FREE_MB,OFFLINE_DISKS,COMPATIBILITY, DATABASE_COMPATIBILITY from v$asm_diskgroup;

To see only candidate disk

column path format  a40

Select PATH,GROUP_NUMBER,DISK_NUMBER,MOUNT_Status, HEADER_STATUS, TOTAL_MB, create_date

  from v$asm_disk

where header_status='CANDIDATE'

order by path;

To check if It is running any rebalance operation
SELECT * FROM GV$ASM_OPERATION;
or
asmcmd lsop

to add some disks to a disk group (this case with failgroup)

alter diskgroup DBIG_SBCSIGE_32K add

failgroup FG78012EC disk

'/dev/asm-[...]'

failgroup FG78012EB disk

'/dev/asm-[...]'

rebalance power 4

/

SELECT * FROM GV$ASM_OPERATION;

asmcmd lsop

To drop some disk 

ALTER DISKGROUP DBIG_SBCSIGE_32K DROP disk DBIG_SBCSIGE_32K_0013, DBIG_SBCSIGE_32K_0012 rebalance power 4;

SELECT * FROM GV$ASM_OPERATION;

asmcmd lsop