• Register

Most popular tags

Welcome to UNIRAC.IN - Q!,

where you can ask questions and receive answers from other members of the community.
Real Time Oracle DBA training by MNC Expert with 12+yrs

Congrats!

Our Candidates Placed in TOP MNC's

Tech Mahindra,3i,Tera (Krishna,Ravi)
Infosys(Khaleel)
Wipro (Govardhan)
Qualcomm(Confidential)
TATA Power (Vikram)
HP (Anil)
Igate (Venkat)
UnitedHealth(Vikram)
Wirpo,InSolutions,3i,ING,TechMahindra(Siva)
Dubai,Apollo Munich (Shahjath)
Innopath,TeraSoft-(Anil)
IPSoft-Pradeep
Dubai-(Adnan)
3i-Naveen
3i-Shiva
Many MOrE.........Congrats to ALL

11gR2: Moving OCR and Voting Disk to different ASM Diskgroup

183 views asked in Clusterware by UNIRAC ACE (20,050 points)

2 Answers

11gR2_OCR_VOTE


In case you wish to move OCR and Voting disk out of the current diskgroup, you can follow below steps. These steps can also be used to move files from ASM Diskgroup to Netapp filer and vice versaWe wish to move OCR/Voting disk from Diskgroup DATA to DG_DATA01?1) Create the new diskgroup DG_DATA01?2) Ensure that ASM Compatability is set to 11.2

 select name,COMPATIBILITY,DATABASE_COMPATIBILITY from V$ASM_DISKGROUP where name='DG_DATA01';

NAME       COMPATIBILITY      DATABASE_COMPATIBILITY
--------  ----------------   --------------------------
DG_DATA01  10.1.0.0.0        10.1.0.0.0

In case it is not, then you can change it using following command

alter diskgroup DG_DATA01 SET ATTRIBUTE 'compatible.asm'='11.2';

3) Replace voting disk using crsctl command as oracle user. You can do this without stopping the clusterware

 crsctl replace votedisk +DG_DATA01
Successful addition of voting disk 241b1e0a36344f7bbfaca4a576d514e9                                                                                                                                                                                                                                .
Successful deletion of voting disk 72e47e5e3afb4fe9bfb502b1b4340503.
Successfully replaced voting disk group with +DG_DATA01.
CRS-4266: Voting file(s) successfully replaced

To list the voting disk

crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    ---------------                --------- ---------
 1. ONLINE   241b1e0a36344f7bbfaca4a576d514e9 (ORCL:DISK4) [DG_DATA01]
Located 1 voting disk(s).

4) To replace OCR, we need to have multiple OCR configured. In our case we need to add OCR to new diskgroup and delete old one. We need to run this command as root.

[root ~]# ocrconfig -add +DG_DATA01
[root ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
    Version                  :          3
    Total space (kbytes)     :     262120
    Used space (kbytes)      :       2424
    Available space (kbytes) :     259696
    ID                       :  579998313
    Device/File Name         :      +DATA
                                    Device/File integrity check succeeded
    Device/File Name         : +DG_DATA01
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

    Cluster registry integrity check succeeded

    Logical corruption check succeeded   

answered by UNIRAC ACE (20,050 points)
[root ~]# ocrconfig -delete +DATA
[root ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
    Version                  :          3
    Total space (kbytes)     :     262120
    Used space (kbytes)      :       2424
    Available space (kbytes) :     259696
    ID                       :  579998313
    Device/File Name         : +DG_DATA01
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

    Cluster registry integrity check succeeded

    Logical corruption check succeeded

Verify that OCR location is pointing to the correct diksgroup on both nodes.

# cat /etc/oracle/ocr.loc
#Device/file +DATA getting replaced by device +DG_DATA01
ocrconfig_loc=+DG_DATA01
local_only=false

5) ASM Parameter file is also present in same diskgroup. In case you wish to remove it, then follow below steps

SQL> create pfile from spfile;

File created.

SQL> create spfile='+DG_DATA01' from pfile;

File created.

You will need to restart the cluster on both the nodes as ASM instance is still using the file. Run following commands on both the nodes

crsctl stop cluster
crsctl start cluster
answered by UNIRAC ACE (20,050 points)
...