run asmca and click on drop disks
select the disk you want to drop asm-disk14 and click ok
click ok
you can see the diskgroup status
if you click add disk you will be able to see this disk as candidate disk
Drop disk manually
check current status
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-disk4 DATA_0003 DATA_0003 5,114 2,700
/dev/asm-disk3 DATA_0002 DATA_0002 5,114 2,700
/dev/asm-disk2 DATA_0001 DATA_0001 5,114 2,702
/dev/asm-disk11 DATA_0004 DATA_0004 5,114 2,700
/dev/asm-disk1 DATA_0000 DATA_0000 5,114 2,733
/dev/asm-disk13 DATA_0006 DATA_0006 5,114 2,699
/dev/asm-disk12 DATA_0005 DATA_0005 5,114 2,700
******************** -------------- --------------
35,798 18,934
[CANDIDATE] /dev/asm-disk14 0 0
******************** -------------- --------------
0 0
-------------- --------------
Grand Total: 35,798 18,934
8 rows selected.
we will drop asm-disk13.its name is DATA_0006
login as sysasm in ASM instance
SQL> ALTER DISKGROUP DATA DROP DISK DATA_0006;
Diskgroup altered.
check the status. Now you can see asm-disk13 is also avaialable as candidate disk
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,150
/dev/asm-disk3 DATA_0002 DATA_0002 5,114 3,149
/dev/asm-disk11 DATA_0004 DATA_0004 5,114 3,148
/dev/asm-disk4 DATA_0003 DATA_0003 5,114 3,151
/dev/asm-disk1 DATA_0000 DATA_0000 5,114 3,182
******************** -------------- --------------
30,684 18,932
[CANDIDATE] /dev/asm-disk13 0 0
/dev/asm-disk14 0 0
******************** -------------- --------------
0 0
-------------- --------------
Grand Total: 30,684 18,932
DBATracker 