SAP备份恢复的安装测试文档

1、SAP的LAN-Free备份系统的安装文档目 录一、安装Media Server前的准备工作21.1 HP-UX系统补丁要求21.2存储空间要求21.3添加IP地址信息2二、安装及载卸NetBackup Media Server22.1 安装NetBackup Media Server22.1.1运行安装CD中的安装脚本22.1.2 添加其它的License注册号62.1.3修改bp.conf参数文件72.2 载卸NetBackup Media Server7三、配置共享存储设备83.1在Media Server上配置存储设备83.2配置共享驱动器143.3配置存储单元18四、安装及载卸SAP

2、 Agent204.1 安装SAP Agent204.2 载卸SAP Agent23五、配置并创建SAP的备份策略235.1为backint文件创建NetBackup的链接235.2创建备份策略235.3创建备份脚本295.4配置备份参数文件initSID.utl305.5配置备份参数文件initSID.sap315.6手工执行备份策略32六、SAP数据库的恢复测试336.1 SAP恢复测试前的准备工作336.2单个数据文件的恢复测试346.3整个数据的完全恢复测试35附录38附录一 主机saptest上的SAP备份参数文件initTST.utl38附录二 主机saptest上的SAP备份参数

3、文件initTST.sap45附录三 主机saptest上的SAP Online备份脚本49一、安装Media Server前的准备工作1.1 HP-UX系统补丁要求在HP-UX11.0上安装VERITAS NetBackup Media Server需要打系统补丁PHSS_22543，安装此补丁无须reboot机器；如果没有此补丁会有如下提示：Patch PHSS_22543 or greater is required in order to install NetBackup 4.5 and does not appear to be installed on this system.1

4、.2存储空间要求Media Server的安装路径为/usr/openv下，磁盘空间要求至少300MB。1.3添加IP地址信息在Master Server和Media Server主机上的/etc/hosts文件中，分别加入自身和对方的IP地址和主机名。二、安装及载卸NetBackup Media Server2.1 安装NetBackup Media Server2.1.1运行安装CD中的安装脚本# cd /cdrom# ./installVERITAS Installation ScriptCopyright 1993 - 2002 VERITAS Software Corporation

5、, All Rights Reserved.Installation Options1 NetBackup2 NetBackup Client Software3 NetBackup Client Java Softwareq To quit from this scriptChoose an option default: q: 1The NetBackup and Media Manager software is built for use on HP9000-800 hardware.Do you want to install NetBackup and Media Manager

6、files? (y/n) y yNetBackup is normally installed in /usr/openv/netbackup.Is it OK to install in /usr/openv/netbackup? (y/n) y yMedia Manager is normally installed in /usr/openv/volmgr.Is it OK to install in /usr/openv/volmgr? (y/n) y yThe HP9000-800 clients will be loaded.Do you want to load any othe

7、r NetBackup clients onto the server? (y/n) y nReading client binaries for /usr/openv/netbackup/client/HP9000-800x HP9000-800/HP-UX11.00/bp, bytes, 680 tape blocksx HP9000-800/HP-UX11.00/bpbackup, bytes, 928 tape blocks.x HP9000-800/HP-UX11.00/xbp, bytes, 936 tape blocksx HP9000-800/HP-UX11.00/XKeysy

8、mDB, 728 bytes, 2 tape blocksReading NetBackup files from /cdrom/hp-ux/anbx usr/openv/db/bin/nbdbd, bytes, 5984 tape blocksx usr/openv/db/etc/mysql/english/errmsg.sys, 10404 bytes, 21 tape blocksx usr/openv/man/man1m/vopie_util.1m, 11488 bytes, 23 tape blocksx usr/openv/man/man1m/vopied.1m, 8742 byt

9、es, 18 tape blocksReading NetBackup-Java GUI applications from /cdrom/NB-Java/The Java packages for installed client types will be loaded.cp NB-Java.install /usr/openv/NB-Java.installcp NB-Java.tar.Z /usr/openv/NB-Java.tar.Zcp HPUX_JRE.tar.Z /usr/openv/java/HPUX_JRE.tar.Zcp libSigScheduleJNI250.sl /

10、usr/openv/lib/server/hp_ux/libSigScheduleJNI250.slReading Media Manager files from /cdrom/hp-ux/anbx usr/openv/volmgr/bin/drive_mount_notify, 2871 bytes, 6 tape blocksx usr/openv/volmgr/bin/drive_unmount_notify, 2833 bytes, 6 tape blocks.x usr/openv/db/var/mysql/user.frm, 9148 bytes, 18 tape blocksx

11、 usr/openv/db/etc/f, 199 bytes, 1 tape blocksA NetBackup BusinesServer or DataCenter license key is needed for installation to continue.Enter license key:XXXX-XXXX-XXXX-XXXX-XXXX-XXXX-XXXX-XXX: NetBackup DataCenter Base product with the following features enabled: Core Frozen Image Services O

12、pen Transaction Manager has been registered.All additional keys should be added at this time.Do you want to add additional license keys now? (y/n) y nUse /usr/openv/netbackup/bin/admincmd/get_license_keyto add, delete or list license keys at a later time.Installing NetBackup DataCenter version: 4.5G

13、AIs saptest the master server? (y/n) y nWhat is the fully qualified name of the master server? sishu004 Linking /usr/lib/X11/app-defaults/XNB - /usr/openv/netbackup/bin/XNB.dtChecking for a bpcd entry in /etc/inetd.conf: Adding bpcd entry.Original /etc/inetd.conf saved as /etc/inetd.conf.NBU_.14:18:

14、00.Checking for a vnetd entry in /etc/inetd.conf: Adding vnetd entry.Checking for a vopied entry in /etc/inetd.conf: Adding vopied entry.Checking for a bpjava-msvc entry in /etc/inetd.conf: Adding bpjava-msvc entry.Checking /etc/services for the needed NetBackup and Media Manager services.Copying or

15、iginal /etc/services file to /etc/services.NBU_.14:20:33Editing /etc/services to update NetBackup and Media Manager services./etc/services will be updated to add the following entries for NetBackup/Media Manager.bprd 13720/tcp bprdbpcd 13782/tcp bpcdbpdbm 13721/tcp bpdbmvnetd 13724/tcp vnetdvopied 1

16、3783/tcp vopiedbpjobd 13723/tcp bpjobdnbdbd 13784/tcp nbdbdvisd 9284/tcp visdbpjava-msvc 13722/tcp bpjava-msvcvmd 13701/tcp vmdacsd 13702/tcp acsdtl8cd 13705/tcp tl8cdtldcd 13711/tcp tldcdts8d 13709/tcp ts8dodld 13706/tcp odldtl4d 13713/tcp tl4dtsdd 13714/tcp tsddtshd 13715/tcp tshdtlmd 13716/tcp tl

17、mdtlhcd 13717/tcp tlhcdlmfcd 13718/tcp lmfcdrsmd 13719/tcp rsmdTo change these entries modify the file /tmp/services.ov_edited.7090and enter when ready to continue:/etc/services has been updated to contain NetBackup and Media Manager services.WARNING: ypwhich: the NIS domain name hasnt been set on t

18、his machineWARNING: ypcat: the NIS domain name hasnt been set on this machineSending SIGHUP to inetd process.To make NetBackup and Media Manager startup automaticallywhen the system is restarted, the netbackup script found in/usr/openv/netbackup/bin/goodies/netbackup has been placed in /sbin/init.d

19、,with links to it placed in the /sbin/rc2.d directory.To make NetBackup and Media Manager shutdown automaticallywhen the system is restarted, the netbackup script found in/usr/openv/netbackup/bin/goodies/netbackup has been placed in /sbin/init.d ,with links to it placed in the /sbin/rc0.d directory.

20、Extracting NetBackup-Java product files.Installing NetBackup-Java, and the Java runtime environment for HP-UX B.11.00.Configuring NetBackup-Java runtime environment.The installation of the NetBackup-Java product on saptest is complete.Do you want to start the Media Manager device daemon processes? (

21、y/n) y yStarting the Media Manager device daemon processes.Done executing NB.instVERITAS Installation ScriptCopyright 1993 - 2002 VERITAS Software Corporation, All Rights Reserved.Installation Options1 NetBackup2 NetBackup Client Software3 NetBackup Client Java Softwareq To quit from this scriptChoo

22、se an option default: q: qA trace of the install can be found in /tmp/install_trace.4181That file can be deleted after you are sure the install was successful.2.1.2 添加其它的License注册号1，运行序列号添加工具# cd /usr/openv/netbackup/bin/admincmd# ./get_license_key2，根据提示，选择A来输入新的注册号需要添加SSO以及此Media Server上所运行的相应数据库Ag

23、ent的License注册号。如此Media Server上运行有SAP数据库，则需要添加SAP Agent的License注册号。2.1.3修改bp.conf参数文件# vi /usr/openv/netbackup/bp.conf文件内容如下：SERVER = sishu004SERVER = saptestCLIENT_NAME = saptestKNOWN_MASTER = sishu0042.2 载卸NetBackup Media Server1，停止所有Netbackup进程；# /usr/openv/netbackup/bin/goodies/bp.kill_all2，删除/us

24、r/openv下的全部内容；# rm rf /usr/openv3，从/etc/services文件中删除NetBackup/Media Manager的相关进程描述的语句行；# NetBackup Services #.# End NetBackup Services # Media Manager Services #.# End Media Manager Services #4，从/etc/inetd.conf文件中删除NetBackup/Media Manager的相关进程描述的语句行；删除bpcd、vnetd、vopied、bpjava-msvc。三、配置共享存储设备3.1在Med

25、ia Server上配置存储设备1，点击Master Server主管理界面左上角的图标，如下图所示；2，输入或选择要转向管理的Media Server的主机名，然后点击OK确认；3，下图所示的界面即为Media Server的管理界面，Media Server的功能较为简单，只有设备和介质管理这部分，选择右栏的Configure Storage Devices；4，出现设备配置向导，点击Next，下一步；5，选择需要扫描磁带设备的主机名，然后点击Next，下一步；6，开始扫描设备过程，成功后点击Next，下一步；7，预览已发现的磁带设备，如果无误则点击Next，下一步；8，选择需要配置的驱动

26、器，本项目中应选择后两个HP Ultrium驱动器，第一个驱动器HP C1537A是直接连接在小型机主机上的单磁带机，所以NetBackup无须对其进行配置，点击Next，下一步；9，提示确认，点击Continue，下一步；10，开始更新设备配置信息，完成后点击Next，下一步；11，点击Finish，完成磁带设备的添加过程；3.2配置共享驱动器1，在Master Server的管理界面中选择Media and Device Management，再点击Devices中的Hosts中的Media Server主机名，然后在右边会出现此Media Server所连接的磁带驱动器列表；2，用鼠标点

27、中要配置成共享驱动器的驱动器，然后点击鼠标右键，选择Configure Shared Drive；3，出现共享驱动器配置向导，选择第二项，配置当前所选择的驱动器为共享驱动器，点击Next，下一步；4，驱动器的属性信息不用修改，直接点击Next，下一步；5，选择共享此驱动器的主机名，打勾选中Show drive paths，显示设备路径，然后点击Next，下一步；6，保存设置，然后点击Finish，完成共享驱动器的配置。在Finish对话框中有两项打勾的选择项；第一个，在完成配置后是否要检查所有Master Server和Media Server之前是否存在设备冲突；第二个，在完成配置后是否要重

28、新启动Media Manager device daemon；默认两项均选。7，如果选择了设备冲突检查，则会出现如下设备配置分析向导，点击Next，下一步；8，选择连接设备的主机名，然后点击Next，下一步；9，经过检查后，显示检查结果，并点击Finish结束。3.3配置存储单元1，用鼠标右键点击NetBackup Management下的Storage Units，然后选择New Storage Unit来添加一个新的存储单元；2，在弹出的如下对话框中配置一个新的存储单元；在Storage unit name中输入新建存储单元的名称，如saptest-hcart-robot-tld-0；在M

29、edia Server中选择此存储单元输入哪个Media Server；在Robot type中选择机械手的类型，本项目中应选择TLD类型；在Drive density中选择使用的磁带类型，如果是LTO的磁带，应选择hcart；在Maximum concurrent drives中选择最大可用驱动器的数量；单击OK完成新存储单元的配置。四、安装及载卸SAP Agent4.1 安装SAP Agent将安装光盘放入CDROM中，并Mount CDROM；# cd /cdrom# ./installVERITAS Installation ScriptCopyright 1993 - 2002 VE

30、RITAS Software Corporation, All Rights Reserved.Installation Options1 NetBackup Add-On Product Software 2 NetBackup Database Agent Software q To quit from this scriptChoose an option default: q: 2*There are two ways to install database agent software.1. Remote Installation: Loads the software on a m

31、aster server with the intent of pushing database software out to affected clients.2. Local Installation: Loads and installs the software only to this local machine.*Do you want to do a local installation? (y/n) n y*NetBackup Database Agent InstallationChoose the Database Agents you wish to installon

32、e at a time or select Install All Database Agents. 1) NetBackup for DB2 2) NetBackup for Database Archiver 3) NetBackup for Informix 4) NetBackup for Lotus Notes 5) NetBackup for Oracle+ 6) NetBackup for SAP 7) NetBackup for Sybase 8) Install All Database Agents q) Done Selecting Agents x) Exit from

33、 this ScriptSelect the Oracle option if installing any of the following: Oracle, Oracle on UNIX Advanced BLI Agent or Oracle ServerFree Agent.Note: The Oracle on UNIX Advanced BLI Agent and Oracle ServerFree Agent features are available for HP9000-800 and Solaris platforms only.Choose an option: 6Ch

34、oose an option: qYou have chosen to install these Database Agents: NetBackup for SAPIs this list correct? (y/n) y y*Enter the license key for NetBackup for SAP or q to continue: You have entered an invalid key.Enter the license key for NetBackup for SAP or q to continue: XXXX-XXXX-XXXX-XXXX-XXXX-XXX

35、X-XXXX-XXXOf the agents selected, the following are supportedon this platform and will be installed: SAPLoading the Database Agent packages into the/usr/openv/netbackup/dbext directory and installing.* Installing NetBackup for SAP Installing NetBackup for SAP.Extracting files from /usr/openv/netback

36、up/dbext/SAP.hp11.00.tar.Z .x usr/openv/netbackup/dbext/SAP.hp11.00.version, 31 bytes, 1 tape blocksx usr/openv/netbackup/bin/backint, bytes, 1544 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/initSAP.sap, 6876 bytes, 14 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/initSAP.utl,

37、13822 bytes, 27 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/restore_filter, 934 bytes, 2 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/bplist_filter, 934 bytes, 2 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/sap_custom_sort_file, 1055 bytes, 3 tape blocksx usr/openv/

38、netbackup/ext/db_ext/sap/scripts/sap_offline_backup, 1136 bytes, 3 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/sap_online_backup, 1483 bytes, 3 tape blocksx usr/openv/netbackup/ext/db_ext/sap/scripts/sap_redo_log_backup, 1131 bytes, 3 tape blocksx usr/openv/lib/libsap.sl, bytes, 640 tape

39、 blocksNetBackup for SAP installation completed.*Execution of ./install_dbext is complete.Execution of ./install is complete.File /tmp/install_options_trace.17639 contains a trace of this install.VERITAS Installation ScriptCopyright 1993 - 2002 VERITAS Software Corporation, All Rights Reserved.Insta

40、llation Options1 NetBackup Add-On Product Software 2 NetBackup Database Agent Software q To quit from this scriptChoose an option default: q: qA trace of the install can be found in /tmp/install_options_trace.17639That file can be deleted after you are sure the install was successful.4.2 载卸SAP Agent

41、# cd /usr/openv/netbackup/ext/db_ext# rm rf sap直接删除SAP的安装目录即可。五、配置并创建SAP的备份策略注意：配置SAP的备份策略前，必须要将SAP设为自动归档模式。可能需要停机调整一次。5.1为backint文件创建NetBackup的链接1， 先备份原有SAP的backint文件；# mv /usr/sap/SID/SYS/exe/run/backint /usr/sap/SID/SYS/exe/run/backint.old2， 为SAP建立新的backint的链接# ln -s /usr/openv/netbackup/bin/back

42、int /usr/sap/SID/SYS/exe/run/backintNotes：如果此SAP数据库的SID为TST，则以上红色SID处应写为TST。5.2创建备份策略1，在NetBackup Master Server上，创建一个新的备份策略，如下图所示；2，输入新策略的名称后，按确定，会提示配置一个完整备份策略的第一部分Attributes；其中：策略类型Policy type选择SAP；在Policy storage unit中选择需使用的存储单元；在Policy volume pool中选择已分配用来备份SAP数据的volume pool；并打勾选中Limit jobs per po

43、licy，然后输入99，其它默认不变；3，点击转向Clients页面，如下图所示，点击New来添加一个客户端，输入客户端的名称，也就是需要备份的那台SAP服务器的主机名，选择好主机类型，然后点击OK按钮；4，点击Files页面，然后点击New，来添加需要调用的备份脚本，输入备份脚本的全路径和脚本的文件名，然后点击Add，如下图所示，注意备份脚本此时尚未创建，所以备份策略建立完毕后，需要创建备份脚本；5，检查此路径和文件名无误后，点击Schedules页面，然后点击New，来添加一个备份时间计划，如下图所示，在Name中输入新建备份时间计划的名称，如saptest_sap_full；在Reten

44、tion中选择备份内容的保存周期，在Frequency中设定备份作业的执行频率；转向页面Start Window中设定需要备份的时间段，如下图所示，完成后点击OK。如下图显示，在计划列表中已有一个Default的备份策略，此策略是SAP Agent的执行策略，不可以随意修改或删除；到此，备份策略已制定完毕；5.3创建备份脚本1， 创建备份脚本存放路径；此路径应和之前创建备份策略时写的备份脚本路径一致，例如之前建立备份策略的图例中显示的备份脚本的路径为/usr/openv/scripts，则需要建立的脚本路径为/usr/openv/scripts。2，复制脚本模板；SAP Agent安装完成后，

45、备份的脚本模板会放在/usr/openv/netbackup/ext/db_ext/sap/scripts下，复制其中的两个脚本sap_online_backup和sap_offline_backup到新建的脚本目录下。如新建脚本存放路径为/usr/openv/scripts然后执行以下步骤：# cd /usr/openv/netbackup/ext/db_ext/sap/scripts# cp sap_online_backup /usr/openv/scripts# cp sap_offline_backup /usr/openv/scripts# chmod 777 sap_online

46、_backup# chmod 777 sap_offline_backup3，修改备份脚本；修改CMD_LINE=一行为如下：CMD_LINE=$CMD_LINE brbackup -u system/manager -c -d util_file -t online其中-u表示备份使用的用户和密码，-d表示备份使用的设备类型，即backup_dev_type，-t表示备份的类型，online或是offline；如果需要备份归档日志，则也需要修改CMD_LINE=一行为如下：CMD_LINE=$CMD_LINE brarchive -u system/system -c -d util_fil

47、e -sd其中-u表示备份使用的用户和密码，-d表示备份使用的设备类型，即backup_dev_type，-sd表示备份完成后保存并删除归档日志；注意修改如下行的红色部分，此处应写为sap用户；su - oratst -c $CMD_LINE5.4配置备份参数文件initSID.utl假设所备份的SAP数据库的SID为TST，$ORACLE_HOME=/oracle/TST，则# cd /usr/openv/netbackup/ext/db_ext/sap/scripts# cp initSAP.utl /oracle/TST/dbs# cp initSAP.utl initTST.utl如果

48、此目录下已经存在同名文件，则将原同名文件改名另存，然后在复制。修改如下语句，红色为修改后的语句；#switch_list /oracle/SAP/sapbackup/.switch.lisswitch_list /oracle/TST/sapbackup/.switch.lis#switch_sem /oracle/SAP/sapbackup/.switch.semswitch_sem /oracle/TST/sapbackup/.switch.sem#switch_log /oracle/SAP/sapbackup/.switch.logswitch_log /oracle/TST/sapb

49、ackup/.switch.log#server jupiterserver sishu004 此处设定备份服务器的名称#client jupiterclient saptest 此处设定所要备份SAP数据库服务器的主机名#drives 1drives 1 此处可设定备份时需要使用的驱动器数目#policy sap_backuppolicy saptest_sap_backup 此处设定已建好的备份策略的名称保存已修改的内容，并退出编辑器。# chown oratst:dba initTST.utl# chmod 755 initTST.utl5.5配置备份参数文件initSID.sap假设所

50、备份的SAP数据库的SID为TST，$ORACLE_HOME=/oracle/TST，则# cd /usr/openv/netbackup/ext/db_ext/sap/scripts# cp initSAP.sap /oracle/TST/dbs# cp initSAP.sap initTST.sap如果此目录下已经存在同名文件，则将原同名文件改名另存，然后在复制。修改如下语句，红色为修改后的语句；#backup_dev_type = tapebackup_dev_type = util_file此项必须设为util_filebackup_mode = all 如果是备份整个数据库，则将此句

51、的注释号#去掉#backup_mode = (PSAPUSER1D) 如果是备份一个或多个表空间，则将此句的注释号#去掉，并在括号中写入需要备份的表空间的名称，以逗号隔开。此两句只能选其一。#backup_type = offline如果备份使用的是offline的备份，则将此句的注释号#去掉backup_type = online如果备份使用的是online的备份，则将此句的注释号#去掉此两句只能选其一。backup_root_dir = /oracle/TST/sapbackup将此路径写为$ORACLE_HOME的实际路径compress = no此行选择不压缩# util_par_file = ?/dbs/init.utlutil_par_file = /oracle/TST/dbs/initTST.utl此句表明参数文件initTST.utl的位置，需写实地址。保存已修改的内容，并退出编辑器。# chown oratst:dba initTST.sap# chmod 755 initTST.sap到此备份SAP的策略设置完毕。5.6手工执行备份策略1， 如果需要临时手工发起备份作业，打开NetBackup Administration Concole，在策略中点击需要执行的Policy Name，此方法可以检测备份策