Skip to Main Content

Oracle Database Discussions

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!

How to determine raw disks configured for OCR/voting disk, ASM spfile

677708Dec 30 2008
I have a two-node Oracle 10gR2 RAC configuration using raw disks. Basically, raw disks are used for CRS's OCR/voting disks, ASM's ASM spfile and disk groups.

Is there a better way to figure out what raw disks are configured in Oracle using methods other than those shown below:

- To find out votedisk:
# crsctl query css votedisk
0. 0 /dev/ora_crs_vote1
1. 0 /dev/ora_crs_vote2
2. 0 /dev/ora_crs_vote3

- To find out OCR:
# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 525836
Used space (kbytes) : 3856
Available space (kbytes) : 521980
ID : 1603037329
Device/File Name : /dev/ora_ocr_file1
Device/File integrity check succeeded
Device/File Name : /dev/ora_ocr_file2
Device/File integrity check succeeded

Cluster registry integrity check succeeded

- Is there a way to figure out what disk device is used for ASM spfile?

- To find out raw disks configured for disk groups:
while connected to the ASM instance in sqlplus:

SQL> select name,path from v$asm_disk where name like 'DG%';

NAME
-----
PATH
-----
DG_DC_ASM_0000
/dev/rhdiskpower13

DG_DC_ASM_0001
/dev/rhdiskpower14

DG_DC_ASM_0002
/dev/rhdiskpower15

NAME


-----
PATH
-----
DG_DC_ASM_0003
/dev/rhdiskpower22
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 27 2009
Added on Dec 30 2008
0 comments
662 views