Exadata ortamındaki “Failed voting file relocation on diskgroup DBFS_DG” hatası
Exadata veritabanı sunucularında, voting dosyalarının olduğu cellnode’larda erişim sağlayamadığında ve erişim sağlandıktan sonra bile aşağıdaki gibi relocation hatası alınabilmektedir. DBFS_DG disk grubuna erişim olsa bile bu hata gelebilmektedir.
NOTE: Attempting voting file relocation on diskgroup DBFS_DG NOTE: Failed voting file relocation on diskgroup DBFS_DG
Öncelikle voting dosyalarını kontrol edelim.
[root@exadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] 4. OFFLINE 4c36175230c84f99bf17449f57a292f3 () [] 5. OFFLINE dbb38914ae9f4fe7bf475a9f1ea4c016 () [] Located 5 voting disk(s).
Hata alındığında voting disklerin olduğu cellnode’lara erişim olsa bile yukarıdaki gibi bazı dosyalar offline görülecektir. Bu durumda tüm compute node’lardaki crs aşağıdaki gibi yeniden başlatılmalıdır.
[root@exadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl stop crs
[root@exadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl start crs
Açıkdıktan sonra aşağıdaki gibi crs durumunu kontrol edebilirsiniz.
[root@exadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online
Tüm node’lardaki crs yeniden başlatıldığında artık relocation hatası alınmayacaktır.
Aşağıdaki komut ile tüm node’larda voting dosyalarını durumunu kontrol edebilirsiniz.
[root@exadb01 ~]# dcli -g dbs_group -l root /u01/app/12.2.0.1/grid/bin/crsctl query css votedisk exadbadm01: ## STATE File Universal Id File Name Disk group exadbadm01: -- ----- ----------------- --------- --------- exadbadm01: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm01: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm01: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm01: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm01: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm01: Located 5 voting disk(s). exadbadm02: ## STATE File Universal Id File Name Disk group exadbadm02: -- ----- ----------------- --------- --------- exadbadm02: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm02: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm02: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm02: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm02: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm02: Located 5 voting disk(s). exadbadm03: ## STATE File Universal Id File Name Disk group exadbadm03: -- ----- ----------------- --------- --------- exadbadm03: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm03: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm03: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm03: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm03: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm03: Located 5 voting disk(s). exadbadm04: ## STATE File Universal Id File Name Disk group exadbadm04: -- ----- ----------------- --------- --------- exadbadm04: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm04: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm04: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm04: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm04: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm04: Located 5 voting disk(s). exadbadm05: ## STATE File Universal Id File Name Disk group exadbadm05: -- ----- ----------------- --------- --------- exadbadm05: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm05: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm05: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm05: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm05: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm05: Located 5 voting disk(s). exadbadm06: ## STATE File Universal Id File Name Disk group exadbadm06: -- ----- ----------------- --------- --------- exadbadm06: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm06: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm06: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm06: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm06: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm06: Located 5 voting disk(s). exadbadm07: ## STATE File Universal Id File Name Disk group exadbadm07: -- ----- ----------------- --------- --------- exadbadm07: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm07: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm07: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm07: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm07: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm07: Located 5 voting disk(s). exadbadm08: ## STATE File Universal Id File Name Disk group exadbadm08: -- ----- ----------------- --------- --------- exadbadm08: 1. ONLINE 95c4a6fc51d54fa9bf27520175a2176d (o/192.168.10.19;192.168.10.20/DBFS_DG_CD_05_exaceladm02) [DBFS_DG] exadbadm08: 2. ONLINE adba944b7ccd4fe9bfba6fefd54a4203 (o/192.168.10.23;192.168.10.24/DBFS_DG_CD_10_exaceladm04) [DBFS_DG] exadbadm08: 3. ONLINE 68482351e6fb4f5bbf50b55f814830f1 (o/192.168.10.27;192.168.10.28/DBFS_DG_CD_03_exaceladm06) [DBFS_DG] exadbadm08: 4. ONLINE 4c36175230c84f99bf17449f57a292f3 (o/192.168.10.39;192.168.10.40/DBFS_DG_CD_03_exaceladm12) [DBFS_DG] exadbadm08: 5. ONLINE dbb38914ae9f4fe7bf475a9f1ea4c016 (o/192.168.10.35;192.168.10.36/DBFS_DG_CD_08_exaceladm10) [DBFS_DG] exadbadm08: Located 5 voting disk(s).
