This content has been marked as final. Show 15 replies
take a look into the documentation.
The number of voting files you can store in a particular Oracle ASM disk group depends upon the redundancy of the disk group. External redundancy: A disk group with external redundancy can store only one voting disk Normal redundancy: A disk group with normal redundancy stores three voting disks High redundancy: A disk group with high redundancy stores five voting disks
to change your redundancy level of your cluster diskgroup you mus recreate the diskgroup. If you have enough disks you can also create it normal or high redundancy to have more voting disks.
Also one option is to create a second diskgroup and recreate your voting files to the new diskgroup.
Thanks again for suggestion. However this is our prod environment, and it is hard to request storage again for voting diskgroup.
Can I perform those steps:
1). move spfile, vote disk and ocr to another diskgroup called +FRA temporary.
2). Drop the ocr_vote diskgroup and recreate it with three disks with normal redendancy.
3). Move spfile , vote disk and OCR back to OCR_VOTE diskgroup just created in step 2.
If those three steps working, will that create any outage?
and how do we sure only spfile, votedisk,OCR are the only things existed in +OCR_VOTE?
If you can read German, you can see here a description of moving spfiles/OCR and Vote:
So yes in essence this is what needs to be done. However you copy the spfile, you don't move it....
OCR and VOTE can be done online. Unfortunately the change of the spfile cannot. since you cannot drop the diskgroup containing the running spfile.
What you could do alternatively is remove some disks from the diskgroup that you are left with one, and prepare everything in advance (which all can be done online).
On the next reboot it will pick up the new spfile and then you can drop the last disk from the diskgroup.
Check with ASMCMD and you can browse which files are in OCR_VOTE.
Alternatively query v$asm_file and v$asm_alias
Thank you for response.
I checked asmcmd, and under voting diskgroup, there are two folders:
ASMCMD> cd ASMPARAMETERFILE/
ASMPARAMETERFILE UNPROT COARSE FEB 14 2012 Y REGISTRY.253.775250583
ASMCMD> cd ocrfile
OCRFILE UNPROT COARSE NOV 28 01:00:00 Y REGISTRY.255.775250583
our DB spfile per show parameter spfile , it shows it stored at DAT diskgroup instead of vote diskgroup.
So my questions here are:
1). since spfile in database shows:
SQL> show parameter spfile
spfile string +DAT/prd/spfileprd.ora
The spfile under vote diskgroup must be for ASM instance. How do I move that? seems have to bounce asm to move it somewhere else. that will cause some disturbance to the services.
2). is that under OCR_file, the ocr file including voting disks?
Since OCR files are mirrored like this:
Status of Oracle Cluster Registry is as follows :
ID : 546691893
Device/File Name : +OCR_VOTE
Device/File integrity check succeeded
Device/File Name : +FRA
Device/File integrity check succeeded
Is that means I can delete the one at vote disk and the one on FRA should still serve the purpose?
Note that normal redundancy created 3 voting disks.
Also A normal redundancy disk group must contain at least two failure groups.
ORA-01031: insufficient privileges
How to Change Oracle DBNAME and DBID
the redundancy level defines the way asm mirror your disk. In external redundancy the mirroring is done (external) on your storage so you only need one failgroup. In normal redundancy for example you make a two way mirroring or in high redundancy you make 3 way mirroring. If you let asm make your mirroring you need 2 or more failgroups (depend on your redundancy level). Every failgroup must consist at least of one disk.
For more information see.
also from the documentation, and your answer is YES and YES two disk 3 voting.
Normal redundancy In a normal redundancy disk group, to increase performance and reliability, Oracle ASM by default uses two-way mirroring. A normal redundancy disk group requires a minimum of two disk devices (or two failure groups). The effective disk space in a normal redundancy disk group is half the sum of the disk space in all of its devices. For Oracle Clusterware files, Normal redundancy disk groups provide 3 voting disk files, 1 OCR and 2 copies (one primary and one secondary mirror). With normal redundancy, the cluster can survive the loss of one failure group. For most installations, Oracle recommends that you select normal redundancy.