SQL> startup pfile='/oracle/product/10.2/db/dbs/asm.ora';
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1265912 bytes
Variable Size 57454344 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_asm_ausize integer 4194304
_asm_stripesize integer 524288
asm_diskgroups string DATA01
asm_diskstring string /dev/sdb, /dev/sdc
asm_power_limit integer 1
SQL>
SQL>
SQL> create diskgroup htdata external redundancy disk '/dev/sdd','/dev/sde';
create diskgroup htdata external redundancy disk '/dev/sdd','/dev/sde'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/sde' matches no disks
ORA-15014: location '/dev/sde' is not in the discovery set
ORA-15031: disk specification '/dev/sdd' matches no disks
ORA-15014: location '/dev/sdd' is not in the discovery set
SQL> alter system set asm_diskstring='/dev/sd*';
System altered.
SQL> create diskgroup htdata external redundancy disk '/dev/sdd','/dev/sde';
Diskgroup created.
SQL>
SQL> SET LINESIZE 145
SQL> SET PAGESIZE 9999
SQL> SET VERIFY off
SQL>
SQL> COLUMN group_name FORMAT a20 HEAD 'Disk Group|Name'
SQL> COLUMN sector_size FORMAT 99,999 HEAD 'Sector|Size'
SQL> COLUMN block_size FORMAT 99,999 HEAD 'Block|Size'
SQL> COLUMN allocation_unit_size FORMAT 999,999,999 HEAD 'Allocation|Unit Size'
SQL> COLUMN state FORMAT a11 HEAD 'State'
SQL> COLUMN type FORMAT a6 HEAD 'Type'
SQL> COLUMN total_mb FORMAT 999,999,999 HEAD 'Total Size (MB)'
SQL> COLUMN used_mb FORMAT 999,999,999 HEAD 'Used Size (MB)'
SQL> COLUMN pct_used FORMAT 999.99 HEAD 'Pct. Used'
SQL>
SQL> break on report on disk_group_name skip 1
SQL>
SQL> compute sum label "Grand Total: " of total_mb used_mb on report
SQL>
SQL> SELECT
2 name group_name
3 , sector_size sector_size
4 , block_size block_size
5 , allocation_unit_size allocation_unit_size
6 , state state
7 , type type
8 , total_mb total_mb
9 , (total_mb - free_mb) used_mb
10 , ROUND((1- (free_mb / total_mb))*100, 2) pct_used
11 FROM
12 v$asm_diskgroup
13 ORDER BY
14 name
15 /
Disk Group Sector Block Allocation
Name Size Size Unit Size State Type Total Size (MB) Used Size (MB) Pct. Used
-------------------- ------- ------- ------------ ----------- ------ --------------- -------------- ---------
DATA01 512 4,096 1,048,576 MOUNTED NORMAL 5,324 102 1.92
HTDATA 512 4,096 4,194,304 MOUNTED EXTERN 2,048 80 3.91
--------------- --------------
Grand Total: 7,372 182
SQL>
SQL>
SQL> !
[oracle@roger admin]$ kfed read /dev/sdd|grep kfdhdb
kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8
kfdhdb.driver.reserved[0]: 0 ; 0x008: 0x00000000
kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: HTDATA_0000 ; 0x028: length=11
kfdhdb.grpname: HTDATA ; 0x048: length=6
kfdhdb.fgname: HTDATA_0000 ; 0x068: length=11
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32953167 ; 0x0a8: HOUR=0xf DAYS=0x1a MNTH=0x4 YEAR=0x7db
kfdhdb.crestmp.lo: 87596032 ; 0x0ac: USEC=0x0 MSEC=0x227 SECS=0x13 MINS=0x1
kfdhdb.mntstmp.hi: 32953167 ; 0x0b0: HOUR=0xf DAYS=0x1a MNTH=0x4 YEAR=0x7db
kfdhdb.mntstmp.lo: 98738176 ; 0x0b4: USEC=0x0 MSEC=0xa8 SECS=0x1e MINS=0x1
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 4194304 ; 0x0bc: 0x00400000
kfdhdb.mfact: 454272 ; 0x0c0: 0x0006ee80
kfdhdb.dsksize: 256 ; 0x0c4: 0x00000100
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002