normal 磁盘组磁盘显示missing

data 磁盘组为normal 模式：

故障现象：

SQL> @chkDG_NAME DG_STATE TYPE DSK_NO DSK_NAMEPATH MOUNT_S FAILGROUPSTATE--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------DATAMOUNTEDNORMAL 0 DATA_0000/dev/oracleasm/disks/VOT3 CACHEDZCNORMALDATAMOUNTEDNORMAL 1 _DROPPED_0MISSING BFORCING 001_DATADATAMOUNTEDNORMAL 2 DATA_0002/dev/oracleasm/disks/VOT1 CACHEDANORMALMGMTMOUNTEDEXTERN 0 MGMT_0000/dev/oracleasm/disks/DATA01 CACHEDMGMT_0000NORMALDISK_NUMBER NAME PATHHEADER_STATUS OS_MB TOTAL_MBFREE_MB REPAIR_TIMER V FAILGRO----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------0 /dev/oracleasm/disks/VOT2MEMBER 2048 000 Y REGULAR1 _DROPPED_0UNKNOWN02048 17040 N REGULAR001_DATA0 MGMT_0000/dev/oracleasm/disks/DATA01MEMBER5119951196173880 N REGULAR0 DATA_0000/dev/oracleasm/disks/VOT3MEMBER 20482048 20040 Y QUORUM2 DATA_0002/dev/oracleasm/disks/VOT1MEMBER 20482048 17040 Y REGULARGROUP_NUMBER NAMECOMPATIBILITY DATABASE_COMPATIBILITYV------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ - 2 MGMT12.2.0.1.0 10.1.0.0.0 N 1 DATA12.2.0.1.0 10.1.0.0.0 YSQL>

解决方法：

01.重新添加磁盘到failgroup B

SQL> ALTER DISKGROUP dataaddfailgroup b DISK '/dev/oracleasm/disks/VOT2'force;Diskgroup altered.SQL> @chkDG_NAME DG_STATE TYPE DSK_NO DSK_NAMEPATH MOUNT_S FAILGROUPSTATE--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------DATAMOUNTEDNORMAL 0 DATA_0000/dev/oracleasm/disks/VOT3 CACHEDZCNORMALDATAMOUNTEDNORMAL 1 _DROPPED_0MISSING BFORCING 001_DATADATAMOUNTEDNORMAL 2 DATA_0002/dev/oracleasm/disks/VOT1 CACHEDANORMALDATAMOUNTEDNORMAL 3 DATA_0003/dev/oracleasm/disks/VOT2 CACHEDBNORMALMGMTMOUNTEDEXTERN 0 MGMT_0000/dev/oracleasm/disks/DATA01 CACHEDMGMT_0000NORMALDISK_NUMBER NAME PATHHEADER_STATUS OS_MB TOTAL_MBFREE_MB REPAIR_TIMER V FAILGRO----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------1 _DROPPED_0UNKNOWN02048 17240 N REGULAR001_DATA0 MGMT_0000/dev/oracleasm/disks/DATA01MEMBER5119951196173880 N REGULAR0 DATA_0000/dev/oracleasm/disks/VOT3MEMBER 20482048 20040 Y QUORUM2 DATA_0002/dev/oracleasm/disks/VOT1MEMBER 20482048 17040 Y REGULAR3 DATA_0003/dev/oracleasm/disks/VOT2MEMBER 20482048 19840 Y REGULARGROUP_NUMBER NAMECOMPATIBILITY DATABASE_COMPATIBILITYV------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ - 2 MGMT12.2.0.1.0 10.1.0.0.0 N 1 DATA12.2.0.1.0 10.1.0.0.0 Y

02.平衡完成之后，检查磁盘组状态

SQL> @chkDG_NAME DG_STATE TYPE DSK_NO DSK_NAMEPATH MOUNT_S FAILGROUPSTATE--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------DATAMOUNTEDNORMAL 0 DATA_0000/dev/oracleasm/disks/VOT3 CACHEDZCNORMALDATAMOUNTEDNORMAL 2 DATA_0002/dev/oracleasm/disks/VOT1 CACHEDANORMALDATAMOUNTEDNORMAL 3 DATA_0003/dev/oracleasm/disks/VOT2 CACHEDBNORMALMGMTMOUNTEDEXTERN 0 MGMT_0000/dev/oracleasm/disks/DATA01 CACHEDMGMT_0000NORMALDISK_NUMBER NAME PATHHEADER_STATUS OS_MB TOTAL_MBFREE_MB REPAIR_TIMER V FAILGRO----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------0 MGMT_0000/dev/oracleasm/disks/DATA01MEMBER5119951196173880 N REGULAR0 DATA_0000/dev/oracleasm/disks/VOT3MEMBER 20482048 20040 Y QUORUM2 DATA_0002/dev/oracleasm/disks/VOT1MEMBER 20482048 17040 Y REGULAR3 DATA_0003/dev/oracleasm/disks/VOT2MEMBER 20482048 17040 Y REGULARGROUP_NUMBER NAMECOMPATIBILITY DATABASE_COMPATIBILITYV------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ - 2 MGMT12.2.0.1.0 10.1.0.0.0 N 1 DATA12.2.0.1.0 10.1.0.0.0 YSQL> 

03,避免该问题再次发生！

SQL> ALTER DISKGROUP data SET ATTRIBUTE 'compatible.rdbms' = '11.2';Diskgroup altered.SQL> @chkDG_NAME DG_STATE TYPE DSK_NO DSK_NAMEPATH MOUNT_S FAILGROUPSTATE--------------- ---------- ------ ---------- ---------- -------------------------------------------------- ------- -------------------- --------DATAMOUNTEDNORMAL 0 DATA_0000/dev/oracleasm/disks/VOT3 CACHEDZCNORMALDATAMOUNTEDNORMAL 2 DATA_0002/dev/oracleasm/disks/VOT1 CACHEDANORMALDATAMOUNTEDNORMAL 3 DATA_0003/dev/oracleasm/disks/VOT2 CACHEDBNORMALMGMTMOUNTEDEXTERN 0 MGMT_0000/dev/oracleasm/disks/DATA01 CACHEDMGMT_0000NORMALDISK_NUMBER NAME PATHHEADER_STATUS OS_MB TOTAL_MBFREE_MB REPAIR_TIMER V FAILGRO----------- ---------- -------------------------------------------------- -------------------- ---------- ---------- ---------- ------------ - -------0 MGMT_0000/dev/oracleasm/disks/DATA01MEMBER5119951196173880 N REGULAR0 DATA_0000/dev/oracleasm/disks/VOT3MEMBER 20482048 20040 Y QUORUM2 DATA_0002/dev/oracleasm/disks/VOT1MEMBER 20482048 17040 Y REGULAR3 DATA_0003/dev/oracleasm/disks/VOT2MEMBER 20482048 17040 Y REGULARGROUP_NUMBER NAMECOMPATIBILITY DATABASE_COMPATIBILITYV------------ ---------- ------------------------------------------------------------ ------------------------------------------------------------ - 2 MGMT12.2.0.1.0 10.1.0.0.0 N 1 DATA12.2.0.1.0 11.2.0.0.0 YSQL>