ASM Identifier les disque OS VS ASM

Méthode 1

• on liste les diskgroup et les disk ASM les constituants:

[grid@oracle2 ~]$ sqlplus / AS sysasm
 
SQL*Plus: RELEASE 19.0.0.0.0 - Production ON Sun Oct 26 16:59:04 2025
Version 19.3.0.0.0
 
Copyright (c) 1982, 2019, Oracle.  ALL rights reserved.
 
 
Connected TO:
Oracle Database 19c Enterprise Edition RELEASE 19.0.0.0.0 - Production
Version 19.3.0.0.0
 
SQL> SET lines 800
column disk_group_name format a30
column PATH format a50
column disk_file_name format a30
column FAILGROUP_TYPE format a20
SELECT NVL(a.name, '[CANDIDATE]') disk_group_name, b.PATH, b.name disk_file_name, a.TYPE,b.TOTAL_MB/1024 TOTAL_GB
FROM v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number)
ORDER BY a.name;
 
DISK_GROUP_NAME 	       PATH						  DISK_FILE_NAME		 TYPE	  TOTAL_GB
------------------------------ -------------------------------------------------- ------------------------------ ------ ----------
DATA			       /dev/oracleasm/disks/ASM_DATA5			  DATA_0004			 NORMAL 19.9990234
DATA			       /dev/oracleasm/disks/ASM_DATA6			  DATA_0005			 NORMAL 19.9990234
DATA			       /dev/oracleasm/disks/ASM_DATA4			  DATA_0003			 NORMAL 19.9990234
FRA			       /dev/oracleasm/disks/ASM_FRA1			  FRA_0000			 EXTERN 39.9990234
OCR			       /dev/oracleasm/disks/ASM_OCR2			  OCR_0001			 NORMAL 9.99609375
OCR			       /dev/oracleasm/disks/ASM_OCR1			  OCR_0002			 NORMAL 9.99609375
OCR			       /dev/oracleasm/disks/ASM_OCR3			  OCR_0000			 NORMAL 9.99609375

• on fait le lien entre le disque OS et le nom de disque ASM

[grid@oracle2 ~]$ blkid | grep asm
 
 
/dev/sdb1: LABEL="ASM_DATA1" TYPE="oracleasm" 
/dev/sdc1: LABEL="ASM_DATA3" TYPE="oracleasm" 
/dev/sdd1: LABEL="ASM_OCR1" TYPE="oracleasm" 
/dev/sde1: LABEL="ASM_OCR2" TYPE="oracleasm" 
/dev/sdf1: LABEL="ASM_OCR3" TYPE="oracleasm" 
/dev/sdg1: LABEL="ASM_FRA1" TYPE="oracleasm" 
/dev/sdh1: LABEL="ASM_DATA4" TYPE="oracleasm" 
/dev/sdi1: LABEL="ASM_DATA5" TYPE="oracleasm" 
/dev/sdj1: LABEL="ASM_DATA6" TYPE="oracleasm" 

• on peut éventuellement croiser avec la taille du disque

[grid@oracle2 ~]$ lsblk | grep sdg
sdg                 8:96   0   40G  0 disk 
└─sdg1              8:97   0   40G  0 part 

Méthode 2

• on liste les disques ASM

[root@oracle3 ~]# oracleasm listdisks
ASM_DATA1
ASM_DATA2
ASM_DATA3
ASM_FRA1
ASM_OCR1
ASM_OCR2
ASM_OCR3

• on liste les détails du disque ASM

[root@oracle2 bin]# oracleasm querydisk -d ASM_FRA1
Disk "ASM_FRA1" is a valid ASM disk on device [8,97]

• on liste les disques OS, ici notre disque ASM_FRA1 est le 8,97, soit dev/sdg1 <code BASH> [root@oracle3 ~]# ls -ltr /dev/sd* brw-rw—-. 1 root disk 8, 0 19 oct. 12:47 /dev/sda brw-rw—-. 1 root disk 8, 16 19 oct. 12:47 /dev/sdb brw-rw—-. 1 root disk 8, 32 19 oct. 12:47 /dev/sdc brw-rw—-. 1 root disk 8, 48 19 oct. 12:47 /dev/sdd brw-rw—-. 1 root disk 8, 64 19 oct. 12:47 /dev/sde brw-rw—-. 1 root disk 8, 96 19 oct. 12:47 /dev/sdg brw-rw—-. 1 root disk 8, 80 19 oct. 12:47 /dev/sdf brw-rw—-. 1 root disk 8, 1 19 oct. 12:47 /dev/sda1 brw-rw—-. 1 root disk 8, 17 19 oct. 12:47 /dev/sdb1 brw-rw—-. 1 root disk 8, 33 19 oct. 12:47 /dev/sdc1 brw-rw—-. 1 root disk 8, 49 19 oct. 12:47 /dev/sdd1 brw-rw—-. 1 root disk 8, 65 19 oct. 12:47 /dev/sde1 brw-rw—-. 1 root disk 8, 97 19 oct. 12:47 /dev/sdg1 brw-rw—-. 1 root disk 8, 81 19 oct. 12:47 /dev/sdf1 [root@oracle3 ~]# lsblk /dev/sdb1 NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sdb1 8:17 0 20G 0 part </code>