環境:Oracle 11.2.4.0 RAC
問題描述:
CRS服務不正常,asm diskgroup掛載不了,截圖如下:



日志如下:
--------------------------------------------------------------------------------------------------
Wed Jun 27 10:28:10 2018
SQL> alter diskgroup crs mount
NOTE: cache registered group CRS number=1 incarn=0xdbd84eae
NOTE: cache began mount (not first) of group CRS number=1 incarn=0xdbd84eae
WARNING: detected duplicate paths to the same disk:
'/dev/mapper/CRSp1' and
'/dev/dm-23'
More trace information dumped to '/u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_42445.trc'
Wed Jun 27 10:28:11 2018
ERROR: no read quorum in group: required 2, found 0 disks
NOTE: cache dismounting (clean) group 1/0xDBD84EAE (CRS)
NOTE: messaging CKPT to quiesce pins Unix process pid: 42445, image: oracle@db-5 (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0xDBD84EAE (CRS)
NOTE: cache ending mount (fail) of group CRS number=1 incarn=0xdbd84eae
NOTE: cache deleting context for group CRS 1/0xdbd84eae
GMON dismounting group 1 at 10 for pid 24, osid 42445
ERROR: diskgroup CRS was not mounted
WARNING: Disk Group CRS containing spfile for this instance is not mounted
WARNING: Disk Group CRS containing configured OCR is not mounted
WARNING: Disk Group CRS containing voting files is not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "CRS" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "CRS"
ERROR: alter diskgroup crs mount
Wed Jun 27 10:28:13 2018
NOTE: No asm libraries found in the system
ERROR: -5(Duplicate disk DATA:DATA_0008)
ERROR: -5(Duplicate disk DATA:DATA_0001)
ERROR: -5(Duplicate disk DATA:DATA_0000)
ERROR: -5(Duplicate disk DATA:DATA_0003)
ERROR: -5(Duplicate disk CRS:CRS_0000)
ERROR: -5(Duplicate disk DATA:DATA_0007)
ERROR: -5(Duplicate disk DATA:DATA_0005)
ERROR: -5(Duplicate disk DATA2:DATA2_0002)
ERROR: -5(Duplicate disk DATA2:DATA2_0003)
ERROR: -5(Duplicate disk DATA:DATA_0004)
ERROR: -5(Duplicate disk RECOVERY:RECOVERY_0000)
ERROR: -5(Duplicate disk DATA:DATA_0002)
ERROR: -5(Duplicate disk DATA:DATA_0006)
ASM Health Checker found 1 new failures
------------------------------------------------------------------------------------
分析:
asm_diskstring里存在指向重復的路徑:
/dev/*,/dev/mapper/*
造成日志中的提示:
----------------------------
WARNING: detected duplicate paths to the same disk:
'/dev/mapper/CRSp1' and
'/dev/dm-23'
--------------------------------------------------
修改asm_diskstring,無法修改:


另一個節點正常,截圖如下:



uj5u.com熱心網友回復:
解決了!在正常的節點上執行:
alter system set asm_diskstring='/dev/dm-*' scope=spfile;
然后重啟不正常的節點,重啟后發現asm磁盤組掛載上了!
uj5u.com熱心網友回復:
哈哈,記得感謝我哦
uj5u.com熱心網友回復:
不錯,解決了就好。uj5u.com熱心網友回復:
uj5u.com熱心網友回復:
自問自答
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/65135.html
標籤:基礎和管理
