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