您好,欢迎访问三七文档
当前位置:首页 > IT计算机/网络 > 数据库 > Netbackup备份多节点HANA备份实施
XX系统备份SAPHANA备份实施方案V3.0Symantec2014年4月SAPHANA备份实施方案1、文档属性2、文档变更历史清单3、文档变更说明(仅描述本版本的变更内容)序号变更内容简述123SAPHANA备份实施方案目录1备份介绍....................................................................................................................41.1系统建设背景....................................................................................................41.2备份需求............................................................................................................42实施方案....................................................................................................................52.1HANA备份介绍.................................................................................................52.2备份网络要求....................................................................................................62.3备份策略............................................................................................................62.4环境说明............................................................................................................62.5HANA备份部署.................................................................................................72.5.1Master创建SAP策略:................................................................................72.5.2HANA主机上配置:....................................................................................112.5.3在hanastudio中配置:.........................................................................122.5.4从HANA中发起备份:...........................................................................132.5.5从NBU发起备份.....................................................................................142.6HANA故障的备份切换...................................................................................142.6.1生产库故障...............................................................................................152.6.2副本库故障...............................................................................................162.6.1开发库故障...............................................................................................19SAPHANA备份实施方案1备份介绍1.1系统建设背景1.2备份需求完成SAPHANA应用系统的数据备份。以下为NBU备份系统的技术术语:Netbackup主服务器(MASTERSERVER)独立的服务器,作为该备份域的核心和集中管理平台。负责为NetBackup选择介质和设备。主服务器包含NetBackup目录库,该目录库包含内部数据库,内部数据库中包含有关NetBackup备份和配置的信息;安装Netbackup的MasterServer软件。Netbackup介质服务器(MEDIASERVER)xx系统环境中需要使用SAN网络(LAN-Free)技术进行备份的业务主机;安装Netbackup的MediaServer软件(同NetbackupEnterpriseClient)。Netbackup客户端(CLIENT)xx系统环境中需要通过LAN完成数据备份的业务主机;安装Netbackup的Netbackup客户端软件。备份设备xx系统物理磁带库IBM3584带库;SAPHANA备份实施方案2实施方案采用LAN方式实现SAPHANA的备份。2.1HANA备份介绍赛门铁克NetBackup软件对SAPHANA进行数据保护时会调用SAP的backint工具。SAPHANA会被设置为备份模式,并将数据从所有HANA节点传输到NetBackup的介质服务器上。完成备份后,SAPHANA会自动退出备份模式。这样就保证了内存数据库备份的一致性和可恢复性。SAPHANA的所有节点上需要安装NetBackup的客户端和SAPHANAAgent。支持单节点和多节点HANA环境,备份方式目前只支持LAN备份。SAPHANA备份实施方案2.2备份网络要求原则上,推荐使用独立的网卡用于备份系统。在不具备以上条件的情况下,尽量避开在应用系统使用的高峰时段来发起备份作业。网络防火墙要求TCP/IP协议,双向开通如下端口:源主机目标主机通讯端口说明MasterServerMediaServer1556,13724,13782双向MediaServerClient1556,13724,13782双向MediaServerSANMediaServer1556,13724,13782双向上述端口的TCP连接是长连接,不能设置连接超时。2.3备份策略备份方式备份频率备份时间保留周期全备份每天1个月日志备份UserBackup1个月2.4环境说明TypeHostnameIPNBUVersionMasterServermssbkserver192.168.9.1027.5.0.6Clientdhanadb001-datadhanadb002-data192.168.127.186192.168.127.1877.5.0.6Clientqhanadb001-dataqhanadb002-data192.168.167.185192.168.167.1867.5.0.6Clientphanadb001-dataphanadb002-dataphanadb003-dataphanadb004-dataphanadb005-dataphanadb006-data192.168.68.181192.168.68.182192.168.68.183192.168.68.184192.168.68.185192.168.68.1867.5.0.6环境说明:MasterServer使用ClusterMaster,由mssbkserver01/mssbkserver02两台主机使用VCS搭建,servicename为mssbkserver。用来制定和管理备份策略。SAPHANA备份实施方案Client安装部署了NBU7.5.0.6client软件,HANA备份通过MasterServer备份到磁带库。2.5HANA备份部署2.5.1Master创建SAP策略:以PHANADB为例,创建备份策略:备份类型选择SAP,勾选FollowNFSSchedules会自动生成一个DefaultSchedules,调整保留时间为1month。手动创建一个AutomaticFullBackup的自动调度策略SAPHANA备份实施方案选择备份时间窗口SAPHANA备份实施方案客户端选择phanadb001-data备份脚本备份脚本详细内容如下:#!/bin/sh#bcpyrght#***************************************************************************#*$VRTScprght:Copyright2013SymantecCorporation,AllRightsReserved$*#***************************************************************************#ecpyrghtSAPHANA备份实施方案##NOTE:#1.Providethepathofhdbsqlas/usr/sap/SID/HDB01/exe/hdbsql#2.Needtomodifybelowhdbsqlcommandaccordingtoyourconfigurationwithoptionsas#../hdbsql-iinstance_id-ndatabase_host#-udatabase_user-pdatabase_user_password#ModifythebelowhdbsqlcommandsbyusingproperSIDname#3.SAPHANAMasternameandhostnameofthatNodemustbesame#RETURN_STATUS=0##GettheSAPHANAmasterserver#SAP_SERVER=`/usr/sap/P0A/HDB00/exe/hdbsql-i0-nlocalhost-uSYSTEM-pHP1nv3nt-j-a-x\selectHOSTfromM_SERVICESWHERECOORDINATOR_TYPE='MASTER'LIMIT1\`##CheckifSAPHANAmasternodeispresent#if[$SAP_SERVER==];thenechoSAPHANAMasternodeisnotpresentfi##RemovequotesfromSAP_SERVER(HANAmaster)namestring#SAP_SERVER=`echo$SAP_SERVER|seds'/\//g'`##ConverttheSAPHANAmasternametosmallletters#SAP_SERVER=`echo$SAP_SERVER|tr[A-Z][a-z]`echoSAP_SERVER=$SAP_SERVER##GetHOSTNAME#HOST_NAME=`hostname`##Convertthecurrentnodehos
本文标题:Netbackup备份多节点HANA备份实施
链接地址:https://www.777doc.com/doc-2889549 .html