RE: Disk/Partitions under ASM DiskGroup

Shiva,

Something like this:
select substr(path,1,20) path,group_number,substr(name,1,12) name, mode_status, state, disk_number,mount_status from v$asm_disk
order by name
;
Will tell you what asm named disks are in each diskgroup.

Then
cd /dev/oracleasm/disks
ls -l
brw-rw---- 1 oracle oinstall 8, 176 May 11 15:19 DISK11

will give you the linux info. Then

/cd dev
ls -l | grep '8, 176'
brw-rw---- 1 root disk 8, 176 Jun 24 2004 sdl

will tell you the logical drive(sdl).

I am not sure how to tell if it is partitioned via fdisk or not.

Randy

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Shivaswamy Raghunath
> Sent: Friday, November 17, 2006 11:47 AM
> To: oracle-l_at_freelists.org
> Subject: Disk/Partitions under ASM DiskGroup
>
> Hello.
>
> I have not been able to find a view or a way to list the disk/disk
> partitions under an ASM Disk group, inside Oracle. Say, on my disk
group
> ORCL:VOL1, what are the disk partitions I have. (I know it is
/dev/sda5,
> /dev/sda6). But how do I list it?
>
> Can you help me?
>
> Thanks,
> Shiva

--
http://www.freelists.org/webpage/oracle-l