Netbackup备份多节点HANA备份实施

1、XX系统备份SAPHANA&份实施方案Symantec2014年4月1、文档属性2、文档变更历史清单3、文档变更说明（仅描述本版本的变更内容）序号变更内容简述123目录1 备份介绍错.误!未定义书签。系统建设背景错.误!未定义书签。备份需求错.误!未定义书签。2 实施方案错.误!未定义书签。HANA备份介绍错.误!未定义书签。备份网络要求错.误!未定义书签。备份策略错.误!未定义书签。环境说明错.误!未定义书签。HANA备份部署错.误!未定义书签。Master创建SAP策略：错误!未定义书签HANA主机上配置：错误!未定义书签在hanastudio中配置：错.误!未定义书签。从HANA

2、中发起备份：错误!未定义书签从NBU发起备份错误!未定义书签HANA故障的备份切换错.误!未定义书签。生产库故障错.误!未定义书签。副本库故障错.误!未定义书签。开发库故障错.误!未定义书签。1备份介绍1.1 系统建设背景1.2 备份需求完成SAPHANAS用系统的数据备份。以下为NBU备份系统的技术术语: Netbackup主服务器（MASTERSERVER独立的服务器，作为该备份域的核心和集中管理平台。负责为NetBackup选择介质和设备。主服务器包含NetBackup目录库，该目录库包含内部数据库，内部数据库中包含有关NetBackup备份和配置的信息；安装Netbackup的Mast

3、erServe前件。 Netbackup介质服务器(MEDIASERVER)xx系统环境中需要使用SANW络(LAN-Free技术进行备份的业务主机;安装Netbackup的MediaServe缺件(同NetbackupEnterpriseClient)。 Netbackup客户端(CLIENTxx系统环境中需要通过LAN5I成数据备份的业务主机;安装Netbackup的Netbackup客户端软件。 备份设备xx系统物理磁带库旧M3584带库;2实施方案采用LAN方式实现SAPHANA勺备份2.1 HANA备份介绍Net BackupMaster ServerPolicylOGB/sxlNf

4、t 山H kiupNetBackupMed a Server1GB/SX3Shared Storage (NFS or GPFSHDQHDPHPD赛门铁克NetBackup软件对SAPHANA®行数据保护时会调用SAP的backint工具。SAPHANA被设置为备份模式，并将数据从所有HANA节点传输到NetBackup的介质服务器上。完成备份后，SAPHANA自动退出备份模式。这样就保证了内存数据库备份的一致性和可恢复性。SAPHANA勺所有节点上需要安装NetBackup的客户端和SAPHANAAgent支持单节点和多节点HANA环境，备份方式目前只支持LAN备份。2.2 备份网

5、络要求原则上，推荐使用独立的网卡用于备份系统。在不具备以上条件的情况下，尽量避开在应用系统使用的高峰时段来发起备份作业。网络防火墙要求TCP/IP协议，双向开通如下端口：源主机目标主机通讯端口说明MasterServerMediaServer1556,13724,13782双向MediaServerClient1556,13724,13782双向MediaServerSANMediaServer1556,13724,13782双向上述端口的TCP!接是长连接，不能设置连接超时2.3备份策略备份方式备份频率备份时间保留周期全备份每天1个月日志备份UserBackup1个月2.4环境说明TypeH

6、ostnameIPNBUVersionMasterServermssbkserver环境说明：MasterServer使用ClusterMaster,由mssbkserver01/mssbkserver02两台主机使用VCS搭建，servicename为mssbkserver）用来制定和管理备份策略。Client安装部署了NBUclient软件，HANA备份通过MasterServer备份到磁带2.5HANA备份部署2.5.1Master创建SAP策略:以PHANADB为例，创建备份策略：备份类型选择SAP,勾选FollowNFSSchedules会自动生成一个DefaultSchedules

7、调整保留时间为1month。手动创建一个AutomaticFullBackup的自动调度策略BChang*Micy-hUA.?B_BK.FHMmisbKMfVfrf,司Attnbultt（电IcMm.C*«iie-39BackupSvfeOiMENam，T*ps期41*匚日“Dif2叫a段,匕W4口兄”Ri1#n1ig<iL«.F叫J#mGVM*di?MlU酮叫出。电WitADCiication-EidC幅BlCMan.-1mwtr二1卜第MlAutcunatic_一Nq1month1曲，1up选择备份时间窗口客户端选择phanadb001-data*ChangePo

8、licy-HAMi_D&_&K_PHANAI&Attri刎心心丸曲暗Cliriltj,诉PjUau卬ludi一卜时CkeMtdiiwn合Indeiing驾Rh前第1H研牙-GUTSuSEZ,g1&Off备份脚本.ChftrigfPolity-B_UK_PMAhfAlTSv<v#rm«sbiie-rwElMtoHtii号凯hwi除.”看CiweQ9BackiypSvteclnvii日StledlwLl3tIt|ihQiFmqrrptq'彳ap.h=na-口.na-!U;h>备份脚本详细内容如下:#!/bin/sh#bcpyrght替*

9、#*$VRTScprght:Copyright2013SymantecCorporation,AWRightsReserved$*#ecpyrght#NOTE:# 1.Providethepathof"hdbsql"as"/usr/sap/<SID>/HDB01/exe/hdbsql"# 2.Needtomodifybelowhdbsqlcommandaccordingtoyourconfigurationwithoptionsas# ./hdbsql-i<instance_id>-n<database_host>#

10、-u<database_user>-p<database_user_password># Modifythebelow"hdbsql"commandsbyusingproper<SID>name# 3.SAPHANAMasternameandhostnameofthatNodemustbesame#RETURN_STATUS=0# GettheSAPHANAmasterserver#SAP_SERVER="'/usr/sap/P0A/HDB00/exe/hdbsql-i0-nlocalhost-uSYSTEM-pHP1n

11、v3nt-j-a-x"selectHOSTfromM_SERVICESWHERECOORDINATOR_TYPE='MASTER'LIMIT1"'"# CheckifSAPHANAmasternodeispresent#if"$SAP_SERVER"=""thenecho"SAPHANAMasternodeisnotpresent"fi# RemovequotesfromSAP_SERVER(HANAmaster)namestring#SAP_SERVER="'e

12、cho"$SAP_SERVER"|seda®HAM-函网»*HATJADK_PHANAEa%HAW<DB_BK_PHANA3a事HAfJA_DB_BK_PHANA4a0曰一日KFHJN为5s'/">。HATJ_DB_BK_PHANAS# pone/:isanoption1parameterandsnouicMsettornenaireorasappolicy# typethathasdefirecinThejappolicyBusthavtascheduledTypeofApplicaticnBackupdefineeino

13、rderforBACKJINTtovtork.ifBACKINTfinds¥a154P_policvenvironrentvariabie.tnepo1icypar工眦tgrvalue11be# overridanbyvaljaoftheJsap_policyvar'iabla*ifth#policypar# isnotspecifiedandthereisnoenviranraentvar-able!thenBACKINTwill#exitwithanerror.policyHANA_DB_BK_FIANAflpnanaaDOUi;/usr/openv/n-etcackup

14、/exr/-att_ext/sapisnade_nannestxtscript5phanadbOOl:/usr/op«iv/n«backup/ext/db_ext/5apfmorenode_nams-txtphanddbOOl-daraphanadbOOl:/usr/openv/netbackup/ext/db_ext/sap*.n-s/usr/openv/netbackup/bin/hdbbackint_script/usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint如果不存在opt目录则手工创建hsrwtrst:/uira

15、p/ftflA/S¥5/r)lntwl/hrikVnf1*1：-Itrtotal01rwxrrtKTwx二rootroot422119:44hdbbdckint->/usr/op=n/retzkp/bin/*idbbdekim_5crihandLt!、i:/usr'A却/oOa/'Y、/叩ubal/ldU/upi，2.5.2在hanastudio中配置:HamcDefaultSystem，_.g>obaiiru«3berkup.diitcbflckupJbjHrrsirr512d34£_E-acfcup_maK=dnunkseze-0d

16、dtabddkupjaaiijn»ett_flIe/ui'/cpern/ntibickLpb."，打p.sciiptirsap_t>-atle/iniiSJ-PuUddULdckup_SA.punl_lock_tnieout72Klag_b=ckup_t-uEr_EEE12Bldg_b=ckup_parimEterjile'u£：cpE皿，nESbazk-p/extdb_c(t.i'iapscnpts'5ap_QnBc.le'iritSr1P.Ltllog_l>TCkup_jsihg_biicknt阿器truem

17、ercbffl：kn-1_.1iflrritfXHn，k一口hejL阑r_a费SODvt*viewC"第r酸用用gimpLaTfei的EUc&H£»ettinqcL.iilicureihefannsBja-iEdkhwd|Mi1ylM«Jkup匕MiiifMtcdjiingbfMrj<n>rtahieFwEfiemdhrtt>g0lLE-'clc"!:Agcrtaccen't.口访nmbun匚krrt_:zripth>muUWiuplB«kupIII<i>I>./J&#

18、39;-!'.-ir'lMlh-jr”4-.I-|4九(JjJEihe”由工户/地Fabs；ki.L”71叫心华Tefl OuipuJE:Ffe-B*wd m*鼻 hc'kup-ne 驯和H巾是式i孙中一旧比edLn3s #： u Epwrl,' 的日日MteEftrMtkn, J you *£ /、 A H4k 曲圣力暗中人 MXnt倒醛*自必修00立制HJdy 曰盅bfirty EiIj»R I d«J bactalp> Fr jf4pnwed data 哂财 it i百 fEwnme4ded 1d *mc向 bh eWi

19、h4 b讨回g ocsti'_at1.DeEliiwticn:/uff/5dp.,nMCH®L,lJ« 上晚口凯3IAmi cm ifnd IfatiHMdiinHFn tin . Mhiir-iptcrfK dHi bMhup lilfi. Il u”p tr，"+让干: -F-r.Fuf-d s e £ rn- ; m-jhip- * 酊1.由iukLfique-ntiaily. 均 加如u口 d<B bf £kutnA spiff JhL'om muBiple 1ile&.I LJrnrt K'mir

20、iuE File 张eIMM n胃bc>n T w 一 Rl* w中 BbcM OPtndbcn： - - ./'DC-mS''- _ _t= 二.匚曲.kmIkBdiif Irf EFVBfe *15klnutK - you dtubla julafnarhc lo>g bakij. ih« k)g lanaa *工mLq皿 lc- ill. A1J kig wzWil CJUMi 由I dvl4l« W 脸叮-Aln白frunlc gq 叵求kqp2.5.3 从HANA中发起备份:Type应该选择backintSptcify”由up窜

21、i，晔可附卢MrnaiieR<crthe曲忖feachjpfrtimirtEdhacku?sre9JflG8.修Slacfajplyps«omplet-DstsB4ckiqiQBmjtignTyp*T目"*UpEnafiH畔Th*'iMtotilt*MiMliM*gcdiltHyintc附diftavniriHftrnjtnrLVmusiuifyimwdEGinKg久«n-=ufcthaethedirerloryaireddr3H土.RiramprovEOMMmMft1P止krgccnirritradedtospecifyjdbackJFjoem喷飘

22、wm.BadkjUFC*7e力口匚'-i's-apL,DP-.1AglcLalndtaii.iriSadcupPre%CCMFLETE_ftA.TArBACKUFJINtemiL>5lliLl'!：-ipttrlra.tfwigngLhcSAPHAHAdftibiiE-t&fliigMtftHNiireHvtm-ed融pudo#th*”，bfkup-Mc-eirlor-iatzn;SAPAdnwn吐FilGuid± HANA中看到备份正在运行:后SeckpofStemDOABackupProgressInfcrmatian!Wait

23、ingforstatusofbackup. NBU中看到作业:»JcftaiVOuimri'*1.*»«W.vMq|MyU笳IItaLiPdtl»菖,目iM加旭巧imW)aHRIWiHJ向.¥典&皿h7l|H3则AtaHlTImfpsnj*dTi*即BiaLlHFOonai1口haRri_ta±1匚咱HuK即日比明Mrtii4LldJD14-121-11fc晒m整刘冲1j。脚，中粗每1hM中h邮$和况咄IIW重由.：UI.'|tr1/w师鹏骞而Ml寸*加日agdmbDMR、,司lDabuil/Jp

24、tkdjari-lachij|iMiUiMl“而修£|赢1*14-1-311t1S13DDU11B国iwiqX电E日Dcfin0hana_ta£ii二pUul一厢#huinmMbi#hanalKtrin-kdA,i.1-：1*3JI1DH2dIdH-l-JODfl*口MF0用值睁卜修哪h-q忤b1iMrvnfdBJli«Mff.1j"MMITnu>i>r*QLBAEinpDeash»a_1adCvfa_t-.f'lEmiEubxphanafKtwnvHAda2514-1-21TE1235皿皿西3RU-W*«&

25、;BSiLIl19DOflfl£>hiRa_tas-1口aWuhMMi:皿banMt*rfn.3M4-1-J11*1MlDOHIJi刘Wlj*/“过。ML*F日触MpMi!GrbW制办.用jwji2|rr-nt典MF1国蠢1小才TtNEhH/mmDtrai9_101£1EXi&LJl-/0pl3tin-ExbL|pInnatnd:nirvn-adlaibDEiaDfflD3.ZBhMT窜4j,Bf£lLijp>G>mi0hita_lax-1hin-riMl;-rm.iUrt-ufea-jMDQHJ加141i*fi1Htrlii*OmtCM

26、)PkH|i¥lp9&vF.MIwn-Vi$bfavMh>Mmrvn«di傅%MW72加小iq*Bad!ipDmeDhaia.tesl二七H&nmEbc1uphanatritrariTi-Eda2H4-H21lb:D5i41DORJUar-*04n*也附CqkiMpRlk如n0b5附mil蚓En'm.il4AN4-U1Iftfi&iUMOO时西MlQE匚岬物il总甲nDnHuphanriWWNH1i«d8mm陋口，!3MW"ai*T<r*97BacDhie1h»_IeFDcWIa*1mnEeU甲hin

27、riritnnm-ffdi2：l4-1-21t-.DJTSmmK3151-，*&h#由fin，CtKi，Mpit1e科n配hirndMFL*Xri：iI-agDtDl41第*蛾ElErOono-。hapk.hvlCvh”M*pitmmk：kwphandwfvHHP4rtaJU4-1-21itpi4dIMIM21MU-t-J宜刊meOme1ChaPi_lE5l口划，|明g早lEGn*M，yphinitHfvrirvn*pilaj?ia'ij,»u115EMSanl-j2.5.4 从NBU发起备份右键选择HANA_DB_BK_PAHAN策略，选择ManualBackup&

28、lt;=画画回邑画画圄承隼.m弓 stKwmrmr iClu?tsr&d hlaslmr Sanr)同 mssbrstrf (C U=gr9UHWflGf 5白百豳 dGtku p .,叮 h 至二n a H £ E1OKMcnrtQrV 刿 2.彳二-$ l3”EeEn十=：Rap口g现P3UCI中营> 国 Sroraqo节 CsU «d.-谑 Hosl PropeftiBS电 Midi* and dmc» Manaigtinrwt式 Daco Meritor卜 BNediaW WkSA 镇 C Tkllfdl、毛 ：655 Man3g=n:婚 /

29、xir i.idFggpmrl Dtrc lJe:al Re5：of< MancQime tAll Poficiea» eiver iMsster Strven*等mumrry5却Fq一净 i| <-FK*命际二H-日用TLMMU的。虫二H BH TLD» 2M& 啦CK BK TUDMMRP-DB-6K |ANA_DP_RK ma cb hkDHAHANA UH % P MNT HAA_DD_DK_r4-HAM5BLBKJ)QbHANADB-BK-F haiha_db_bk_p HAMA CD DK P, HANA_DB_BK_a 0 hana_db_

30、bko * U3m-AkCh-bK_LfU Dti tKA 而 LCYQ-Dl-EK-GDLCYO-00-BK-Gty* LC¥Cf-0t-EK-GD b LtfU Dt-Ek GUHJUJA DQ BK PIIANA1tne7l 内DB EK P/W印 Nnw Policy.。Hew Scltule-七“mienl_j NMMBKkUp SelFCll(：(i.n兮喇t_.、DeleteQ 口呼 E歹 (?PY oNe j,粘 copySAPri» 物 L*ru-Lif4ik-SL3 HtncthD»«ctivawa01LCYQ-Dz-EK-J3C&g

31、t;.C¥Q-D6-EK-JF?ra律_C¥Ce-DE-EK-J8CaLCva-De-BK-sn曾等,C7C三EK-2HI_fftiIC2CCLI-!hI1,可以看到备份正在运行1圣gn用AHFiftwinitaftMF|«QKiflBffif*M>thw*MKfL11*|T«hsiitaJb|PWatariTtrnfiJtabEdiKMiSWsMl片于5W4Ewfcuc“小用网剑尸内血EltmRbgi司力2Di4-tZ714Hif口jHni,Ebon屯Rm。tWtiP子»Mouei璃aMHWIpHgnEPQIN总即伊*皓15W书叼UPj

32、ww&好imBRdi白HA*-DB_flfc.JpHvH出a应)DOndgJD144-2±1£/H17dailEAMi>ubeMi-BAL3<ajp代mttntMAI*_rejK_rt*£MMO必修Ml+4®1lMlV胤用W网浜#KKDEvudQEI_:0K_PHWMptianvftHlMaOZDiy立噂*9中DftaufrApoi'Otwn-BarwjpF?«ibi制白詈11_NJIkPbW*l那ExoBgq却怪4建怖呼行mltWWKUkypmm寅玲EHAi*JA_DajBK_pHVM5aflabDOMg201*9

33、1至1T1T*uMV触皿NET?a立安mHA"_田邪产FW*S65科H1W曲2D14-4-221S壮1?<aultAppiLfilK-BAjajp叫gt,富阳”1*U|?川2.国日KFHMM1EBn9ritap4*BW1+4-2?HMTJ口nMIcBhE用mwpM?9芸际1E：1刈QkW-reHKPM»f聃1mEMtiWJHg2P1J-4-22EITJ5hP备份成功结束b xqH IhMf 涮口通而一t MC-2f睥明的。哗t MMBsKHtf祷X总值修g gssMcnl3Sqn TiiymJdB> BdMiiitaUIxL曜jBUMU 4_E_BH_.*>

34、;4*PhflinidQWrdUl刖E ssfDlfMTO*ralS»-B3ipzi?i»9阳小06 尸.PmMMHuKid9Mi±ra即*船界1H7jh l>*Bh中中 Si即。向弊9MN A_CELgK_PHWM .phjni AW-1-433ZQ35ZZE ftl?匚小吁W EtfkB事加pEEqgH|由第Ml刖11|1Twz -BVBUIPqphanad&MIMa即 UfkZZETBjTEa ufrApo* E?e-B 享r pf7ttiQM3J3F urr书。1ST»MqH TfJDe-Bf.P+WWgnadiiOQ±d

35、xtaam-iksiij 1&17Drts utMpo %K»U pWflTZQ-griimMOXgMWhQ1 14 Il-ITXi JMMFho* fl -JO«4MM0晒曲附齿而?m力Dels ifr%j rahm 中 a p1HZ口H*N*_DG_&i_PW* Phranm一仙一口芨忖，工 M2.6HANA故障的备份切换New Policy New Schedule.务 New Client._i New Backup Selection*., jnser(+»InsertX DeleteDelete尔 Change.学 Copy To He

36、w.X CutCtrLX物 CopyCtri-CI 皂 Pgistecwmrl Refresh=5ActivateDeactivateManual Backup.In nlfrall I II EIV LIU GdnE-e2.6.1 生产库故障生产库当前有6个备份策略，如下：0-碰HANAD9DKPHANA1A彩HANA_D3aK_F*HANA2A辱HANA_DB_0K_PHANA3A8HANA_D0_BK_PHANA4aHANAD9_0K_PHAIMA6o-笛HANA_DB_BK_PHANA6HANA_DB_BK_PHANA为主备份策略，实现自动备份调度。HANA_DB_BK_PHANA6备

37、用备份策略，平时为deactive状态，当phana001切换到phana006时，需手动启用该策略。如果phana001主机down掉，SAP_MASTE隙切换至Uphana006主机上，此时需要手动启用HANA_DB_BK_PHANA的份策略。操作方法为，右键选择该策略，点击Activef'B|iANA_DETOK_PH打心f®HANA_D9_BK_C1HANA1富Attrib-utas卷Schedules也Clients由BaclcupSelectionsTH处IA_D日K_QHANA2望Attri&irtesSchedules也Clients通BacKupSe

38、lectionsoLCYQ-ARCH-0KbggLCYQDB-BK。LCYQ-DE-BK-CD01*%LCYa-DB-0K-GDO2>LCYQ-DB*BK-GDD3O0LCVa-DE-BK-CD04中qLCYQ-DB-BKJSaio件LCYQ-DE-BK-JS02A*LCYQ-D0-0K-JSO3a®LCYQ-DB-BK-JS04irYn-nR-RK-urnActiveHANA_DB_BK_PHANA6,需要DeactiveHANA_DB_BK_PHANA1份策略。aHArJA_D0_EK_PH/M>*HANA_DB_BK_FHAMa舜I-泞蔺_DR_Ea_PH对JHAI

39、MA_D0_BK_PHAMHAnA_D6_9K_FHAlN*&H,rJA_D0_EK_PHAfJHAhWKJIHAFHAttributes通Schedules嚏Clients国BadajpSelectionsHAIMA_D0_BK_QHAI画AttributesSchedules吨Clients迎Sack.upSeledion;LCYOARCHKLCYQ-DBBKLCYQ-DB-BK-GD01LCYQ-DB-BK-GD02LCYG*DBBK-GD03*NewP3M.毒HewSchedule.刍NewClient_jHewBackupSelection.e；Insert”In谢X中12他

40、DeleteQChange.曲CopvToNew.XciiiCtfl*X电CopyCtrl-C晶PasteCfrl-v引RefreshFSActivateDeactivateManualbackup.2.6.2副本库故障副本库有两个备份策略，如下:ftHAtJA_DB_BK_QHANA1»HAMA_DB_BK_QHANA2HANA_DB_BK_QHANA为主备份策略,实现自动备份调度。HANA_DB_BK_QHANA为从备份策略，主备份策略会调用从备份策略。如果qhana001主机down掉，需要手动更改HANA_DB_BK_QHANA策略。步骤如下：右键选择HANA_DB_BK_Q

41、HANA策略，点击Change等HANA,：1o-=!Attr卷Set制ClllgIbI日在LCYCh崩LCYQ-令LCYQ-等LCYQ-命LCYQ-INewPoiicy.,2)NewSchedule,.等HewCiieM.QjNev/BackupSelection.»XDeleteQCti日叫日点击Schedules右键选择新建一个SchedulesName为full,Typeofbackup为AutomaticFullBackupRetention为1month,Frequency为1daystail二i.L：二一必-二-、C3Ll<04g二更改完成HANADBBKQHANA汨，删除HANADBBK