NBU70OracleforAIX安装配置手册.docx

NBU7.0 Oracle for AIX安装配置手册浙江星汉信息技术有限公司目 录一、NBU 7.0 AIX客户端安装配置3二、NBU 7.0 AIX客户端脚本配置8三、NBU 7.0 Catalog目录库备份设置17四、NBU 7.0 oracle for aix备份作业设置22一、NBU 7.0 AIX客户端安装配置1、先设置客户端的hosts文件，包括备份服务器的hosts也要对应双向解析。#rootp550b:/#more /etc/hosts127.0.0.1 loopback localhost # loopback (lo0) name/address10.10.10.1 p550a_boot1 p550a20.20.20.1 p550a_boot2172.16.1.7 p550a_per10.10.10.2 p550b_boot1 p550b20.20.20.2 p550b_boot2172.16.1.8 p550b_per172.16.1.9 ora_svr=NBU backup server=172.16.1.242 hpdl380-backup 2、#放入NBU 7.0 For AIX光盘，在系统挂载安装盘rootp550a:/dev#mount -v cdrfs -o ro /dev/cd0 /mnt 3、执行安装，并选择2客户端安装，提示选择Y继续 rootp550a:/mnt#./install然后根据提示输入备份服务器的名称hpdl380-backup（一定要为备份服务器名，不建议用IP）, 提示选择Y继续选择后则开始安装软件如下：安装结束后选择3退出4、修改客户端NBU配置参数rootp550b:/usr/openv/netbackup#vi bp.conf修改双机HACMP系统一台P550的/usr/openv/netbackup/bp.conf配置文件信息SERVER = hpdl380-backupCLIENT_NAME = p550a改为SERVER = hpdl380-backupCLIENT_NAME = ora_svrREQUIRED_INTERFACE = ora_svr5、修改客户端oracle数据库为归档模式rootp550b:/usr/openv/netbackup#su - oracleoraclep550b:/home/oracle$sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 25 15:48:48 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /oracle/product/10.2.0/dbs/archOldest online log sequence 255Next log sequence to archive 257Current log sequence 257SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mount; ORACLE instance started.Total System Global Area 1610612736 bytesFixed Size 2084400 bytesVariable Size 436208080 bytesDatabase Buffers 1157627904 bytesRedo Buffers 14692352 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter system set log_archive_dest_1='location=/archlog' scope=spfile;System altered.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1610612736 bytesFixed Size 2084400 bytesVariable Size 436208080 bytesDatabase Buffers 1157627904 bytesRedo Buffers 14692352 bytesDatabase mounted.Database opened.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /archlogOldest online log sequence 255Next log sequence to archive 257Current log sequence 257SQL> create pfile from spfile;File created.至此oracle数据库归档开启完成；6、oracle用户执行备份软件NBU和oracle数据库连接库程序oracle_linkrootp550b:/#su - oracleoraclep550b:/home/oracle$cd /usr/openv/netbackup/binoraclep550b:/usr/openv/netbackup/bin$./oracle_link提示选择Y继续至此NBU的oracle数据库客户端安装完成；二、NBU 7.0 AIX客户端脚本配置1、 先创建相关目录和文件rootp550b:/#cd /usr/openvrootp550b:/usr/openv#mkdir controlfilerootp550b:/usr/openv#mkdir orascriptsrootp550b:/usr/openv#cd controlfilerootp550b:/usr/openv/controlfile#touch control.orarootp550b:/usr/openv/controlfile#cd .rootp550b:/usr/openv#cd orascriptsrootp550b:/usr/openv/orascripts#touch aix_ora_full.sh2、 相关目录和文件赋予属主和权限rootp550b:/usr/openv/orascripts#cd .rootp550b:/usr/openv#ls -ltotal 72drwxr-xr-x 2 root system 256 Feb 25 16:03 controlfiledrwxr-xr-x 5 root bin 4096 Feb 25 15:40 javadrwxr-xr-x 7 root bin 8192 Feb 25 15:37 libdrwxr-xr-x 5 root system 256 Feb 25 15:40 logsdrwxr-xr-x 2 root bin 256 Jan 05 2010 msgdrwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackupdrwxr-xr-x 2 root system 256 Feb 25 16:04 orascripts-r-r-r- 1 root bin 5435 Feb 25 15:40 regid.1992-.symantec,Enterprise_netbackup-7.0.0.0_1.swidtagdrwxr-xr-x 2 root bin 4096 Jan 05 2010 resourcesdrwxr-xr-x 2 root bin 256 Jan 05 2010 share-r-r-r- 1 root bin 5435 Jan 05 2010 swidtag.xmldrwxr-xr-x 2 root bin 256 Feb 25 15:43 tmpdrwxr-xr-x 5 root bin 256 Feb 25 15:37 varrootp550b:/usr/openv#chown -R oracle:dba controlfilerootp550b:/usr/openv#chmod -R 777 controlfilerootp550b:/usr/openv#chown -R oracle:dba orascriptsrootp550b:/usr/openv#chmod -R 777 orascriptsrootp550b:/usr/openv#ls -ltotal 72drwxrwxrwx 2 oracle dba 256 Feb 25 16:03 controlfiledrwxr-xr-x 5 root bin 4096 Feb 25 15:40 javadrwxr-xr-x 7 root bin 8192 Feb 25 15:37 libdrwxr-xr-x 5 root system 256 Feb 25 15:40 logsdrwxr-xr-x 2 root bin 256 Jan 05 2010 msgdrwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackupdrwxrwxrwx 2 oracle dba 256 Feb 25 16:04 orascripts-r-r-r- 1 root bin 5435 Feb 25 15:40 regid.1992-.symantec,Enterprise_netbackup-7.0.0.0_1.swidtagdrwxr-xr-x 2 root bin 4096 Jan 05 2010 resourcesdrwxr-xr-x 2 root bin 256 Jan 05 2010 share-r-r-r- 1 root bin 5435 Jan 05 2010 swidtag.xmldrwxr-xr-x 2 root bin 256 Feb 25 15:43 tmpdrwxr-xr-x 5 root bin 256 Feb 25 15:37 var3、 编辑NBU备份数据库的Rman脚本aix_ora_full.shrootp550b:/usr/openv/orascripts#vi aix_ora_full.sh粘贴如下内容（完全备份oracle数据库和归档日志，并删除备份好的归档日志，注意修改实例名oracle_sid和oracle_home和实际环境一致）=#!/bin/sh# $Header: hot_database_backup.sh,v 1.9 2002/02/06 16:48:56 lstrub Stab $#bcpyrght#*#* $VRTScprght: Copyright 1993 - 2002 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 user's account.# -# -# Determine the user which is executing this script.# - CUSER=id |cut -d"(" -f2 | cut -d ")" -f1 # -# Put output in <this file name>.out. Change as desired.# Note: output directory requires write permission.# -RMAN_LOG_FILE=$0.date +%Y%m%d%H%M%S.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" then rm -f "$RMAN_LOG_FILE"fi# -# 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=/oracle/product/10.2.0export ORACLE_HOME# -# Replace ora81, below, with the Oracle SID of the target database.# -ORACLE_SID=orclywexport 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=0"fi# -# 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 <userid>/<passwd><tns alias>' 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