《NBU+Oracle+AIX安装配置手册.docx》由会员分享，可在线阅读，更多相关《NBU+Oracle+AIX安装配置手册.docx（31页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、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 p5
2、50a20.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 挂载ISO镜像#loopmount -i /tmp/nbu/NB_7.0_AI
3、X64.ISO -m /mnt -o -V cdrfs -o ro3、执行安装，并选择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_
4、NAME = p550a改为SERVER = hpdl380-backupCLIENT_NAME = ora_svrREQUIRED_INTERFACE = ora_svr5、修改客户端oracle数据库为归档模式rootp550b:/usr/openv/netbackup#su - oracleoraclep550b:/home/oracle$sqlplus /as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 25 15:48:48 2011Copyright (c) 1982, 2007, Oracle. All R
5、ights 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
6、/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 bytesFixed Size bytesVariable Size bytesDatabase Buff
7、ers bytesRedo Buffers 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.Tota
8、l System Global Area bytesFixed Size bytesVariable Size bytesDatabase Buffers bytesRedo Buffers 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 25
9、7Current 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客户
10、端脚本配置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/orasc
11、ripts#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 logs
12、drwxr-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 r
13、oot 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 or
14、ascriptsrootp550b:/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
15、 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-
16、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
17、# $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
18、 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 prop
19、erly 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 ou
20、tput 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_FI
21、LEfi# -# 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=/oracl
22、e/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
23、 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: $ORACL
24、E_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_
25、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
26、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 IN
27、CREMENTAL 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=INCRE
28、MENTAL 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 $RM
29、AN_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
30、$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
31、 # 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)
32、.# 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 controlfil
33、e 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 t
34、ablespaces,# 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 wil