Add Disk to ASM Diskgroup

1> Identify the Diskgroup to add disk:

SQL> select group_number, name from v$asm_diskgroup;

2> Identify the candidate disk:

SQL> SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;

3> Create oracle ASM disk

/usr/sbin/oracleasm createdisk RMAN /dev/mapper/mpathg

4> Scan all oracle ASM disk after addition:

[root@database1 ~]# /usr/sbin/oracleasm scandisks

5> Ensure all oracle ASM disk after scanning as follow:

[root@database1 ~]# /usr/sbin/oracleasm listdisks

6> Add the newly created oracle ASM disk to existing ASM diskgroup

SQL> ALTER DISKGROUP DATA ADD DISK ‘/dev/oracleasm/disks/RMAN’ NAME DATA_0003 REBALANCE POWER 11;

7> Check the rebalance time:

select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES

8> Check status:

SQL> SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;

set head on
column name format a15
column DG# format 99
select group_number DG#, name, state, type, total_mb, free_mb, round(free_mb/total_mb*100,2) pct_free from
v$asm_diskgroup order by pct_free;