《ASM的normal模式的某个失败组磁盘失效如何mount磁盘.docx》由会员分享，可在线阅读，更多相关《ASM的normal模式的某个失败组磁盘失效如何mount磁盘.docx（10页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、ASM的normal模式的某个失败组磁盘失效如何mount磁盘*ASM磁盘组normal冗余模式下失败组故障如何mount磁盘组*SQL>selectfailgroup,name,path,mount_status,state,total_mb,free_mbfromv$asm_diskwheregroup_number=3orderby1,2FAILGROUPNAMEPATHMOUNT_STATUSSTATETOTAL_MBFREE_MB-DATA1_FG1DISK1/dev/sde1CACHEDNORMAL1023941DATA1_FG1DISK2/dev/sdf1CACHEDNOR
2、MAL1023941DATA1_FG2DISK3/dev/sdg1CACHEDNORMAL1023945DATA1_FG2DISK4/dev/sdh1CACHEDNORMAL1023937ASMCMD>lsdgStateTypeRebalSectorLogical_SectorBlockAUTotal_MBFree_MBReq_mir_free_MBUsable_file_MBOffline_disksVoting_filesNameMOUNTEDEXTERNN5125124096419430422524196080196080NDATA/MOUNTEDNORMALN5125124096
3、10485764092376420468590NDATA1/MOUNTEDEXTERNN5125124096419430412284119360119360YOCR/摘掉磁盘/dev/sde1，/dev/sdf1现在我们将失败组DATA1_FG1的所有磁盘摘掉，模拟失败组DATA1_FG1的所有磁盘故障,我们在虚拟机的介质管理器中释放共享盘和节点的关联关系。重启集群后数据库无法启动数据库日志2021-09-08T12:19:04.335639+08:00WARNING:failedtoregisterAMB1withASMinstance2021-09-08T12:19:04.355078+0
4、8:00Errorsinfile/oracle/db/diag/rdbms/prod/prod1/trace/prod1_amb1_17786.trc:ORA-12514:TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptorORA-12514:TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptorWARNING:AMB1exitingwitherror2021-09-08T12:19:04.678312+08:00Errors
5、infile/oracle/db/diag/rdbms/prod/prod1/trace/prod1_dbw0_17500.trc:ORA-01157:cannotidentify/lockdatafile2-seeDBWRtracefileORA-01110:datafile2:+DATA1/PROD/DATAFILE/data1.256.1082626777ORA-17503:ksfdopn:2Failedtoopenfile+DATA1/PROD/DATAFILE/data1.256.1082626777ORA-15001:diskgroupDATA1doesnotexistorisno
6、tmountedORA-15001:diskgroupDATA1doesnotexistorisnotmountedORA-15064:communicationfailurewithASMinstanceORA-12514:TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptorORA-12514:TNS:listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor2021-09-08T12:19:04.939328+08:00Pingwit
7、houtlogforceisdisabled:notanExadatasystem.2021-09-08T12:19:05.064240+08:00Errorsinfile/oracle/db/diag/rdbms/prod/prod1/trace/prod1_ora_17595.trc:ORA-01157:cannotidentify/lockdatafile2-seeDBWRtracefileORA-01110:datafile2:+DATA1/PROD/DATAFILE/data1.256.10826267772021-09-08T12:19:05.139709+08:00Errorsi
8、nfile/oracle/db/diag/rdbms/prod/prod1/trace/prod1_ora_17595.trc:ORA-01157:cannotidentify/lockdatafile2-seeDBWRtracefileORA-01110:datafile2:+DATA1/PROD/DATAFILE/data1.256.1082626777ORA-1157signalledduring:ALTERDATABASEOPEN/*dbagent*/*1:61491:494*/.2021-09-08T12:19:08.784593+08:00Licensehighwatermark=
9、12021-09-08T12:19:08.788726+08:00USER(prelim)(ospid:17822):terminatingtheinstance2021-09-08T12:19:10.028522+08:00InstanceterminatedbyUSER(prelim),pid=17822ASM日志SQL>ALTERDISKGROUPDATA1MOUNT/*asmagent*/*1:61491:1164*/2021-09-08T15:36:30.870964+08:00NOTE:cacheregisteredgroupDATA11/0x54EE6E2C2021-09-
10、08T15:36:32.177546+08:00NOTE:cachebeganmount(first)ofgroupDATA11/0x54EE6E2C2021-09-08T15:36:33.828527+08:00NOTE:Assigningnumber(1,3)todisk(/dev/sdf1)NOTE:Assigningnumber(1,2)todisk(/dev/sde1)2021-09-08T15:36:33.846342+08:00NOTE:cachedismounting(clean)group1/0x54EE6E2C(DATA1)NOTE:messagingCKPTtoquies
11、cepinsUnixprocesspid:16021,image:oraclerac1(TNSV1-V3)NOTE:dbwrnotbeingmsgdtodismountNOTE:LGWRnotbeingmessagedtodismountNOTE:cachedismountedgroup1/0x54EE6E2C(DATA1)NOTE:cacheendingmount(fail)ofgroupDATA1number=1incarn=0x54ee6e2cNOTE:cachedeletingcontextforgroupDATA11/0x54ee6e2c2021-09-08T15:36:33.858
12、625+08:00GMONdismountinggroup1at26forpid43,osid160212021-09-08T15:36:33.859948+08:00NOTE:DiskDISK3inmode0x8markedforde-assignmentNOTE:DiskDISK4inmode0x8markedforde-assignmentERROR:diskgroupDATA1wasnotmountedORA-15032:notallalterationsperformedORA-15017:diskgroupDATA1cannotbemountedORA-15040:diskgrou
13、pisincomplete看ORA-15040的含义gridrac1$oerrora1504015040,00000,diskgroupisincomplete/*Cause:Someofthediskscomprisingadiskgroupwerenotpresent./*Action:Checkthehardwaretoensurethatalldisksarefunctional.Also/checkthatthesettingoftheASM_DISKSTRINGinitialization/parameterhasnotchanged.Alternatively,fornormal
14、orhigh/redundancydiskgroups,useMOUNTFORCEtoofflinemissingdisks/aspartofmountingthediskgroup.这个解释跟我们的测试一致，我们强制mount磁盘组，使用一个失败组看看是否可以拉起来。SQL>alterdiskgroupdata1mount;alterdiskgroupdata1mount*ERRORatline1:ORA-15032:notallalterationsperformedORA-15017:diskgroupDATA1cannotbemountedORA-15040:diskgroupi
15、sincompleteSQL>alterdiskgroupdata1mountforce;Diskgroupaltered.查询数据字典SQL>selectfailgroup,name,path,mount_status,state,total_mb,free_mbfromv$asm_diskwheregroup_number=1;FAILGROUPNAMEPATHMOUNT_STATUSSTATETOTAL_MBFREE_MB-DATA1_FG1_DROPPED_0000_DATA1MISSINGFORCING1023920DATA1_FG1_DROPPED_0001_DATA1
16、MISSINGFORCING1023920DATA1_FG2DISK4/dev/sdf1CACHEDNORMAL1023921DATA1_FG2DISK3/dev/sde1CACHEDNORMAL1023919此时Oracle做了清理，missing的磁盘被强制drop,此时我们可以正常打开数据库此时看看ASM告警日志SQL>alterdiskgroupdata1mountforce2021-09-08T15:56:17.397002+08:00NOTE:cacheregisteredgroupDATA11/0x59CE6E32NOTE:cachebeganmount(first)ofg
17、roupDATA11/0x59CE6E322021-09-08T15:56:18.769488+08:00NOTE:Assigningnumber(1,3)todisk(/dev/sdf1)NOTE:Assigningnumber(1,2)todisk(/dev/sde1)2021-09-08T15:56:18.860629+08:00WARNING:PSTdisk0notfound(grp1)clusterguid(dd16d1353f274f80ff1bc81e95eeee15)generatedforPSTHbeatforinstance12021-09-08T15:56:25.1350
18、46+08:00NOTE:GMONheartbeatingforgrp1(DATA1)<<<<<此时的磁盘组号变为1，之前为3.GMONqueryinggroup1at31forpid38,osid130462021-09-08T15:56:25.177225+08:00NOTE:Assigningnumber(1,0)todisk()NOTE:Assigningnumber(1,1)todisk()2021-09-08T15:56:25.409934+08:00GMONqueryinggroup1at32forpid38,osid130462021-09-08T
19、15:56:25.514984+08:00NOTE:process_user13046_+asm1(13046)initiatingofflineofdisk0.4043218713()withmask0x7eingroup1(DATA1)withoutclientassistingNOTE:process_user13046_+asm1(13046)initiatingofflineofdisk1.4043218715()withmask0x7eingroup1(DATA1)withoutclientassistingNOTE:checkingPST:grp=12021-09-08T15:5
20、6:25.613721+08:00GMONcheckingdiskmodesforgroup1at33forpid38,osid130462021-09-08T15:56:25.623716+08:00NOTE:checkingPSTforgrp1done.2021-09-08T15:56:25.624516+08:00NOTE:sendingsetofflineflagmessage(1279641324)to2disk(s)ingroup12021-09-08T15:56:25.778963+08:00WARNING:Disk0()ingroup1mode0x7fisnowbeingoff
21、lined<<<<<<磁盘Disk0Disk1被强制offlineWARNING:Disk1()ingroup1mode0x7fisnowbeingofflined2021-09-08T15:56:25.790569+08:00INFO:Instance#2couldnotfinddisk2ingroup1NOTE:initiatingPSTupdate:grp1(DATA1),dsk=0/0xf0fe9f19,mask=0x6a,op=clearmandatory<<<<<更新PST表，强制清除两个磁盘NOTE:initiat
22、ingPSTupdate:grp1(DATA1),dsk=1/0xf0fe9f1b,mask=0x6a,op=clearmandatory2021-09-08T15:56:25.853348+08:00GMONupdatingdiskmodesforgroup1at34forpid38,osid130462021-09-08T15:56:25.967438+08:00NOTE:PSTupdategrp=1completedsuccessfullyNOTE:initiatingPSTupdate:grp1(DATA1),dsk=0/0xf0fe9f19,mask=0x7e,op=clearman
23、datoryNOTE:initiatingPSTupdate:grp1(DATA1),dsk=1/0xf0fe9f1b,mask=0x7e,op=clearmandatory2021-09-08T15:56:25.973853+08:00GMONupdatingdiskmodesforgroup1at35forpid38,osid130462021-09-08T15:56:26.056930+08:00NOTE:cacheclosingdisk0ofgrp1:(notopen)2021-09-08T15:56:26.057638+08:00NOTE:cacheclosingdisk1ofgrp
24、1:(notopen)2021-09-08T15:56:26.098801+08:00NOTE:cacheclosingdisk0ofgrp1:(notopen)2021-09-08T15:56:26.105284+08:00NOTE:cacheclosingdisk1ofgrp1:(notopen)<<<<<<关闭disk0disk12021-09-08T15:56:26.123581+08:00NOTE:PSTupdategrp=1completedsuccessfullyNOTE:cacheismountinggroupDATA1createdon20
25、21/09/0709:22:59<<<<<开始挂盘NOTE:cacheopeningdisk2ofgrp1:DISK3path:/dev/sde1NOTE:cacheopeningdisk3ofgrp1:DISK4path:/dev/sdf1NOTE:09/08/2115:56:25DATA1.F1X0foundondisk3au2fcn0.0datfmt12021-09-08T15:56:26.129497+08:00NOTE:cachemounting(first)normalredundancygroup1/0x59CE6E32(DATA1)2021-09-
26、08T15:56:26.139602+08:00*allocatedomain1,valid?0kjbdomattsendtoinst22021-09-08T15:56:26.343997+08:00NOTE:attachedtorecoverydomain12021-09-08T15:56:26.574101+08:00validatepdb1,flagsx4,valid0,pdbflagsx204*validateddomain1,flags=0x200NOTE:cacherecoveredgroup1tofcn0.795NOTE:redobuffersizeis256blocks(105
27、6768bytes)2021-09-08T15:56:26.704574+08:00NOTE:LGWRattemptingtomountthread1fordiskgroup1(DATA1)NOTE:LGWRfoundthread1closedatABA2.41lockdomain=0inc#=0instnum=1NOTE:LGWRmountedthread1fordiskgroup1(DATA1)2021-09-08T15:56:26.811591+08:00NOTE:LGWRopenedthread1(DATA1)atfcn0.795ABA3.42lockdomain=1inc#=8ins
28、tnum=1gx.incarn=1506700850mntstmp=2021/09/0815:56:26.7860002021-09-08T15:56:26.818432+08:00NOTE:cachemountinggroup1/0x59CE6E32(DATA1)succeededNOTE:cacheendingmount(success)ofgroupDATA1number=1incarn=0x59ce6e322021-09-08T15:56:27.515738+08:00NOTE:cacheclosingdisk0ofgrp1:(notopen)DISK12021-09-08T15:56
29、:27.516472+08:00NOTE:cacheclosingdisk1ofgrp1:(notopen)DISK22021-09-08T15:56:27.527287+08:00NOTE:Instanceupdatedcompatible.asmto11.2.0.2.0forgrp1(DATA1).2021-09-08T15:56:27.532187+08:00NOTE:cacheclosingdisk0ofgrp1:(notopen)DISK12021-09-08T15:56:27.533661+08:00NOTE:cacheclosingdisk1ofgrp1:(notopen)DIS
30、K22021-09-08T15:56:27.550394+08:00NOTE:Instanceupdatedcompatible.asmto11.2.0.2.0forgrp1(DATA1).2021-09-08T15:56:27.646690+08:00NOTE:Instanceupdatedcompatible.rdbmsto10.1.0.0.0forgrp1(DATA1).2021-09-08T15:56:27.662473+08:00NOTE:Instanceupdatedcompatible.rdbmsto10.1.0.0.0forgrp1(DATA1).2021-09-08T15:5
31、6:28.002565+08:00SUCCESS:diskgroupDATA1wasmounted2021-09-08T15:56:28.562265+08:00SUCCESS:alterdiskgroupdata1mountforce<<<<<mountforce成功2021-09-08T15:56:28.948585+08:00ASMHealthCheckerfound1newfailures2021-09-08T15:56:29.006000+08:00NOTE:diskgroupresourceora.DATA1.dgisonline<<<
32、;<<集群磁盘组data1资源online2021-09-08T15:56:29.026891+08:00ASMHealthCheckerfound1newfailures2021-09-08T15:56:31.995419+08:00NOTE:cacheclosingdisk0ofgrp1:(notopen)DISK12021-09-08T15:56:31.996518+08:00NOTE:cacheclosingdisk1ofgrp1:(notopen)DISK22021-09-08T15:56:32.489531+08:00NOTE:enlargingACDto2thread
33、sforgroup1/0x59ce6e32(DATA1)2021-09-08T15:56:34.107677+08:00SUCCESS:ACDenlargedforgroup1/0x59ce6e32(DATA1)下面我们将数据库打开SQL>alterdatabaseopen;Databasealtered.检查业务表SQL>connectlin/oracleConnected.SQL>coltable_namefora20SQL>setline120SQL>select*fromcat;TABLE_NAMETABLE_TYPE-TESTTABLESQL>selectobject_namefromtestwhereobject_id=100;OBJECT_NAME-SEQ$这里业务数据没有丢失。