We have 4 disks available. We will add disk asm11 and asm12 using asmca. after that we will add asm13 and asm14 using manual method.
So run asmca
click add disk
select the disk you want to add asm 11 and asm12
click ok
disk are added
check the diskgroup size
Now we will add disk using manual method
login to asm and check avaialble disks
[oracle@ol6-112-rac1 ol6-112-rac1]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 5 13:02:27 2021
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: /as sysdba
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> sho parameter inst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
instance_name string +ASM1
instance_number integer 1
instance_type string asm
check avaialable disks. We now see only asm13 and asm14 as avaiable
SQL> SET LINESIZE 145
SET PAGESIZE 9999
SET VERIFY off
COLUMN disk_group_name FORMAT a20 HEAD 'Disk Group Name'
COLUMN disk_file_path FORMAT a17 HEAD 'Path'
COLUMN disk_file_name FORMAT a20 HEAD 'File Name'
COLUMN disk_file_fail_group FORMAT a20 HEAD 'Fail Group'
COLUMN total_mb FORMAT 999,999,999 HEAD 'File Size (MB)'
COLUMN used_mb FORMAT 999,999,999 HEAD 'Used Size (MB)'
COLUMN pct_used FORMAT 999.99 HEAD 'Pct. Used'
break on report on disk_group_name skip 1
compute sum label "" of total_mb used_mb on disk_group_name
compute sum label "Grand Total: " of total_mb used_mb on report
SELECT
NVL(a.name, '[CANDIDATE]') disk_group_name
, b.path disk_file_path
, b.name disk_file_name
, b.failgroup disk_file_fail_group
, b.total_mb total_mb
, (b.total_mb - b.free_mb) used_mb
-- , ROUND((1- (b.free_mb / b.total_mb))*100, 2) pct_used
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
ORDER BY
a.name
/
Disk Group Name Path File Name Fail Group File Size (MB) Used Size (MB)
-------------------- ----------------- -------------------- -------------------- -------------- --------------
DATA /dev/asm-disk2 DATA_0001 DATA_0001 5,114 3,152
/dev/asm-disk12 DATA_0005 DATA_0005 5,114 3,147
/dev/asm-disk3 DATA_0002 DATA_0002 5,114 3,152
/dev/asm-disk11 DATA_0004 DATA_0004 5,114 3,147
/dev/asm-disk4 DATA_0003 DATA_0003 5,114 3,151
/dev/asm-disk1 DATA_0000 DATA_0000 5,114 3,183
******************** -------------- --------------
30,684 18,932
[CANDIDATE] /dev/asm-disk13 0 0
/dev/asm-disk14 0 0
******************** -------------- --------------
0 0
-------------- --------------
Grand Total: 30,684 18,932
8 rows selected.
add the disks
SQL> ALTER DISKGROUP
DATA
ADD DISK
'/dev/asm-disk13',
'/dev/asm-disk14';
ALTER DISKGROUP
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
we see this error because we are connected as sysdba. exit and login again using sysasm and try adding the disks. it should now get added
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
[oracle@ol6-112-rac1 ol6-112-rac1]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 5 13:08:43 2021
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: /as sysasm
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
DATA
ADD DISK
'/dev/asm-disk13',
'/dev/asm-disk14';
Diskgroup altered.
check the status of the DATA DG
SET LINESIZE 145
SET PAGESIZE 9999
SET VERIFY off
COLUMN disk_group_name FORMAT a20 HEAD 'Disk Group Name'
COLUMN disk_file_path FORMAT a17 HEAD 'Path'
COLUMN disk_file_name FORMAT a20 HEAD 'File Name'
COLUMN disk_file_fail_group FORMAT a20 HEAD 'Fail Group'
COLUMN total_mb FORMAT 999,999,999 HEAD 'File Size (MB)'
COLUMN used_mb FORMAT 999,999,999 HEAD 'Used Size (MB)'
COLUMN pct_used FORMAT 999.99 HEAD 'Pct. Used'
break on report on disk_group_name skip 1
compute sum label "" of total_mb used_mb on disk_group_name
compute sum label "Grand Total: " of total_mb used_mb on report
SELECT
NVL(a.name, '[CANDIDATE]') disk_group_name
, b.path disk_file_path
, b.name disk_file_name
, b.failgroup disk_file_fail_group
, b.total_mb total_mb
, (b.total_mb - b.free_mb) used_mb
-- , ROUND((1- (b.free_mb / b.total_mb))*100, 2) pct_used
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
ORDER BY
a.name
/
Disk Group Name Path File Name Fail Group File Size (MB) Used Size (MB)
-------------------- ----------------- -------------------- -------------------- -------------- --------------
DATA /dev/asm-disk3 DATA_0002 DATA_0002 5,114 2,949
/dev/asm-disk2 DATA_0001 DATA_0001 5,114 2,953
/dev/asm-disk4 DATA_0003 DATA_0003 5,114 2,950
/dev/asm-disk11 DATA_0004 DATA_0004 5,114 2,951
/dev/asm-disk14 DATA_0007 DATA_0007 5,114 601
/dev/asm-disk13 DATA_0006 DATA_0006 5,114 600
/dev/asm-disk12 DATA_0005 DATA_0005 5,114 2,951
/dev/asm-disk1 DATA_0000 DATA_0000 5,114 2,981
******************** -------------- --------------
40,912 18,936
-------------- --------------
Grand Total: 40,912 18,936
8 rows selected.
DBATracker 