My Oracle Support Banner

In V$ASM_DISKGROUP,the column VOTING_FILE displays wrong flag (Doc ID 1921139.1)

Last updated on AUGUST 04, 2018

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": 

[orgrid@catos-nrdbdcl01 ~]$ crsctl replace votedisk +DR_OCR
Successful addition of voting disk 3c40c8fec4a74ff1bf25ec59554dc29b.
Successful deletion of voting disk 9562d3995d714f63bf5d2d650fe8c11a.
Successfully replaced voting disk group with +DR_OCR.
CRS-4266: Voting file(s) successfully replaced

# crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
1. ONLINE   3c40c8fec4a74ff1bf25ec59554dc29b (ORCL:DR_OCRV1) [DR_OCR]
Located 1 voting disk(s).


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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.