安装配置手册模板.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也要对应双向解析。
#[root@p550b:/]#more /etc/hosts
127.0.0.1 loopback localhost # loopback (lo0) name/address
10.10.10.1 p550a_boot1 p550a
20.20.20.1 p550a_boot2
172.16.1.7 p550a_per

10.10.10.2 p550b_boot1 p550b
20.20.20.2 p550b_boot2
172.16.1.8 p550b_per

172.16.1.9 ora_svr
=====NBU backup server=====
172.16.1.242 hpdl380-backup

2、#放入NBU 7.0 For AIX光盘，在系统挂载安装盘
[root@p550a:/dev]#mount -v cdrfs -o ro /dev/cd0 /mnt

3、实施安装，并选择2用户端安装，提醒选择Y继续
[root@p550a:/mnt]#./install

然后依据提醒输入备份服务器名称hpdl380-backup（一定要为备份服务器名，不提议用IP）, 提醒选择Y继续

选择后则开始安装软件以下：

安装结束后选择3退出

4、修改用户端NBU配置参数
[root@p550b:/usr/openv/netbackup]#vi bp.conf

修改双机HACMP系统一台P550/usr/openv/netbackup/bp.conf配置文件信息
SERVER = hpdl380-backup
CLIENT_NAME = p550a
改为
SERVER = hpdl380-backup
CLIENT_NAME = ora_svr
REQUIRED_INTERFACE = ora_svr

5、修改用户端oracle数据库为归档模式
[root@p550b:/usr/openv/netbackup]#su - oracle
[oracle@p550b:/home/oracle]$sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 25 15:48:48

Copyright (c) 1982, , Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/product/10.2.0/dbs/arch
Oldest online log sequence 255
Next log sequence to archive 257
Current log sequence 257
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area bytes
Fixed Size 2084400 bytes
Variable Size bytes
Database Buffers bytes
Redo Buffers 14692352 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter system set log_archive_dest_1='location=/archlog' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area bytes
Fixed Size 2084400 bytes
Variable Size bytes
Database Buffers bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /archlog
Oldest online log sequence 255
Next log sequence to archive 257
Current log sequence 257
SQL> create pfile from spfile;

File created.

至此oracle数据库归档开启完成；

6、oracle用户实施备份软件NBU和oracle数据库连接库程序oracle_link
[root@p550b:/]#su - oracle
[oracle@p550b:/home/oracle]$cd /usr/openv/netbackup/bin
[oracle@p550b:/usr/openv/netbackup/bin]$./oracle_link
提醒选择Y继续

至此NBUoracle数据库用户端安装完成；

二、NBU 7.0 AIX用户端脚本配置
1、 先创建相关目录和文件
[root@p550b:/]#cd /usr/openv
[root@p550b:/usr/openv]#mkdir controlfile
[root@p550b:/usr/openv]#mkdir orascripts
[root@p550b:/usr/openv]#cd controlfile
[root@p550b:/usr/openv/controlfile]#touch control.ora
[root@p550b:/usr/openv/controlfile]#cd ..
[root@p550b:/usr/openv]#cd orascripts
[root@p550b:/usr/openv/orascripts]#touch aix_ora_full.sh

2、 相关目录和文件给予属主和权限
[root@p550b:/usr/openv/orascripts]#cd ..
[root@p550b:/usr/openv]#ls -l
total 72
drwxr-xr-x 2 root system 256 Feb 25 16:03 controlfile
drwxr-xr-x 5 root bin 4096 Feb 25 15:40 java
drwxr-xr-x 7 root bin 8192 Feb 25 15:37 lib
drwxr-xr-x 5 root system 256 Feb 25 15:40 logs
drwxr-xr-x 2 root bin 256 Jan 05 msg
drwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackup
drwxr-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.swidtag
drwxr-xr-x 2 root bin 4096 Jan 05 resources
drwxr-xr-x 2 root bin 256 Jan 05 share
-r--r--r-- 1 root bin 5435 Jan 05 swidtag.xml
drwxr-xr-x 2 root bin 256 Feb 25 15:43 tmp
drwxr-xr-x 5 root bin 256 Feb 25 15:37 var
[root@p550b:/usr/openv]#chown -R oracle:dba controlfile
[root@p550b:/usr/openv]#chmod -R 777 controlfile
[root@p550b:/usr/openv]#chown -R oracle:dba orascripts
[root@p550b:/usr/openv]#chmod -R 777 orascripts
[root@p550b:/usr/openv]#ls -l
total 72
drwxrwxrwx 2 oracle dba 256 Feb 25 16:03 controlfile
drwxr-xr-x 5 root bin 4096 Feb 25 15:40 java
drwxr-xr-x 7 root bin 8192 Feb 25 15:37 lib
drwxr-xr-x 5 root system 256 Feb 25 15:40 logs
drwxr-xr-x 2 root bin 256 Jan 05 msg
drwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackup
drwxrwxrwx 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.swidtag
drwxr-xr-x 2 root bin 4096 Jan 05 resources
drwxr-xr-x 2 root bin 256 Jan 05 share
-r--r--r-- 1 root bin 5435 Jan 05 swidtag.xml
drwxr-xr-x 2 root bin 256 Feb 25 15:43 tmp
drwxr-xr-x 5 root bin 256 Feb 25 15:37 var

3、 编辑NBU备份数据库Rman脚本aix_ora_full.sh
[root@p550b:/usr/openv/orascripts]#vi aix_ora_full.sh

粘贴以下内容（完全备份oracle数据库和归档日志，并删除备份好归档日志，注意修改实例名oracle_sid和oracle_home和实际环境一致）
==========================================================
#!/bin/sh
# $Header: hot_database_backup.sh,v 1.9 /02/06 16:48:56 lstrub Stab $
#
#bcpyrght
#***************************************************************************
#* $VRTScprght: Copyright 1993 - 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 .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_FILE
chmod 666 $RMANLOG_FILE

# ---------------------------------------------------------------------------
# Log the start of this script.
# ---------------------------------------------------------------------------

echo Script $0 >> $RMAN_LOG_FILE
echo ==== started on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE

# ---------------------------------------------------------------------------
# Replace /db/oracle/product/ora81, below, with the Oracle home path.
# ---------------------------------------------------------------------------

ORACLE_HOME=/oracle/product/10.2.0
export ORACLE_HOME

# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle SID of the target database.
# ---------------------------------------------------------------------------

ORACLE_SID=orclyw
export 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_FILE
echo "RMAN: $RMAN" >> $RMAN_LOG_FILE
echo "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE
echo "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE
echo "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE

# -------
# Print out the value of the variables set by bphdb.
# ---------------------------------------------------------------------------

echo >> $RMAN_LOG_FILE
echo "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE
echo "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE
echo "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE
echo "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE
echo "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 /@' 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 yo