Re: List disk/disk partition of the diskgroup

  • From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
  • To: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
  • Date: Mon, 30 Oct 2006 12:50:23 -0500

Thank you, Randy.

I get this:
[oracle@lin2 disks]$ pwd
/dev/oracleasm/disks
[oracle@lin2 disks]$ ls -l
total 0
brw-rw----  1 oracle dba 8, 2 Oct 29 13:26 VOL1
brw-rw----  1 oracle dba 8, 3 Oct 29 13:26 VOL2
brw-rw----  1 oracle dba 8, 4 Oct 29 13:26 VOL3

Actually I want to be able to query the disk/disk partition name underlying
the DiskGroup.

Can you someone help?

Thanks,
Shiva

On 10/30/06, Steiner, Randy <Randy.Steiner@xxxxxxxx> wrote:

Is this what your looking for:

To associate an ASM disk with a linux device:
cd /dev/oracleasm/disks
ls -l
brw-rw----    1 oracle   oinstall   8, 176 May 11 15:19 DISK11
brw-rw----    1 oracle   oinstall   8, 208 May 11 15:19 DISK12
brw-rw----    1 oracle   oinstall   8, 224 May 11 15:19 DISK13
brw-rw----    1 oracle   oinstall   8, 240 May 11 15:19 DISK14
brw-rw----    1 oracle   oinstall   8, 160 May 11 15:19 DISK15
brw-rw----    1 oracle   oinstall   8,  32 May 11 15:19 DISK2
brw-rw----    1 oracle   oinstall   8,  48 May 11 15:19 DISK3
brw-rw----    1 oracle   oinstall   8,  64 May 11 15:19 DISK4
brw-rw----    1 oracle   oinstall   8,  80 May 11 15:19 DISK5
brw-rw----    1 oracle   oinstall   8,  96 May 11 15:19 DISK6
brw-rw----    1 oracle   oinstall   8, 112 May 11 15:19 DISK7
brw-rw----    1 oracle   oinstall   8, 128 May 11 15:19 DISK8
brw-rw----    1 oracle   oinstall   8, 144 May 11 15:19 DISK9

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




> -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Shivaswamy Raghunath > Sent: Monday, October 30, 2006 7:03 AM > To: Hallas, John > Cc: valpis@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx > Subject: Re: List disk/disk partition of the diskgroup > > Thank you everybody. But I am not able to list what I want from these. May > be I did not explain well. > > While creating the ASMDISK during installation, I had used: > # /etc/init.d/oracleasm createdisk VOL1 /dev/sda2 > > I want to see "/dev/sda2" in my listing now (preferably) in an ASM > Instance or a database instance. And I do not know how to do it. If you > know, can you share it? > > > > On 10/30/06, Hallas, John <john.hallas@xxxxxxx > wrote: > > Quite a good script which provides a lot of information in one go > > clear columns > > > set wrap off > set lines 200 > set pages 999 > col "Group" form 999 > col "Group Name" form a25 > col "Disk Name" form a30 > col "State" form a15 > col "Type" form a7 > > prompt > prompt ASM Disk Groups > prompt =============== > select group_number "Group" > , name "Group Name" > , state "State" > , type "Type" > , total_mb/1024 "Total GB" > , free_mb/1024 "Free GB" > from v$asm_diskgroup > / > > > prompt > prompt ASM Disks > prompt ========= > > col "Group" form 999 > col "Disk" form 999 > col "Header" form a9 > col "Mode" form a8 > col "Redundancy" form a10 > col "Failure Group" form a30 > col "Path" form a16 > > select group_number "Group" > , disk_number "Disk" > , header_status "Header" > , mode_status "Mode" > , state "State" > , redundancy "Redundancy" > , total_mb "Total MB" > , free_mb "Free MB" > , name "Disk Name" > , failgroup "Failure Group" > , path "Path" > from v$asm_disk > order by group_number > , disk_number > / > > prompt > prompt Instances currently accessing these diskgroups > prompt ============================================== > col "Instance" form a8 > select c.group_number "Group" > , g.name <http://g.name> "Group Name" > , c.instance_name "Instance" > from v$asm_client c > , v$asm_diskgroup g > where g.group_number=c.group_number > / > > prompt > prompt Current ASM disk operations > prompt =========================== > select * > from v$asm_operation > / > > clear columns > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto: oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Eriksson > Sent: Monday, October 30, 2006 9:20 AM > To: shivaswamykr@xxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: List disk/disk partition of the diskgroup > > Hi > > Try this: > $ /etc/init.d/oracleasm > Usage: /etc/init.d/oracleasm > {start|stop|restart|enable|disable|configure|createdisk|deletedisk|q > uery > disk|listdisks|scandisks|status} > > /johan > > On 10/30/06, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx > wrote: > > Hello. > > > > I could not find a way to list the disk or disk partition > underlying > > the disk group in any of the ASM views. Can you help me? > > > > Thanks, > > Shiva > -- > //www.freelists.org/webpage/oracle-l > > > >


Other related posts: