Eadatacell节点硬盘更换方案

ExdataX2-2cell节点硬盘更换方案确认故障硬盘的位置OS版本号#imagifo注：查看OS版本号定位故障盘的位置listphysicaldiskfailture的全部磁盘的名称CellCLI>LISTPHYSICALDISKWHEREdiskType=HardDiskANDstatus=criticalDETAILname:28:5deviceId:21diskType:HardDisk...luns:0_5makeModel:“SEAGATEST360057SSUN600G“physicalFirmware:0705physicalInterface:sasphysicalSerial:E07KZ8physicalSize:558.9109999993816GslotNumber:5status:critical注：在版本11.2.3.1.x和之前的版本使用CellCLI>LISTPHYSICALDISKWHEREdiskType=HardDiskANDstatuslikefailedDETAIL注：在版本11.2.3.1.x之后的版本使用通过输出结果中的nameslotnumberLED记录发生失败的物理磁盘的名称CellCLI>listcelldiskwherelun=0_5detailcelldiskgriddisk：CellCLI>listgriddiskwherecelldisk=CD_05_dm01cel01 (cell节点名称〕确认失败的磁盘所关联的ASMdiskdropgrid用户登陆到其中一个数据库节点，例如：edx2db01login:oraclePassword:Lastlogin:ThuJul1214:43:10onttyS0[oracle@edx2db01~]$ASMsqlplus[oracle@edx2db01~]$.oraenvORACLE_SID=[oracle]?+ASM1TheOraclebasehasbeensetto/u01/app/oracle[oracle@edx2db01~]$sqlplus”/assysasm”SQL*Plus:Release11.2.0.2.0ProductiononThuJul1214:45:202023Copyright(c)1982,2023,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.2.0-64bitProductionWiththeRealApplicationClustersandAutomaticStorageManagementoptionsSQL>执行以下命令SQL>setlines180s999SQL>colpathformata50SQL>selectgroup_number,path,header_status,mount_status,mode_status,namefromV$ASM_DISKwherepathlike”CD_05_dm01cel01”;”norowsselected.”说明和ASMdrop,否则需要手drop，在手动dropASM实例是否仍在reblance使用以下语句确认当前ASM实例是否在进展reblanceSQL>select*fromgv$asm_operationwherestate=’RUN’;假设上数值返回为空，则通过以下命令手工将这些盘dropSQL>alterdiskgroupdbfs_dgdropdiskDBFS_DG_CD_05_dm01cel01rebalancepower4;SQL>alterdiskgrouprecodropdiskDBFS_DG_CD_05_dm01cel01rebalancepower4;SQL>alterdiskgroupdata_dgdropdiskDBFS_DG_CD_05_dm01cel01rebalancepower4;完成以后再次使用以下语句确认当前ASM实例是否在进展reblanceSQL>select*fromgv$asm_operationwherestate=’RUN’;假设上述返回为空，说明rebalance已经完成，可以进展下一步工作确认此存储节点上当前msCELLCLI>listcellattributescellSrvstatus,msStatus,rsStatusdetailcellSrvstatus:runningmsStatus:runningrsStatus:running[root@dbm1cel1/]#dfFilesystem 1K-blocks UsedAvailableUse%Mountedon/dev/md5 103177522906660688698030%/tmpfs 12265720 0122657200%/dev/shm/dev/md72063440569452138917230%/opt/oracle/dev/md4118451375677486534%/boot/dev/md11 2395452 7422821995404%/var/log/oracle/dev/md5,在使用以下命令擦好/dev/md5的信息#mdadm-Q--detail/dev/md5/dev/md5:Version:0.90CreationTime:WedApr1112:08:332023RaidLevel:raid1...UpdateTime:WedApr1113:35:042023State:clean,degradedActiveDevices:1WorkingDevices:1FailedDevices:1SpareDevices:0UUID:c93a778e:64f89fb5:2c560736:d50b1c04Events:0.838NumberMajorMinorRaidDeviceState0850activesync/dev/sda51001removed2 8 21 - faultyspare/dev/sdb5说明根分区所在的md设备是clean点亮盘柜上的LED灯CellCLI>alterphysicaldisk<ID>serviceledon例如点亮上文中name：28：5的LEDCellCLI>alterphysicaldisk28:5serviceledonLED灯的位置确定所需更换的硬盘的位置磁盘更换的过程锁起挂扣假设LED灯没有关闭，使用如下命令关闭CellCLI>alterphysicaldisk28:5serviceledoff执行如下命令检查验证更换是否成功cell节点检查CellCLI>LISTPHYSICALDISK28:5detailCellCLI>listcelldiskwherelun=0_5detailCellCLI>listlun0_5detailCellCLI>listgriddiskwherecelldisk=CD_05_dm01cel01数据库效劳器的ASM实例检查SQL>setlines180s999SQL>colpathformata50SQL>selectgroup_number,path,header_status,mount_status,mode_status,namefromV$ASM_DISKwherepathlike”CD_05_dm01cel01”;GROUP_NUMBERPATH HEADER_STATUMOUNT_SNAME1o/192.168.9.10/DATA_Q1_CD_05_edx2cel02MEMBERCACHEDDATA_Q1_CD_05_edx2CEL022o/192.168.9.10/DBFS_DG_CD_05_edx2cel02 MEMBER CACHEDDBFS_DG_CD_05_edx2CEL023o/192.168.9.10/RECO_Q1_CD_05_edx2cel02 MEMBER CACHEDRECO_Q1_CD_05_edx2CEL02执行以下语句：SQL>selectpath,header_statusfromv$asm_diskwheregroup_number=0;PATH HEADER_STATUo/192.168.9.10/DBFS_DG_CD_05_edx2cel02FORMERo/192.168.9.10/DATA_Q1_CD_05_edx2cel02FORMERo/192.168.9.10/RECO_Q1_CD_05_edx2cel02FORMER假设是上述返回值则需要手动添加SQL>alterdiskgroupdbfs_dgadddisk”o/192.168.9.10/DBFS_DG_CD_05_edx2cel02”rebalancepower10;SQL>alterdiskgroupdata_q1adddisk”o/192.168.9.10/DATA_Q1_CD_05_edx2cel02”rebalancepower10;SQL>alterdiskgroupreco_q1adddisk”o/192.168.9.10/RECO_Q1_CD_05_edx2cel02”rebalancepower10;检查根分区所在的md的状态#mdadm-Q--detail/dev/md5/dev/md5:Version:0.90CreationTime:WedApr1112:08:332023RaidLevel:raid1...UpdateTime:WedApr1113:35:042023State:active,degrad