Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM disks to physical disks

3439544Apr 26 2017 — edited Apr 27 2017

Have an Oracle installation with ASM used to manage. I am in need of defining the underlying RAW file system that the DB files reside on. I have issued the following command  “show parameter asm_diskstring"

but, it points to the /dev/oracleasm/disks/* which contain files of BLOCK type. This are not the REAL files. How do I itenfify the underlying RAW file system. I have suggested a query will this give me what I need :

[root@orcldb2 ~]# /etc/init.d/oracleasm querydisk DATA01

Disk "VOL1" is a valid ASM disk on device [8, 97]

[root@orcldb2 ~]# ls -l /dev | grep 8, | grep 97

brw-rw----   1 root disk 8,      81 Nov  4 13:02 sdg1

asm_diskstring='/dev/oracleasm/disks/*'

SELECT NAME,PATH FROM v$asm_disk;

NAME PATH

-------------------- -------------------------

DATA01 ORCL:DATA01

DATA02 ORCL:DATA02

DATA06 ORCL:DATA06

DATA07 ORCL:DATA07

DATA08 ORCL:DATA08

DATA09 ORCL:DATA09

DATA10 ORCL:DATA10

DATA11 ORCL:DATA11

DATA12 ORCL:DATA12

DATA13 ORCL:DATA13

DATA14 ORCL:DATA14

DATA15 ORCL:DATA15

DATA16 ORCL:DATA16

DATA17 ORCL:DATA17

DATA18 ORCL:DATA18

DATA19 ORCL:DATA19

DATA20 ORCL:DATA20

DATA21 ORCL:DATA21

DATA22 ORCL:DATA22

DATA23 ORCL:DATA23

DATA24 ORCL:DATA24

DATA25 ORCL:DATA25

This post has been answered by 2810868 on Apr 26 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2017
Added on Apr 26 2017
14 comments
7,249 views