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 :)
