netbackup配置维护手册.docx

目 录1. 整体备份环境描述21.1 备份主机概要21.2备份系统架构图22 . NetBackup Media server的安装33. 备份客户端的安装：44. Oracle agent安装及配置55. 备份策略设置135.4 AOADB1 ORACLE数据库备份135.7 OA系统solaris系统备份145.8 Aoadb1 oracle controlfile备份166. 现有磁带信息177. 常用netbackup命令181. 整体备份环境描述1.1 备份主机概要由abackup(windows 2000 Server)作为备份服务器，负责备份管理，相关配置如下表示：主机名操作系统IP地址备份类型数据库abackup(master server)Windows aoadb1(media server)Solaris 90系统备份Oracle数据库BMR clientaoaacd1Solaris 93文件备份BMR main serveraoatrs1Solaris 96系统备份BMR clientaoaweb1Solaris 90系统备份BMR clientamail1Solaris 9系统备份BMR client/mss/maildata1.2备份系统架构图备份系统架构图如下示：2 . NetBackup Media server的安装在aoadb1服务器中安装Netbackup media server软件：a. 修改/etc/hosts文件增加如下：0aoadbabackupak3dbak3db3aoaacd6aoatrs0aoaweb33amail1b. 在服务器中安装备份NetBackup client软件: # ./installVERITAS Installation ScriptCopyright 1993 - 2003 VERITAS Software Corporation, All Rights Reserved. Installation Options 1 NetBackup 2 NetBackup Client Software 3 NetBackup Client Java Software q To quit from this scriptChoose an option default: q: 1NetBackup installs to the running root environment, by default.Are you installing to the running root environment? y,n (y) Processing package instance from 按提示完成安装。c. NetBackup配置文件/usr/openv/netbackup/bp.conf:SERVER = abackupSERVER = aoadb1SERVER = ak3db1SERVER = ak3db23. 备份客户端的安装：在下列服务器安装Netbackup客户端软件：3aoaacd6aoatrs0aoaweb33amail1a.修改/etc/hosts文件增加如下：0aoadbabackupak3dbak3db3aoaacd6aoatrs0aoaweb33amail1b.在服务器中安装备份NetBackup client软件: # ./installVERITAS Installation ScriptCopyright 1993 - 2003 VERITAS Software Corporation, All Rights Reserved. Installation Options 1 NetBackup 2 NetBackup Client Software 3 NetBackup Client Java Software q To quit from this scriptChoose an option default: q: 2NetBackup installs to the running root environment, by default.Are you installing to the running root environment? y,n (y) Processing package instance from 按提示完成安装。c.NetBackup配置文件/usr/openv/netbackup/bp.conf:SERVER = abackupSERVER = ak3db1SERVER = ak3db2CLIENT_NAME = amail1 (or aoaacd1,aoatrs1,aoaweb1)4. Oracle agent安装及配置a. 在aoadb1服务器中安装备份NetBackup oracle agent软件:#./instllb. 确认oracle已处于归档模式：$sqlplus /nologSQLconnect / as sysdbaSQLarchive log list;c. 作RMAN接口库文件/oracle/product/9.2.0/lib/libobk.a连接：执行/usr/openv/netbackup/bin/oracle_link/oracle/product/9.2.0/lib/libobk.a -/usr/openv/netbackup/bin/libobk.a64d. 修改oracle备份脚本/usr/openv/scripts/hot_database_backup.sh：#!/bin/sh# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $#bcpyrght#*#* $VRTScprght: Copyright 1993 - 2003 VERITAS Software 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=/u0/oracle/app/oracle/product/9iexport ORACLE_HOME# -# Replace ora81, below, with the Oracle SID of the target database.# -ORACLE_SID=hkoaexport 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=sys/manager # -# 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 occurs# automatically as the result of backing up the system file is# not sufficient; it will not contain records for the backup that# is currently in progress.# o you want to archive the current log, back up all the# archive logs using two channels, putting a maximum of 20 logs# in a backup set, and deleting them once the backup is complete.# Note that the format string is constructed to guarantee uniqueness and# to enhance NetBackup for Oracle backup and restore performance.# NOTE WHEN USING TNS ALIAS: When connecting to a database# using a TNS alias, you must use a send command or a parms operand to # specify environment variables. In other words, when accessing a database# through a listener, the environment variables set at the system level are not # visible when RMAN is running. For more information on the environment# variables, please refer to the NetBackup for Oracle Admin. Guide.# -CMD_STR=ORACLE_HOME=$ORACLE_HOMEexport ORACLE_HOMEORACLE_SID=$ORACLE_SIDexport ORACLE_SID$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append $RMAN_LOG_FILE RSTAT=$?else /usr/bin/sh -c $CMD_STR $RMAN_LOG_FILE RSTAT=$?fi # -# Log the completion of this script.# - if $RSTAT = 0 then LOGMSG=ended successfullyelse LOGMSG=ended in errorfi echo $RMAN_LOG_FILEecho Script $0 $RMAN_LOG_FILEecho = $LOGMSG on date = $RMAN_LOG_FILEecho $RMAN_LOG_FILE/usr/openv/netbackup/bin/bpbackup -p oracle_controlfile /usr/openv/oraclectl exit $RSTAT5. 备份策略设置5.1 AOADB1 ORACLE数据库备份-Policy Name: AOADB1_ORACLE Policy Type: Oracle Active: yes Effective date: 04/27/2005 13:28:06 Block Incremental: no Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: 0 Max Jobs/Policy: Unlimited Disaster Recovery: 0 Residence: aoadb1-hcart-robot-tld-0 Volume Pool: OA_oracle Keyword: (none specified) HW/OS/Client: Solaris Solaris9 aoadb1 Include: /usr/openv/scripts/hot_database_backup.sh Schedule: Default-Application-Backup Type: Application Backup Maximum MPX: 1 Synthetic: 0 PFI Recovery: 0 Retention Level: 3 (1 month) Number Copies: 1 Fail on Error: 0 Residence: (specific storage unit not required) Volume Pool: (same as policy volume pool) Daily Windows: Sunday 00:00:00 - Saturday 23:59:59 Schedule: full Type: Automatic Full Backup Frequency: every 7 days Maximum MPX: 1 Synthetic: 0 PFI Recovery: 0 Retention Level: 3 (1 month) Number Copies: 1 Fail on Error: 0 Residence: (specific storage unit not required) Volume Pool: (same as policy volume pool) Daily Windows: Sunday 08:00:00 - Sunday 24:00:00 Schedule: inc_oracle Type: Cumulative Incremental Backup Frequency: every 1 day Maximum MPX: 1 Synthetic: 0 PFI Recovery: 0 Retention Level: 3 (1 month) Number Copies: 1 Fail on Error: 0 Residence: (specific storage unit not required) Volume Pool: (same as policy volume pool) Daily Windows: Sunday 02:10:00 - Sunday 08:00:00 Monday 02:10:00 - Monday 08:00:00 Tuesday 02:10:00 - Tuesday 08:00:00 Wednesday 02:10:00 - Wednesday 08:00:00 Thursday 02:10:00 - Thursday 08:00:00 Friday 02:10:00 - Friday 08:00:005.2 OA系统solaris系统备份-Policy Name: OAsolaris Policy Type: Standard Active: yes Effective date: 04/27/2005 13:28:06 Client Compress: no Follow NFS Mounts: no Cross Mount Points: yes Collect TIR info: yes, with move detection Block Incremental: no Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: 0 Max Jobs/Policy: Unlimited Disaster Recovery: 0 Residence: FILE Volume Pool: SunOA Keyword: (none specif