• Arun Kumar

Find ASM physical disk mapping

When you work in a RAC environment with a list of ASM disks, sometimes you might want to figure out which ASM disk is mapped to which physical device. Below is a simple script that will help you find out ASM disks that are mapped to Linux partitions


ASM Disk mapping script

#!/bin/bash
ORACLEASM=/etc/init.d/oracleasm
echo "ASM Disk Mappings"
echo "----------------------------------------------------"
for f in `$ORACLEASM listdisks`
do
dp=`$ORACLEASM querydisk -p  $f | head -2 | grep /dev | awk -F: '{print $1}'`
echo "$f: $dp"
done


Sample output

And below is the sample output:

ASM Disk Mappings
----------------------------------------------------
CRSDISK1: /dev/sdb3
DATADISK1: /dev/sdb1
FRADISK1: /dev/sdb2


95 views

Recent Posts

See All

Zero downtime ASM migration

This article is part of our video course Oracle RAC DBA video course. Enroll into the course today to start learning oracle rac online. In your environment, you might require to migrate ASM disks from

Create Diskgroup Sqlplus Command

In this article we will be creating new ASM diskgroup using SQLPLUS command while connected to ASM instance. You must have an unused partition / disk on the server that can be used to create ASM diskg

Create Tablespace in Oracle ASM

CHECK BELOW PARAMETERS DB_CREATE_FILE_DEST DB_RECOVERY_FILE_DEST DB_RECOVERY_FILE_DEST_SIZE CREATE TABLESPACE SQL> CREATE TABLESPACE test_tbs; In ASM datafiles / tempfiles are create with 100mb initia

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback