FAQ
Greetings,

I hope this isn't a naïve question but anyway, I am using ASM on a two node RAC cluster, Oracle 10.2.0.3.0 SE on Red Hat EL4. The raw devices look like this...

crw-rw---- 1 root dba 162, 1 May 6 14:45 /dev/raw/raw1
crw-rw---- 1 oracle dba 162, 10 May 6 14:45 /dev/raw/raw10
crw-rw---- 1 oracle dba 162, 11 May 7 10:36 /dev/raw/raw11
crw-rw---- 1 root dba 162, 2 May 6 14:45 /dev/raw/raw2
crw-r--r-- 1 oracle dba 162, 3 May 6 14:45 /dev/raw/raw3
crw-r--r-- 1 oracle dba 162, 5 May 6 14:45 /dev/raw/raw5
crw-r--r-- 1 oracle dba 162, 6 May 6 14:45 /dev/raw/raw6
crw-rw---- 1 oracle dba 162, 7 May 6 14:45 /dev/raw/raw7
crw-rw---- 1 oracle dba 162, 8 May 6 14:45 /dev/raw/raw8
crw-rw---- 1 oracle dba 162, 9 May 6 14:45 /dev/raw/raw9

I know which are used for the CRS and voting disks but I am trying to determine which of the others make up the ASM disk groups and I can't find information on how to do that. The disk groups have been provisioned using asmlib. Querying v$asm_disk returns the following...

SQL> select group_number,name,substr(path,1,30) from v$asm_disk;

GROUP_NUMBER NAME SUBSTR(PATH,1,30)
------------ ------------------------------ ------------------------------
0 /dev/raw/raw10
0 /dev/raw/raw9
0 /dev/raw/raw8
0 /dev/raw/raw7
0 /dev/raw/raw6
0 /dev/raw/raw5
0 /dev/raw/raw3
0 /dev/raw/raw11
0 /dev/raw/raw1
0 /dev/raw/raw2
1 VOL1 ORCL:VOL1
1 VOL2 ORCL:VOL2
2 VOL3 ORCL:VOL3

For example which of the raw devices are mapped to VOL1? I suspect I am not understanding something or else just have not found the appropriate view to query but if someone can help me out I would be most appreciative.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

Search Discussions

  • Bradd Piontek at May 8, 2008 at 4:50 pm
    You may want to use '/etc/init.d/oracldasm with the querydisk option.
    this should give you the device numbers for that particular disk.

    ex.
    /etc/init.d/oracleasm querydisk DATA100_0019
    Disk "DATA100_0019" is a valid ASM disk on device [120, 113]

    I think go to the device directory and see what 120,113 corresponds to.
    On 5/8/08, William Wagman wrote:

    Greetings,

    I hope this isn't a naïve question but anyway, I am using ASM on a two
    node RAC cluster, Oracle 10.2.0.3.0 SE on Red Hat EL4. The raw devices look
    like this...

    crw-rw---- 1 root dba 162, 1 May 6 14:45 /dev/raw/raw1
    crw-rw---- 1 oracle dba 162, 10 May 6 14:45 /dev/raw/raw10
    crw-rw---- 1 oracle dba 162, 11 May 7 10:36 /dev/raw/raw11
    crw-rw---- 1 root dba 162, 2 May 6 14:45 /dev/raw/raw2
    crw-r--r-- 1 oracle dba 162, 3 May 6 14:45 /dev/raw/raw3
    crw-r--r-- 1 oracle dba 162, 5 May 6 14:45 /dev/raw/raw5
    crw-r--r-- 1 oracle dba 162, 6 May 6 14:45 /dev/raw/raw6
    crw-rw---- 1 oracle dba 162, 7 May 6 14:45 /dev/raw/raw7
    crw-rw---- 1 oracle dba 162, 8 May 6 14:45 /dev/raw/raw8
    crw-rw---- 1 oracle dba 162, 9 May 6 14:45 /dev/raw/raw9

    I know which are used for the CRS and voting disks but I am trying to
    determine which of the others make up the ASM disk groups and I can't find
    information on how to do that. The disk groups have been provisioned using
    asmlib. Querying v$asm_disk returns the following...

    SQL> select group_number,name,substr(path,1,30) from v$asm_disk;

    GROUP_NUMBER NAME SUBSTR(PATH,1,30)
    ------------ ------------------------------ ------------------------------
    0 /dev/raw/raw10
    0 /dev/raw/raw9
    0 /dev/raw/raw8
    0 /dev/raw/raw7
    0 /dev/raw/raw6
    0 /dev/raw/raw5
    0 /dev/raw/raw3
    0 /dev/raw/raw11
    0 /dev/raw/raw1
    0 /dev/raw/raw2
    1 VOL1 ORCL:VOL1
    1 VOL2 ORCL:VOL2
    2 VOL3 ORCL:VOL3
    For example which of the raw devices are mapped to VOL1? I suspect I am
    not understanding something or else just have not found the appropriate view
    to query but if someone can help me out I would be most appreciative.

    Thanks.

    Bill Wagman
    Univ. of California at Davis
    IET Campus Data Center
    wjwagman_at_ucdavis.edu
    (530) 754-6208


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

    --
    http://www.freelists.org/webpage/oracle-l
  • William Wagman at May 8, 2008 at 10:05 pm
    Bradd,



    Thanks, that is what I have been looking for.



    Bill Wagman
    Univ. of California at Davis
    IET Campus Data Center
    wjwagman_at_ucdavis.edu
    (530) 754-6208

    From: Bradd Piontek
    Sent: Thursday, May 08, 2008 9:50 AM
    To: William Wagman
    Cc: oracle-l_at_freelists.org
    Subject: Re: Question re asm disks



    You may want to use '/etc/init.d/oracldasm with the querydisk option. this should give you the device numbers for that particular disk.

    ex.
    /etc/init.d/oracleasm querydisk DATA100_0019
    Disk "DATA100_0019" is a valid ASM disk on device [120, 113]

    I think go to the device directory and see what 120,113 corresponds to.

    On 5/8/08, William Wagman wrote:

    Greetings,

    I hope this isn't a naïve question but anyway, I am using ASM on a two node RAC cluster, Oracle 10.2.0.3.0 SE on Red Hat EL4. The raw devices look like this...

    crw-rw---- 1 root dba 162, 1 May 6 14:45 /dev/raw/raw1
    crw-rw---- 1 oracle dba 162, 10 May 6 14:45 /dev/raw/raw10
    crw-rw---- 1 oracle dba 162, 11 May 7 10:36 /dev/raw/raw11
    crw-rw---- 1 root dba 162, 2 May 6 14:45 /dev/raw/raw2
    crw-r--r-- 1 oracle dba 162, 3 May 6 14:45 /dev/raw/raw3
    crw-r--r-- 1 oracle dba 162, 5 May 6 14:45 /dev/raw/raw5
    crw-r--r-- 1 oracle dba 162, 6 May 6 14:45 /dev/raw/raw6
    crw-rw---- 1 oracle dba 162, 7 May 6 14:45 /dev/raw/raw7
    crw-rw---- 1 oracle dba 162, 8 May 6 14:45 /dev/raw/raw8
    crw-rw---- 1 oracle dba 162, 9 May 6 14:45 /dev/raw/raw9

    I know which are used for the CRS and voting disks but I am trying to determine which of the others make up the ASM disk groups and I can't find information on how to do that. The disk groups have been provisioned using asmlib. Querying v$asm_disk returns the following...

    SQL> select group_number,name,substr(path,1,30) from v$asm_disk;

    GROUP_NUMBER NAME SUBSTR(PATH,1,30)
    ------------ ------------------------------ ------------------------------
    0 /dev/raw/raw10
    0 /dev/raw/raw9
    0 /dev/raw/raw8
    0 /dev/raw/raw7
    0 /dev/raw/raw6
    0 /dev/raw/raw5
    0 /dev/raw/raw3
    0 /dev/raw/raw11
    0 /dev/raw/raw1
    0 /dev/raw/raw2
    1 VOL1 ORCL:VOL1
    1 VOL2 ORCL:VOL2
    2 VOL3 ORCL:VOL3

    For example which of the raw devices are mapped to VOL1? I suspect I am not understanding something or else just have not found the appropriate view to query but if someone can help me out I would be most appreciative.

    Thanks.

    Bill Wagman
    Univ. of California at Davis
    IET Campus Data Center
    wjwagman_at_ucdavis.edu
    (530) 754-6208

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 8, '08 at 4:37p
activeMay 8, '08 at 10:05p
posts3
users2
websiteoracle.com

2 users in discussion

William Wagman: 2 posts Bradd Piontek: 1 post

People

Translate

site design / logo © 2022 Grokbase