run asmca and click create
i am selecting external redundancy and using asm-disk13 and click ok
we can see that diskgroup is created
to create diskgroup manually
check the avaialble disk
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 3,151
/dev/asm-disk12 DATA_0005 DATA_0005 5,114 3,150
/dev/asm-disk3 DATA_0002 DATA_0002 5,114 3,149
/dev/asm-disk2 DATA_0001 DATA_0001 5,114 3,152
/dev/asm-disk11 DATA_0004 DATA_0004 5,114 3,148
/dev/asm-disk1 DATA_0000 DATA_0000 5,114 3,182
******************** -------------- --------------
30,684 18,932
FRA /dev/asm-disk13 FRA_0000 FRA_0000 5,114 95
******************** -------------- --------------
5,114 95
[CANDIDATE] /dev/asm-disk14 0 0
******************** -------------- --------------
0 0
-------------- --------------
Grand Total: 35,798 19,027
8 rows selected.
we will use asm-disk14 to create a diskgroup name REDO
loing into ASM as sysasm
SQL> CREATE DISKGROUP REDO EXTERNAL REDUNDANCY DISK '/dev/asm-disk14';
Diskgroup created.
verify the status
Disk Group Name Path File Name Fail Group File Size (MB) Used Size (MB)
-------------------- ----------------- -------------------- -------------------- -------------- --------------
DATA /dev/asm-disk3 DATA_0002 DATA_0002 5,114 3,149
/dev/asm-disk2 DATA_0001 DATA_0001 5,114 3,152
/dev/asm-disk4 DATA_0003 DATA_0003 5,114 3,151
/dev/asm-disk11 DATA_0004 DATA_0004 5,114 3,148
/dev/asm-disk1 DATA_0000 DATA_0000 5,114 3,182
/dev/asm-disk12 DATA_0005 DATA_0005 5,114 3,150
******************** -------------- --------------
30,684 18,932
FRA /dev/asm-disk13 FRA_0000 FRA_0000 5,114 95
******************** -------------- --------------
5,114 95
REDO /dev/asm-disk14 REDO_0000 REDO_0000 5,114 50
******************** -------------- --------------
5,114 50
-------------- --------------
Grand Total: 40,912 19,077
8 rows selected.
DBATracker 