Identify ASM disk to physical disk

Identify ASM disk on ASM instance :

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  /
DISK_GROUP                     DISK_NUMBER DISK_NAME
------------------------------ ----------- ------------------------------
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

No comments:

Post a Comment