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 p5
2、50a_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继续 ro
3、otp550a:/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_svrRE
4、QUIRED_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 Copyright (c) 1982, , Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition R
5、elease 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
6、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 2084400 bytesVariable Size bytesDatabase Buffers bytesRedo Buffers bytesDatabase mounted.SQL alter databa
7、se 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 bytesFixed Size 2084400 bytesVariable S
8、ize 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 257Current log sequence 257SQL create pfile from spfil
9、e;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
10、:/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、 有关目录和文献赋予属主和权限rootp550
11、b:/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 msgdrwxr-xr-x 8 roo
12、t 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 resourcesdrwxr-xr-x 2 root bin 256 Jan 05 share-r-r-r- 1 root bin 5435 Jan 05 swidtag
13、.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
14、#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 msgdrwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackupdrwxrwxrwx 2 ora
15、cle 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 resourcesdrwxr-xr-x 2 root bin 256 Jan 05 share-r-r-r- 1 root bin 5435 Jan 05 swidtag.xmldrwxr-xr-x 2 root bin 256 Feb 25 15:43 tmpdrwx
16、r-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 /02/06 16:48:56 lstrub Stab $#bcpyrght#*#* $VRTScprg
17、ht: 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 d
18、isk 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 u
19、ser 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=$
20、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_FILEfi# -# Initialize the log file.# - echo $RMAN_LOG_FILEchmod 666 $RMAN_LOG_FILE # -# Log the start o
21、f 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 databa
22、se.# -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=$OR
23、ACLE_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 var
24、iables 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 assume
25、s 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
26、 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# leve
27、l 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 b
28、ecause, 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
29、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
30、=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
31、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 aut
32、omatically 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 we
33、ek.# 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 a
34、re 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 wan