NBU备份恢复文档.doc

SymantecNetbackup备份恢复文档目录第一章备份系统的安装要求41.1Windows系统要求41.2磁盘空间要求41.3备份前准备4第二章NetBackup软件的安装与卸除42.1NetBackup Master Server（Windows2003）的安装与卸除42.1.1在Windows2003安装NetBackup Master Server42.1.2在Windows2003上载卸NetBackup Server122.1.3关于补丁包的升级122.1.4带库驱动的安装122.2UNIX环境下的安装132.2.1.在UNIX上安装MEDIA SERVER13第三章NetBackup的备份与恢复173.1配置存储设备173.1.1存储设备配置在本地硬盘上173.1.2存储设备配置到磁带库193.2File的备份与恢复223.2.1创建备份策略223.2.2File的恢复操作253.3Oracle数据库的备份与恢复263.3.1Oracle数据库备份263.3.1.1修改Oracle数据库为日志归档模式263.3.1.2创建备份脚本263.3.1.3创建备份策略363.3.1.4Oracle的恢复操作423.4SQL备份与还原443.4.1首次启动 NetBackup MS SQL 客户机443.4.2选择 SQL 主机和实例443.4.3备份数据库453.4.4数据库的恢复473.5LOTUS备份与还原493.5.1从 NetBackup 管理控制台定义 Lotus Notes 客户机的属性493.5.2在 bp.conf 文件中定义 Lotus Notes 客户机的属性513.5.3定义备份策略513.5.4执行还原523.6DB2 的备份与恢复533.6.1安装DB2 Agent（UNIX平台）533.6.2载卸DB2 Agent583.6.3修改DB2 数据库参数593.6.3.1设定DB2 路径593.6.3.2创建DB2 备份脚本603.6.3.3创建DB2 备份策略643.6.3.4DB2 的恢复操作673.7Exchange的备份与恢复693.7.1Exchange Agent的安装693.7.2Exchange 数据库的备份配置703.7.2.1Exchange 服务器端的设置703.7.2.2NBU Master Server端的设置703.7.2.3Exchange 备份策略的制定713.7.3Exchange 的恢复操作753.8Sybase的备份与恢复783.8.1安装Sybase Agent（UNIX平台）783.8.2载卸Sybase Agent833.8.3Sybase备份833.8.3.1修改Sybase数据库参数833.8.3.2复制Sybase数据库备份的lib文件843.8.3.3修改Sybase备份脚本843.8.3.4创建Sybase备份策略84第一章 备份系统的安装要求1.1 Windows系统要求有固定的IP地址，且网络畅通，有要求安装sp2或更高。1.2 磁盘空间要求1，在Master Server上建议单独配置20GB的磁盘空间；2，在Media Server上建议配置500M磁盘空间；3、在Client上建议配置500MB的剩余磁盘空间。1.3 备份前准备在MASTERSERVER以及CLIENT的C:WindowsSystem32driversetchosts文件里添加彼此的主机名以及IP地址，在DOS下PING互相的主机名确保网络通常。（如果接了磁带库，就应该在MASTER SERVER中装上SYMANTEC的驱动。这个在装完NBU后再进行安装。）第二章 NetBackup软件的安装与卸除122.1 NetBackup Master Server（Windows2003）的安装与卸除2.1.1 在Windows2003安装NetBackup Master Server1，首先确认一下所要安装的系统环境，Win2003要求SP2或更高；2，将VERITAS NetBackup for Windows的安装CD放入CDROM，光盘会自动运行，如果没有运行，可以手工运行CD根目录下的Launch.exe命令，如下图所示；3，在左栏NetBackup中选择NetBackup，在右边选择NetBackup Installation，会出现下图；4，点击Install Server Software，安装程序会先检查一下系统的环境是否符合安装要求，然后出现如下图所示的安装开始画面；5，点击next，继续；6，点击next继续，选择接受协议，再后点击next，出现如下对话框；7，选择仅安装本机，选择Trypical安装，点击next继续；8，输入序列号，并点击安装NetBackup Master Server图标；9，点击next继续，出现如下对话框，注意图中的主机名并不是本项目中的Master Server主机名；本项目实际为veritas-backup10，点击next继续，输入EMM Server名；同样为veritas-backup11，选择install安装完成；12，选择Finish安装完成。2.1.2 在Windows2003上载卸NetBackup Server1，在控制面板中打开Add/Remove Programs，选择VERITAS NetBackup，如下图所示；2，选择删除NetBackup，完成后即可，载卸过程无需重启服务器。2.1.3 关于补丁包的升级补丁包的升级与软件安装类似2.1.4 带库驱动的安装运行NetBackup Tape Device Drivers122.12.2 UNIX环境下的安装1.2.2.1.2.2.1.2.2.1.2.2.2.2.1. 在UNIX上安装MEDIA SERVER1 、放入光盘2、加载光盘mount rv cdrfs /dev/cd0 /mnt3 、安装过程如下Symantec Installation ScriptCopyright 1993 - 2007 Symantec Corporation, All Rights Reserved.Installing NetBackup Server Software NOTE: To install only NetBackup Client software locally on this machine or to load additional UNIX client software on this server, insert the NetBackup UNIX Clients cdrom.Do you wish to continue? y,n (y) y输入Y确认The NetBackup and Media Manager software is built for use on RS6000 hardware.Do you want to install NetBackup and Media Manager files? y,n (y) yNetBackup and Media Manager are normally installed in /usr/openv.Is it OK to install in /usr/openv? y,n (y) y输入Y确认安装目录,然后开始安装Reading NetBackup files from /mnt/rs6000/anbx usr/openv/NB-Java.tar.Z, 95360520 bytes, 186252 media blocks.x usr/openv/db/binx usr/openv/db/bin/create_nbdb, 14624332 bytes, 28564 media blocks.x usr/openv/db/bin/nbdb_admin, 14606276 bytes, 28528 media blocks.x usr/openv/db/bin/nbdb_backup, 14580653 bytes, 28478 media blocks.。安装完成后需要配置。会询问以下几个问题A NetBackup Server or Enterprise Server license key is neededfor installation to continue.Enter license key: Evaluation NetBackup Enterprise Server with Dec 31, 2008 expiration date will be registered.Is this OK? y,n (y) 输入LICENSEOENN-JTK4-HGGN-6PRO-63CU-8LGK-HM77-9HHP-PP36: Evaluation NetBackup Enterprise Server Base product with the following features enabled: PureDisk Remote Office PureDisk Option SAN Client PureDisk MS Exchange Agent PureDisk MS SQL Server Agent Flexible Disk Option OpenStorage Disk Option NAS SnapVault Option Virtual Tape Option Bare Metal Restore Encryption Open File Backup Remote Client Support Robotic Library Sharing Support Remote Media Server Support Microsoft RSM Robotic Libraries ADIC DAS/SDLC Robotic Libraries IBM ATL Robotic Libraries Fujitsu LMF Robotic Libraries StorageTek ACS Robotic Libraries Snapshot Client MS SharePoint Agent Inline Tape Copy Vault GDM Managed Server Library Based Tape Drives Additional Drives/Robotics DataStore Encryption (Legacy DES 56-bit) Encryption (Legacy DES 40-bit) SAP extension SQL-Backtrack extension Sybase extension Informix extension Oracle extension Lotus Notes extension DB2 extension MS SQL Server extension MS Exchange extension Advanced Reporting Option Shared Storage Option Global Data Manager NDMP EMC Additional clientshas been registered.配置MEDIA SERVER的相关信息如下Would you like to use fmsvr as the configuredname of the NetBackup server? y,n (y) nEnter the name of the NetBackup server: fmsvr_svcIs fmsvr_svc the master server? y,n (y) nWhat is the fully qualified name of the master server? veritas-backupChecking /etc/services for the needed NetBackup and Media Manager services.Found the necessary NetBackup services in /etc/services.Checking for a bpcd entry in /etc/inetd.conf: Found.Checking for a vnetd entry in /etc/inetd.conf: Found.Checking for a vopied entry in /etc/inetd.conf: Found.Checking for a bpjava-msvc entry in /etc/inetd.conf: Found.Sending SIGHUP to inetd process.在AIX上安装了MEDIA SERVER的软件包后，需要在备份服务器上做相关配置，如下：首先在主机属性打开备份服务器，在SERVER一项加入相关的MEDIA SERVER然后再重启服务，重新配置STU的向导，相关配置在后面章节中会提到.第三章 NetBackup的备份与恢复1.2.3.33.1 配置存储设备33.13.1.1 存储设备配置在本地硬盘上1，在备份服务器(Fawdeintralink)上，由开始-程序-Veritas NetBackup菜单中选择Netbackup Administrator Console，启动管理员控制台。2，点击Storage，选中“Storage Units”点击右键，选择New Storage Unit，如下图；（在本地硬盘中建立个存储池）3，电击OK，Storage Unit创建完成，如下图所示3.1.2 存储设备配置到磁带库1，在右边的配置向导中选择Configure Storage Devices，如下图；2，点击Next；3.选上需要配置成MEDIA SERVER的机器，然后下一步4.系统会自动扫描链接在服务器上的备份设备，如果正确，那么下一步就可以完成配置。3.2 File的备份与恢复3.23.2.1 创建备份策略1，点击Policies，选中“Summary of all Policies”点击右键，选择“New Policy”2，输入Policy Name，确认后进入如下界面；在Policy type中选择MS-Windwos-NT；在Policy storage unit中选择test；把“Collect disaster recovery information for Bare Metal Restord”前面的勾去掉；3，点击“Schedules”，并且选择“New Schedules”，进入以下界面；在Name中输入一个备份计划的名称；在Type of backup中选择备份的策略类型，如果是完全备份就选择Full Backup，增量备份就选择Cumulative-Incremental Backup，差别备份就选择Differential-Incremental Backup；在Retention中选择备份内容的保存周期，此测试中为2 Weeks；在Frequency中选择备份的间隔频率，此测试中建议设为1 days；在Start Windows中设置备份的运行时间，如下图所示；点击OK后，一个完整的备份策略就建立完毕了。3.2.2 File的恢复操作1，点击Backup，Archive，and Restore，并选择Restore Files页面；2，选择上需要恢复的内容，并且点击“恢复”按钮，如下图；选择恢复类型，Overwrite existiong files覆盖存在文件，Restore the file using a temporary filename使用临时文件文，Do not restore the file 不覆盖存在文件。然后点击“Start Restore”。恢复完成。3.3 Oracle数据库的备份与恢复1233.13.23.33.3.1 Oracle数据库备份1233.13.23.33.3.13.3.1.1 修改Oracle数据库为日志归档模式由于这个属于ORACLE数据库的范畴,所以不详细说明.3.3.1.2 创建备份脚本1，在安装ORACLE AGENT的时候,Oracle 备份脚本的样本会自动生成，脚本内容如下：（红色部分是需要修改的）#!/bin/sh# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $#bcpyrght#*#* $VRTScprght: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $ *#*#ecpyrght# -# hot_database_backup.sh# -# This script uses Recovery Manager to take a hot (inconsistent) database# backup. A hot backup is inconsistent because portions of the database are# being modified and written to the disk while the backup is progressing.# You must run your database in ARCHIVELOG mode to make hot backups. It is# assumed that this script will be executed by user root. In order for RMAN# to work properly we switch user (su -) to the oracle dba account before# execution. If this script runs under a user account that has Oracle dba# privilege, it will be executed using this users account.# -# -# Determine the user which is executing this script.# - CUSER=id |cut -d( -f2 | cut -d ) -f1 # -# Put output in .out. Change as desired.# Note: output directory requires write permission.# -RMAN_LOG_FILE=$0.out# -# You may want to delete the output file so that backup information does# not accumulate. If not, delete the following lines.# -if -f $RMAN_LOG_FILE thenrm -f $RMAN_LOG_FILEfi# -# Initialize the log file.# - echo $RMAN_LOG_FILEchmod 666 $RMAN_LOG_FILE # -# Log the start of this script.# - echo Script $0 $RMAN_LOG_FILEecho = started on date = $RMAN_LOG_FILEecho $RMAN_LOG_FILE # -# Replace /db/oracle/product/ora81, below, with the Oracle home path.# -ORACLE_HOME=/local/oracle/product/10.2.0.4export ORACLE_HOME# -# Replace ora81, below, with the Oracle SID of the target database.# -ORACLE_SID=fmpdbexport ORACLE_SID# -# Replace ora81, below, with the Oracle DBA user id (account).# -ORACLE_USER=oracle# -# Set the target connect string.# Replace sys/manager, below, with the target connect string.# -TARGET_CONNECT_STR=/ # -# Set the Oracle Recovery Manager name.# -RMAN=$ORACLE_HOME/bin/rman# -# Print out the value of the variables set by this script.# -echo $RMAN_LOG_FILEecho RMAN: $RMAN $RMAN_LOG_FILEecho ORACLE_SID: $ORACLE_SID $RMAN_LOG_FILEecho ORACLE_USER: $ORACLE_USER $RMAN_LOG_FILEecho ORACLE_HOME: $ORACLE_HOME $RMAN_LOG_FILE# -# Print out the value of the variables set by bphdb.# -echo $RMAN_LOG_FILEecho NB_ORA_FULL: $NB_ORA_FULL $RMAN_LOG_FILEecho NB_ORA_INCR: $NB_ORA_INCR $RMAN_LOG_FILEecho NB_ORA_CINC: $NB_ORA_CINC $RMAN_LOG_FILEecho NB_ORA_SERV: $NB_ORA_SERV $RMAN_LOG_FILEecho NB_ORA_POLICY: $NB_ORA_POLICY $RMAN_LOG_FILE# -# NOTE: This script assumes that the database is properly opened. If desired,# this would be the place to verify that.# -echo $RMAN_LOG_FILE# -# If this script is executed from a NetBackup schedule, NetBackup# sets an NB_ORA environment variable based on the schedule type.# The NB_ORA variable is then used to dynamically set BACKUP_TYPE# For example, when:# schedule type is BACKUP_TYPE is# - -# Automatic Full INCREMENTAL LEVEL=0# Automatic Differential Incremental INCREMENTAL LEVEL=1# Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE# # For user initiated backups, BACKUP_TYPE defaults to incremental# level 0 (full). To change the default for a user initiated# backup to incremental or incremental cumulative, uncomment# one of the following two lines.# BACKUP_TYPE=INCREMENTAL LEVEL=1# BACKUP_TYPE=INCREMENTAL LEVEL=1 CUMULATIVE# # Note that we use incremental level 0 to specify full backups.# That is because, although they are identical in content, only# the incremental level 0 backup can have incremental backups of# level 0 applied to it.# - if $NB_ORA_FULL = 1 then echo Full backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=0 elif $NB_ORA_INCR = 1 then echo Differential incremental backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=1 elif $NB_ORA_CINC = 1 then echo Cumulative incremental backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=1 CUMULATIVE elif $BACKUP_TYPE = then echo Default - Full backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREMENTAL LEVEL=0fi# -# Call Recovery Manager to initiate the backup. This example does not use a# Recovery Catalog. If you choose to use one, replace the option nocatalog# from the rman command line below with the # rcvcat / statement.# Note: Any environment variables needed at run time by RMAN # must be set and exported within the switch user (su) command.# -# Backs up the whole database. This backup is part of the incremental# strategy (this means it can have incremental backups of levels 0# applied to it).# We do not need to explicitly request the control file to be included# in this backup, as it is automatically included each time file 1 of# the system tablespace is backed up (the inference: as it is a whole# database backup, file 1 of the system tablespace will be backed up,# hence the controlfile will also be included automatically).# Typically, a level 0 backup would be done at least once a week.# The scenario assumes:# o you are backing your database up to two tape drives# o you want each backup set to include a maximum of 5 files# o you wish to include offline datafiles, and read-only tablespaces,# in the backup# o you want the backup to continue if any files are inaccessible.# o you are not using a Recovery Catalog# o you are explicitly backing up the control file. Since you are# specifying nocatalog, the controlfile backup that occu