AIX-Oracle-rac数据迁移.docx

4-2S18500上操作274.2.1 通过IE登陆S18500存储27422删除S18500到主机的映射视图27423创建蝴到VIS蝴砥284.3VIS6600T304.3.1 登陆到VIS6600T30432创建逻辑盘组304.3.3 创建卷34434创建主机组34435创建主机354.3.6 映射卷37437在主机作39438痛用§改破鼠同性39439导入卷组信息404310重新启动操作系统404311启动后检查41第57力窠415.1回退场景41数据备份与复原，42剧接失败导回方案42第66FAQ43第7描略谙44关犍词：VIS6600TS18500VIS66T镜像VIS6600T接管存储迁移AlX摘要：本文主要目的是描5本运用VIS6600T接管AJX环境下(18500)碳投,AIX的1.VM卷镜像的方式迁移数据的操作过程.缩略语清单：参考资料清单：对应产品开局指导书华为机密,未经许可不彳号犷散第1章数据迁移前必读1.1 蝴本文以VIS6600T8节点接管生产中心S18500并与容灾中心S18500实现镜像，实现典型的双活容灾解决方案.1.2 读者对象本文档用于指导华为服务工程师和华为合作工程师运用在AIX环境下VIS接管已有存储,并通过VIS66T实现远程镜像实现VIS6600T双活达到容灾实力.操作人员必需具密以下阅历和技能： 熟识当前业务的组网和系统版本信息. 有华为存储设备维护阅历，熟识设备的操作维护方式. AIX服务器操作维护阅历，Orade11GR2RAC相关运用阅历1.3适用场景本文只介绍在AIX7.1环境下通过VIS66T接省已有存储实现数据迁移相关的步骤,包括上层的主机磁盘省理、HBA管理,软件安装QradeRAC集群等业务系统相关的配置操作过程和步骤.必需同时;椅意以下几点，适用于数据迁移方案.业务场景适用V1S6600T接管用户在S18500阵列上1.UN并在VIS6600T创建卷缎卷,并将卷映射作为ORAC1.ERACASM磁盘设备,。rade归档日志存放在AIX1.VM卷上的文件系统中集群应用AIXW1OracIeASM碳盘QraCIecluster集群软件存储型号S18500AwareVersionSKbeIPCurrentVersionHistoryVersiTpe210235876HgXOOwOA126.126.126.100VIoCWOIaOSPCXlOV10CWXMC06PC200Controllera02三B76H<CX0004Ce126.1».126.101V10C*001CXPCXl0V10Cfi001Ca<SPC200Controller组网方式迁移前物理拓扑图迁移后物理拓扑图G说明此项目主机上安装了华为多路径板本并与VIS6600T兼容不须要安装多路径假如须要更换多路径请与团队人员联系解决.1.4留意事项进行数据迁移时，须要留总以下几点：请确保全部设备双路输入电流在VIS6600T接管前须要做数幅库和主机的健康检直,重要数据的雷份工作第2章数据迁移流程用VlS660OT接告方式实现数据迁移总体流程如下图所示：第3章数据迁移前打算3.1迁移环境打算检直时间检杳项目参考章节聊升级前1周打算参考文档打算参考文档30分钟直询系统信息查询系统信息30分钟升级前3天获得所需的软件及工具获得所需的软件和工具1小时检音设法的运行状态检直设备的运行状态30分仲3.1.1打算密考文档包括并不限于以下文档：替考文档备注分工界面目标存铝兼容性列表,需含本次替换浏试的输出文档，为源存储墀作指导书、多路径软件运用手册、巡检指导书华为存储运用ISM笆理软件和UItraPath多路径软件客户（假如源存绿也是华为供应，则由华为负责）目标存铝接作指导书、安路径饮件运用手fi.巡检指导书华为存储运用ISM管理软件和UltraPath多路径找件华为3.1.2直询操作系统信息查询主机操作系统版本TootfebMbdbltoslevei-S7100-03-04-1441查询主机DiSk信息HdxeKOKrHaHeUSCkNi-xzix三aKdAsRSKeI*sk.GkdlKKeasRQ卜KHliaRlOHdx三KllKHiMIQHdx三k.l3KrHSI<1<4KcU三K.15EJ1.*16-w=lx三K17Rvcxltolcwc*1BJCAv«xl«k>l*-?aval1blaAvexleilol«avadsAvoxlaBleIoiUloAvoxlaBleAVoj1.J1.obi.DAvol1CblOAvoxIob1.=11vCt1Cb1CAV-XlobluAVaj1.1AveixlciloleAv-三llblAvox1oblo02-00-000-00-0003-000103-00-。103OQOl03-00-010300-0103-00-0103-00-0103-00-0103-00-01O3-OO-Q103-00-010300-0103-00-0103OOOl03-00-0103-00-01工6500FClftB<X>FCHiUAwex1G5O?FCHudtwl18500FCHujowe*x15OOFCHM<9w5IggFUHt-awex1Q5OOFCHlU<wdj1.1OOFCHt-MMd1Q5OOFCHU44IWCPX15OOFCHlIAFXX)FCHumwcx工8500FCJ1.ISSOOFCMciowexeso>C18¾FCH1.y3O*1O5>ZFCSASDx三kDi-XvoSASDl«1<DnlvciXixlxxxxlX1X1X1DnDDDUDUnDnDDDDDDr工VUDrlv«=«DrxvoDr-IvD-voDr-£v«Ih-vc*DfAvehr1vcDr-ve三hrlUCDvxveDrJ1.UeDrxvoDrlvEhrxvo面询主机AdaPter信息valdble01-002-P<xtMQnmIOl-Ol2-PortAvailable04-004-PortAvailable04-014-PortAVa门&>1。04-024-PortMan<tol04-034-PortGigabitEthcmct-SXPCI-EXFkFAdapter<14103f03)GigabitEthemet-SXPCI-ExpressAdapter<14103f03)Mailable"AvaildDleGlgabXtGigebitGigabitGxgabltEthernetPCl-E×oressliater<e414571614102004)EthernetPCI-ExpressMapter<e414571614102004)EtherChannel/EtherChannel/EthernetEthernetPCl-ExFTe«MapterPCI-ExpbsMisterIEEEO23d1.lrkAggregationIEEE02,3d1.irkAggregation<e414571614102004)<e414571614102004)PkcsllsissassissaslvsOAalt>le03-00GbPCIExpressDualPortFCAdapter<df100Of11410a03)liable03-018GbPCIExpressDualPortFCAcpSr(df100Of1141CO3>AvailablePCFPKCS11DeviceAvailableOO-COPCIExpress×1Planar3QoSASSellable02-PCIExpressxPlanar3GbSASAvllblUWVirtualSrilWt<r查询井记录HBA卡WWN,型号等信息ewU76C5.<X>1.OMKm1-*>2-C-T16C*>PCI*三r«MDualFCM<wtk<aT100011410>3Part,jT.OOCCOOCsr*M1.0*brVmi100ociKar*>4UMwr.OOlAFC1.Ml.D771ftlCu三tcarC«rdXD>O>rnr/DD*C*O.<7M>.3NMork1000009CCACMnC2F1.一1«rxlIDO2U>B7DeviceSpecific.<ZO>310OM9DmasMCkac.<Zl>8000000A*SSr&ric.CX2>OOCOOo*aer*ct¢ic.<Z3>OxrX*gvAC。*eefAO.<Z4>.FF7911ODbvACA*maac.<Z三>.O27tO07Dwic*Xc*Au.(Zb>orr3三o7Dwab¼wcf*c.<Z7>OR7C20B73AS"c"AC.<7R>20(XXHKFw<11C2D*c"c"au.(C)US2.C0<7Dwc*f«cfAc.<ZM)U2tt*.O2×7Swc>fac.<Z1I>UV2.O2K7D*w8sSCMCiAC.<XC>.00000000Mr0r1.OCKAanCoObU7C.OOl.Dtt*0al-F-C6-T1*1.Aromsrccsrxcl<1Mcm*1；OCCOQOAHCXle：tr-cKarvwlOOr*cTtfw：fcerealPrtHkMbvrSrilKutobKerxXectMrwr.EC1.eV«1Cm1<<wCrt4IDt*4j*rEU,54>er11cf>*r.1c.<4m>.»4»1.motRAdctr«w«.«K1.AXDCCCottO6UMl100OClOOlAD77161CTTDOCCOeOeDbv8SDv*ceDv*xcDeviceCW*eCrw*cDvcDr*cD*1CAc.(ZO>!ir*:ric.(Z2>rc"AmSeci¢lc.<Z>Sr*cAc.<Z>*A.ACSw:"A©>0O>ACDvcW>c"ac.D*cSFeciCAc.DbvACA4)dc.DwiceSfcSiP1.rtTFORI9FCCXFXCN*e1S4t>r-C*rvwlmxiIoccoecHoM：FAbr<-<>rvwl90,1DV>CTflB*;r«4>亘询磁盘归属,读写权限等信息tedddddt-etddddddd,oorootrl8ri8riErlrOOrlrirlmmS8rl11717:06ZdevZrhdiskO01717:08devrhdskl(2611:8ZdevZrhdisklO1501CaiWWZdevZrhdisk11Od1.AAOd1.V'wVd'rhdskl25GJ'*'aWdevrhdskl322611:38devrhdskl411q1,dq*J«一ZdevZrhdlsk1514IQ1o«qXJAwT，devrhdskl692210:38ZdevZrhdisklZ62611:38dvZrhdisk2162611:38ZdevrhdAsk3172611:00devrhdisk410OC1.ICUQAVV»ZdevZrhdiskS3OC1.1CUQAvWdvZrhdiskG13Od1.(*QdevZrhdisk772611:00devrhdisk查询卷组信息,卷组中磁盘V信息rootahrfbdb1lsv<-Pcaaw<.privatcaovg-prvate:PV_*HEPVSTATETOTP1.PPsFREEPPsFREEDISTRIBUTIOMhdisk17OCtive15915232.25.31.32.32roocwbdbllsvt-1caevg.privatecaavg-private:1.VTYPE1.PsPPsPVs1.VSTATEMOUNTPOINTCaalvjyrivatelboot111clsedsyncdN/Acaalv-rivte2bt111closed/sncdN/ACaaivjorivate3boot441open/syncdNpowerha-crlvbt111closedsncdN/Aroot*bdb11sv<-PVgarchlvgarcl：PV.t*HEPVSTATETOTA1.PPsFREEPPsFREEDISTRIBUTIONhdskl5octve1999200.CQ00802rootahiibdb1lsvg-1VgarChlvgarcbl：1.Vt*ETYFC1.Ps19%PPs19%PVs1.VSTATEMOUNTPOIHTIo8IvOOfSlvOOJfs21o11opnsyncd0PC5M11CdN/A/optZoraarchZareh主机磁盘与阵列1.UN对应关系信息.3PIeKoO5M皿KrC<M1PldSOoolh)l3Xvta>。hm£1，*»<,4PlflSCOMf1.400xuM,a1HM&1/*»<>cbakrib02R1.41MXCvmla2HM<10wfc”ruBOOOi.R)42.OCC.bdttA.J»tMCll三C8SjO4a_4XJt>MA_4»<M«：«00M-WJj900Q.mrM.IHMlPiaB05MB-W-4m<3*,>三.w<,TXfcVC./2aM0PtMOoOI.2J«.90lKbl/W>«MCl*F31PgO81.P0A,AdQAYx<OfflJiMM2Pl0BOOOl4.>OCC.«t«M.OK1j-33Piaw»5A/皿-t>#'u>ruePiWWlJ>500G>t>rVMJSF.159，f16PI«081.，XW%O1.4rtfdHMCPi三0gU80CC.brtHMClFF",l6085卬.皿.«HMd=三三-三三Orc5：豆W872/31g>MebOOOOttM6dWWg>W00000M3M"1OomMwMBOWOOff;3ng72*mXMfg×EMio11TOX100onnoooQtOM17l0977*33i00C(lX)l>X0023M37i0T2W10d7O0C0>6XM17>M7)i04rt<ooooaECWUW7W100C*11c>MXWa8M,7IOE8318OX9OOOOOQ3»3Mi71872903i809"g×C"VWT2%3180%gWW0%3R.VWWm0OO"JW0imad>VW29WwX2c2080gSlM>”>A2W100O3>X>o0l3n/8刘gm2f8W3.1.3数据库信息收集OraCIe数据库名称SQ1.>selectnamefromvMatatoe:t*WEPHWBSQ1.>selectinstance_na«efrovinstance;INST儆CEjWMEahub2直询Oracle数据库OCR信息FileNaneDiskgroup1OM1.lNE2. ON1.IHE3. ON1.INE1.ocated3votingdsk<s>.37324b30a3804fblbfdcte8b688e5168494ea0653d864F33bfeda8dl3d35cefc57ce8df0bab427bfwC4>lod9ef684<devrhdskl4)COCR<devrhdsk2>COCR<devrhdisk3>COCR>2>ocStatusofOracleClusterRegistryis9sfollows*Version：3Totalspace(kbytes)：262120Usedspace(kbytes>：3024Availaiolespace(kbytes)：2590%ID：%sszDevcFllMane：XDeviceAlleintegritychecksucceededDeviceZFilenotconfguredDeviceZFilenotconfiguredDevice/FilenotconfiguredDeviceZFilenotconfiguredClusterregistryintegritychecksucceeded1.ogicalcorruptioncheckbypassedduetonon-privileduser直询Oracle数据库vote信息gr1d0aubdb2crsctlquerycssvoted!STATEFileUniversalIdASM.Disk.Group信息Orade数抠库参数文件信息穗库ASM_Disk,ASM_DiSk_GroUP信息直询ASM_DiSk信息9Q1.>electne.pMbG>FJHTPDISK-HUNKP处UFfrov*.dA;PATHCMXPjUEDlSK.>FAiurajpMTA.OOOOdeMrdlkW10DRTA-0000MTA.0001cMr¼dAH11.KTA0001WTA.OlXeZdeMrM1212MT牝¢82DAgJWWZtovrM11312J0ATA.CW30CP.0000ZdwZrMitfcM2(>Oa1.OOOoctevrdav½21.OCR-OOOldevr72>OO1.OOOGMTA.c45rdm1MTaJX»4WTA.0O6(vrM>51iWTA.0006MMJXKle1>MA.Ce06MYaJ»075rM*71rMTAJX»7HB*CFATHGUajP-HMBWIttSK-HfFAIUWOFD0TA.00C6询牝809cvrMafcvrM*9iMTa-OOOe19MT牝13row.selected.SQ1.>connZasSySdbaComected.SQ1.>showparameterspPlle：WMETYPE«W1.UEspfilestringDATA/ahubspfIlMhMb.oroOrade数抠库限制文件信息SQ1.>selectMeFrowv>co11trolflle;tm:*DATAubccntrQlFlcurrent.256.965898599Orade数据库数据文件信息SQ1.>WOj1.oOtCOEOF1.OmV冬CiOtOFJ1.J1.o;ZaME-faB/dot-FA10wuwt0m.262.651*DATAZoHwk>Zd<9t,<3Fx1eZsw<三>ux.263.BG59e27DATank"Hut>ClO七oFx±eumciotk>s12><4.5>53*DATAZKwBdataF1±o/jcdo匕B=2.2.8G5898729DATAZKutoZdazeFx1Zusirs.2&7.86589879MTamh3Bc4wtwF工1.=mk3匕ClWt1.)O1. DATaa-3B/ClAtqFi.10/-iuBcletteO2 DATobnuBCiO匕OF1.o/ofutodo匕OoM DRInH3bCio七OFJ1.i.o=KUIkDCio七o04 DATAZeKk>ZdetaiFX±ZaKk>d.s*-t,三OS*DATAZeKfcda匕aFj.1三KBei三t<三OGNAMFAaaaaaaaaaaTttttttttttgsgggDAggsggbbbabKa匕.DFffffffffff0<5音一<=(oow-匕t.匕t-匕匕匕匕匕匕。e*m<=lOO0s昔3oddddddciciddXXXA-XiOoll-UOoetlHmmm7e90l23456sooo'±1111.riri1Oaw=OQaam-t.t.Jt-t.t,.匕匕匕匕OwWw=dddddcldddcldM三三三第10页,共44NAMEDAITbdu匕OF工，D/uhwbUobolbDATAhwbdc1.fxle«Hb<.Uit«l9DAAZoHwbZd«t«Fi1eohbcUtak2ODATAZebwt>/d«t«txle-ohwbiCaeXO1DATAZdoteiFx1«/«hb1r»dc*>:O2DATAzzOHwtoZdeiteiFRlUZZOhWbircfc？MO?DATAZobwtoZcieitaFxle/ehwbxnciexO4DATA/eHwto/detefx1e?oKbxr>ciexO5DATAoHwbdotofx1<*zoKbxndexDATAaKwbdt,x1ezKwbxrciexO7DATAZeHwtDZdataFx1ezaKubxrkcie>rNAMEDATzcHwbzdct.cF1c/chuihiCeiftXoqDATAbE)rint.nfIICZZChUlb1rx*>r10DATA2b/dcf,"lienhub1r*x11D»'«TG/HwbH.>t,.FlieZZchhlb1rctx12DOTA/>Hwb/dt.11e/.->hwbinciex13*DATnaHMbdat.cflehwblnctoxl4DAT11ZaHwbZdataFllc>hb1rix15*DATAZaKwbZdatzaF1lahbirix16DATZaHwbdat-aFlieahb1rix17DATZaH»bZdaVaFi1eahwblrtex18DATQZaKwbZdabaF11ahblnctex19NAMEDATAZaHwbZda1.c*llec<hwbirlex20Zop1.Zor4U<C<s<3FhcFhrU三-三<.UbF4rows二UIDJ1.Ud.Orade数据库日志文W自息SQ1.>selectmumb=Fromv>logF1MEMBER毯器DA器毯DAAaaaaaaaaabbbbbbbbbb三z三三三gXAi-X二二器霏Oooorr-r-r123457l7Q9olsolz卷能塞碧27.2A-999555,?!:-:1.1;，工5三三5555Oracle数据库Tempfile信息SQ1.>select,r>omoFromv*t,emF>FileNAMEDATAohwbt,e11RFiIeZtzesmp.265.59715Oracle数据库归档日志信息SQ1.>selectcameFmomvrchived_lognor-osselected3.1.4检查系统及设备运行状态包括并不限于以下运行状态：系蜕信息备注分工界面业务运行状态运行是否正常凌要客户堂新启动业务进行验证客户（板如业务是华为提供.则由华为负责）集群和数抿库运行状态运行是否正常/质爱客户B新启动集群（Ciig¢三f7iil客户（翔In业务是华为提供，则由华为负责）主机运行状态多路径运行是否正常、HBA卡及犍珞是否正常等颁要客户或新启动AlX主机进行可用性验证客户（假如源存储也是华为供应,则由华为负责）源存储运行状态RAID.1.UN.映射关系.告警工成等配雷颉客户（假如源存诸也是华为供应,则由华为负责）贿交换运行状态光纤交换机运行是否正常,值珞连接是否正常客户（假如光纤交换机是华为供应,则由华为负责）,检查过程中假如发觉业务软硬件环境存在故障,必需在启动数据迁移前完成故霞处理，确保业务系统I啖管都健康运行.3.2VIS6600T初始化配置参考VlS配国手册3.2.1 仲裁盘配置参考VIS配西手册3.2.2 集群状态检查参考VlS配一手册1 .当目标存储新创建的1.UN的运行状态是"正在格式化"时，可以进行配M操作，但不能进行数据迁移.2 .全部1.UN的运行状态从“正在格式化"变成“在线”后，表示可正常读写数据，才能再进行数据迁移操作.第12页,共443 .启动数据迁移前，必需确认目标存储（S3900）工作状态正常，无任何告警，否贝怀能进行数据迁移麋作.3.3 S18500健康检查参考S18500维护手册3.3.1 在维护终端上安装OCeanStOrToolkitI（S18500SVP自带）参考TooIkit管理员手册3.4 数据备份参考文档备注分工界面业务正置信息柒群.业务平台（数据摩业务配置）等维沪工程师集作系统信息备份3.1.2节中涉及的系统信息维护工程你和华为工程师光纤交换机配置般如业务中有用到光纤交换矶，则备份防交换周的配置信息华为工程帅源存储数据源存储上即格进行迁移的数据须要备份华为工程伸A_第4章数据迁移方案OraclellgR2RAC在AIX环境下数据迁移操作步赛如下：4.1 博科S5300港干交换机配置4.1.1 eii!Zone创建别名alicreate"Bvis1_A_C1_W0",”20:08:10:51:72:0d:e3:db-alicreatealicreate"Bvis1_B_C1_W0",20:18:10:51:72:0d:e3:db""Bvis2_A_C1_W0","20:08:10:51:72:0b:fa:b0"20:18:10:51:72:0b:fa:b0"'20:00:10:51:72:0d:e3:db",20:10:10:51:72:0d:e3:db-,20:W:10:51:72:0b:fa:b0",20:10:10:51:72:0b:fa:b0"“20:02:10:51:72:0d:e3:db-,20:02:10:51:72:0b:fa:b0*,20:08:30:d1:7e:72:90:32",20:18:30:d1:7e:72:90:32,*20:09:10:51:72:0d:e3:db"20:19:10:51:72:0d:e3:db"'20:09:10:51:72:0b:fa:b0,20:19:10:51:72:0b:fa:b0",20:01:10:51:72:0d:e3:dbB"20:11:10:51:72:0d:e3:db,20:01:10:51:72:0b:fa:b0*"20:11:10:51:72:0b:fa:b0",20:03:10:51:72:0d:e3:db",20:03:10:51:72:0b:fa:b0"22:00:30:d1:7e:72:90:32,22:10:30:d1:7e:72;90:32"alicreateBvis2BC1-W0",alicreate*Bvis1_A_CO_BO".alicreate-Bvis1_B_CO_BO".alicreate,Bvis2_A_CO_BO",alicreate'Bvis2_B_CO_BO",alicreate"Bvis1_A_C0_F2",alicreate*Bvis2_A_C0_F2",alicreate-BHW185001_SPAO".alicreateBHW185001-SPB0,alicreate"Bvis1AC1W,alicreate"Bvis1BC1W,alicreate”Bvis2_A_C1_W，alicreate-Bvis2_B_C1_W1".alicreate"Bvis1_A_C0_B1M,alicreate"Bvis1BCOB,alicreateBvis2-A-C0-B,alicreate"Bvis2_B_C0_B1".alicreate"Bvis1_A_C0_F3n,alicreate"Bvis2_A_C0_F3",alicreateBHW185001-SPA1",alicreateBHW185001-SPB,创建ZonePSW01&BSW01zoncratePvis1_A_C1_W0_Pvis1_B_C1_W0_Bvis1_A_C1_W0_Bvis1_B_C1_W0","Pvis1_A_C1_W0;Pvis1_B_C1_W0;Bvis1_A_C1_W0;Bvis1_B_C1_W0"Zonecreate*Pvs2AC1WOPvis2BC1WOBvis2AC1WOBvis2BC1W0","Pvis2AC1WO;AManosmbmb«(a三asmbamaaPvis2_B_C1_W0;Bvis2_A_C1.W0;8vis2_B_C1.W(FZonecreate-PHW1850001.SPAO_Pvis1_A_C0_BO7PHW1850001_SPA0：Pvis1_A_C0_B0"Zonecreate-PHW18500O1_SPA0_PViS1_B_C0_B0TPHW1850001_SPA0;PViS1.B_C0_B0”zonecreateTHWI850001_SPA0Bvis1_AC0_B0,*PHW1850001_SPAO;Bvis1A_C0_B0"zonecreateTHWI850001_SPA0Bvis1BC0_B0,*PHW1850001_SPA0;Bvis1_B_CO_BO"Zonecreate-PHW18500O1.SPAO_Pvis2_A_C0_B(T-PHW18500O1_SPAO;Pvis2_A_CO_BO"Zonecreate.pHW1850001_SPA0_Pvis2_B_C0_B07PHW1850001_SPA0;Pvis2_B_C0_B0”Zonecreate-PHW18500O1_SPA0_Bvis2_A_C0_BOTPHWl8500O1.SPA0;Bvis2_A_C0_B0"zonecreate*PHW1850001_SPA0_Bvis2_BC0_B0,*PHW1850001_SPA0;Bvis2_B_C0_B0"zonecreate"PHW1350001_SPB0_Pvis1_A_C0_B0*,"PHW1850001_SPB0;Pvis1AC0_B0,zonecreate"RHW185O001_SPB0_Pvis1_B_C0_B0"."PHW18500O1_SPBO：Pvis1_B_C0_B0"zonecreate"PHW185O001_SPB0_Bvis1_A_C0_B0"."PHW18500O1_SPBO：Bvis1_A_C0_B0"zonecreate"PHW185O001_SPB0_Bvis1_B_C0_B0-."PHW18500O1