OCR Diskgroup became inaccessible after storage one disk fault on raid 5 configuration

OCR Diskgroup became inaccessible after storage one disk fault on raid 5 configuration

 

Database version:Enterprise Edition -Version 11.2.0.1 on Wimdows Server 2008

 

Due to storage issue,one of the ocr disk is offlie. This means that one node diskgroup is dismounted or corrupted. First of all we must check the nodes for one of them is accessible OCR or not. If one is accessible it means that OCR disgroup is not corrupted. It just dismounted...

Note 1: 

SQL> select NAME , STATE FROM V$ASM_DISKGROUP;
NAME                           STATE
------------------------------ -----------
DATA                      MOUNTED
FRA                       MOUNTED

VOTE                     MOUNTED
OCR                    DISMOUNTED  

·         Note 2:

  SQL> select NAME , STATE FROM V$ASM_DISKGROUP;
   NAME                           STATE
    ------------------------------ -----------   DATA                      MOUNTED
  FRA                       MOUNTED

  VOTE                     MOUNTED
  OCR                    MOUNTED  

On Node 1 CRS is not able to start due to OCR disk group and the given error message is “Can’not comminicate with the CRS deamon”.

On Node 1 Crs is not able to start due to OCR disk group and it gave error message is "Can not comminicate with CRS Deamon".

SOLUTION:

First of check windows disk managment. If one of vdisk which mounted before is unmounted or offline or readonly mode you try to get online mode.

If the first step is success you try to connect automatic storage managment using by asmcmd console.

The command is below to mount OCR:

Please before connect asmcmd, you should set Oracle_Home(Oracle grid home like that "C:\app\product\grid\") and Oracle_sid(+asm1)

After set Oracle home and sid you can connect asm

cmd>asmcmd

asmcmd>ls

VOTE

DATA

FRA

asmcmd>mound OCR

asmcmd>ls

VOTE

OCR

DATA

FRA

And Then start crsd resource:

crctl start res ora.crsd -init

Check the Note 1 disk group:

SQL> select NAME , STATE FROM V$ASM_DISKGROUP;

NAME                           STATE
------------------------------ ----------- DATA                      MOUNTED
FRA                       MOUNTED

VOTE                     MOUNTED
OCR                    MOUNTED  

Now The Node 1 is connected database...