In V$ASM_DISKGROUP,the column VOTING_FILE displays wrong flag

(Doc ID 1921139.1)

Last updated on NOVEMBER 29, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

 Performed the Voting disk migration successfully via "crsctl replace votedisk +DR_OCR": 


However, when querying v$asm_diskgroup , as noticed below, the new OCR diskgroup, ie. DR_OCR still shows the value of the column VOTING_DISK  as 'N'.

select b. NAME,   PATH ,b.VOTING_FILES, a.TOTAL_MB/1024, a.HOT_USED_MB/1024, a.COLD_USED_MB/1024 , a.FREE_MB/1024 from v$asm_disk a, v$asm_diskgroup b where a.GROUP_NUMBER = b.GROUP_NUMBER

NAME                 PATH                 V A.TOTAL_MB/1024 A.HOT_USED_MB/1024 A.COLD_USED_MB/1024 A.FREE_MB/1024
-------------------- -------------------- - --------------- ------------------ ------------------- --------------
OCR                  ORCL:DR2_OCRV1       N      19.9931641                  0           .35546875     19.6376953
NTEST_20X            ORCL:NTEST20         N      19.9931641                  0          18.0351563     1.95800781
TEST_20X             ORCL:TESTEMC20       N      19.9931641                  0          17.7558594     2.23730469
DR_ARCH              ORCL:DR_ARCH1        N      249.996094                  0          69.1445313     180.851563
DR_DATA              ORCL:DR_DATA1        N      249.996094                  0          182.299805     67.6962891
DR_DATA              ORCL:DR_DATA2        N      249.996094                  0          182.301758     67.6943359
DR_DATA              ORCL:DR_DATA3        N      249.996094                  0          182.300781     67.6953125
DR_DATA              ORCL:DR_DATA4        N      249.996094                  0          182.297852     67.6982422
DR_DATA              ORCL:DR_DATA5        N      249.996094                  0          182.298828     67.6972656
DR_REDO              ORCL:DR_REDO1        N      19.9931641                  0          16.3164063     3.67675781
DR_OCR               ORCL:DR_OCRV1        N      19.9931641                  0          .385742188     19.6074219

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms