SQL>
select g.name disk_group
,d.DISK_NUMBER
,d.name disk_name
,d.PATH
,d.TOTAL_MB
,d.header_status
from v$asm_disk d,
v$asm_diskgroup g
where d.GROUP_NUMBER = g.GROUP_NUMBER (+)
order by g.name, d.disk_numberSQL> 2 3 4 5 6 7 8 9 10
11 /
select g.name disk_group
,d.DISK_NUMBER
,d.name disk_name
,d.PATH
,d.TOTAL_MB
,d.header_status
from v$asm_disk d,
v$asm_diskgroup g
where d.GROUP_NUMBER = g.GROUP_NUMBER (+)
order by g.name, d.disk_numberSQL> 2 3 4 5 6 7 8 9 10
11 /
DISK_GROUP DISK_NUMBER DISK_NAME
------------------------------ ----------- ------------------------------
PATH
--------------------------------------------------------------------------------
TOTAL_MB HEADER_STATU
---------- ------------
DATA 0 DATA_0000
/dev/oracleasm/disks/NYCOEMDATA00
306176 MEMBER
------------------------------ ----------- ------------------------------
PATH
--------------------------------------------------------------------------------
TOTAL_MB HEADER_STATU
---------- ------------
DATA 0 DATA_0000
/dev/oracleasm/disks/NYCOEMDATA00
306176 MEMBER
[oracle@oem01
etc]$ cd /dev/oracleasm
[oracle@oem01
oracleasm]$ cd disks
[oracle@oem01
disks]$ ls
OEMDATA00
[oracle@oem01
disks]$ ls -la
total 0
drwxr-xr-x. 1
root root 0 May 29 15:04 .
drwxr-xr-x. 4
root root 0 May 29 15:04 ..
brw-------. 1
oracle oinstall 8, 49 Sep 28 09:06 OEMDATA00
[oracle@oem01
disks]$ oracleasm listdisks
OEMDATA00
[oracle@oem01
disks]$ oracleasm querydisk -d OEMDATA00
Disk
"OEMDATA00" is a valid ASM disk on device [8,49]
[oracle@oem01
disks]$ ls -l /dev/* | grep 8, | grep 49
brw-rw----. 1
root disk 8, 49 May 29 15:41 /dev/sdd1
From fdisk -l command :
Disk /dev/sdd: 322.1 GB, 322122547200 bytes, 629145600 sectors