How to add ASM disk to ASM Diskgroup

1. Login to the ASM instance

-bash-3.2$ ps -ef|grep pmon

oracle    1829     1  0 Jul21 ?        00:04:58 ora_pmon_PROD1

oracle    9529  8780  0 21:18 pts/0    00:00:00 grep pmon

oracle   16319     1  0  2014 ?        00:10:46 asm_pmon_+ASM1

-bash-3.2$ . oraenv

ORACLE_SID = [oracle] ? +ASM1

The Oracle base has been set to /u01/oracle/product

-bash-3.2$

-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 24 21:18:43 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

2. Identify the disks to be added to the ASM diskgroup

SQL> select name,group_number,state,total_mb/1024 "Totalspace(GB)",free_mb/1024 "Freespace(GB)", (free_mb/total_mb)*100 "PCT_FREE" from v$asm_diskgroup;

NAME                 GROUP_NUMBER STATE       Totalspace(GB) Freespace(GB)   PCT_FREE

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

SIVA_DBF01                               8 MOUNTED               600    82.396484 13.6675571

SQL> col path for a45

Select path,group_number,disk_number,mount_status,header_status,os_mb/1024,total_mb/1024,free_mb/1024 from v$asm_disk where group_number=&n;

Enter value for n: 8

old   1: Select path,group_number,disk_number,mount_status,header_status,os_mb/1024,total_mb/1024,free_mb/1024 from v$asm_disk where group_number=&n

new   1: Select path,group_number,disk_number,mount_status,header_status,os_mb/1024,total_mb/1024,free_mb/1024 from v$asm_disk where group_number=8

PATH                                          GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU OS_MB/1024 TOTAL_MB/1024 FREE_MB/1024

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

ORCL:SIVA_ASM01                                         8          01 CACHED  MEMBER              200           200   28.7119141

ORCL:SIVA_ASM02                                         8          02 CACHED  MEMBER              200           200   28.7089844

ORCL:SIVA_ASM03                                         8          03 CACHED  MEMBER              200           200   28.7207031

SQL> Select path,group_number,disk_number,mount_status,header_status,os_mb/1024,total_mb/1024,free_mb/1024 from v$asm_disk where header_status <>'MEMBER';

PATH                                          GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU OS_MB/1024 TOTAL_MB/1024 FREE_MB/1024

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

ORCL:SIVA_ASM04                                         0           4 CLOSED  PROVISIONED         200             0            0

ORCL:SIVA_ASM05                                         0           5 CLOSED  PROVISIONED         200             0            0

ORCL:SIVA_ASM06                                         0           6 CLOSED  PROVISIONED         200             0            0

3. Add the disk to the Diskgroup

SQL> alter diskgroup SIVA_DBF01 add disk 'ORCL:SIVA_ASM04' name SIVA_ASM04 size 204800m;

alter diskgroup SIVA_DBF01 add disk 'ORCL:SIVA_ASM04' name SIVA_ASM04 size 204800m

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15260: permission denied on ASM disk group

Note:

****

For adding a disk to the diskgroup you need to login as a SYSASM not SYSDBA.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

-bash-3.2$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 24 21:24:33 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup SIVA_DBF01 add disk 'ORCL:SIVA_ASM04' name SIVA_ASM04 size 204800m rebalance power 4;

Diskgroup altered.

SQL>  select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE

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

           8 REBAL RUN           4          4        972     154322       4344          35

Happy Learning :)