nbu安装和oracle rman安装.docx

1、nbu安装和oracle rman安装NBU for Oracle 安装和RMAN备份、恢复配置及测试一、 NBU for Oracle 安装安装master server1、改/etc/hosts文件，添加本备份系统内所有主机的IP地址和主机名，因为NBU是根据主机名来查找主机。2、确保media server所在主机上/dev/rmt目录下能看到磁带机信息。最好是能在磁带机内放一盘磁带并用tar命令确认能向磁带机写数据。3、将介质放在光驱内 #cd /cdrom/cdrom0 #./install 选择安装Netbackup，根据提示继续。在安装过程中，会问到“此主机是不是master s

2、erver”，安装master server时就答yes，安装media server时答no，并根据提示输入master server的主机名。注意 在集群环境中，请在安装过程中输入 NetBackup client的虚拟名称而不是实际的本地主机名。4、为方便使用，在root 的profile 中加入PATH=$PATH:/usr/openv/netbackup/bin:/usr/openv/netbackup/bin/admincmd:/usr/openv/netbackup/bin/goodies:/usr/openv/volmgr/bin:/usr/openv/volmgr/bin/g

3、oodiesMANPATH=$MANPATH:/usr/openv/man/share/manexport MAN MANPATH安装client 和 agent1、将介质放入光驱 #cd /cdrom/cdrom0 #./install 在提示输入server名字时输入master server的名字。2、修改/usr/openv/netbackup/bp.conf文件，在第一行的“SERVER = XXXXX”下面按照此格式增加其他media server的名字，有几台media server就增加几行。3、把agent介质放入光驱 #cd /cdrom/cdrom0 #./install

4、注意打上agent的补丁，我这次测试oracle9i时，发现不打agent补丁无法，备份保错。注意需要执行一条命令建立RMAN和NBU之间的联系# su oracle$ install_path/netbackup/bin/oracle_link二、 配置RMAN我此次数据库的一些参数，下面的描述都以这些参数为例子，以后可以根据不同参数修改命令和脚本。ORACLE_HOME=/oracle/product/9.2.0ORACLE_SID=dbORACLE_USER=oracleTARGET_CONNECT_STR=system/manager21 测试RMAN是否正常运行# su oracle

5、$ sqlplus /as sysdbaSQL startup; ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 781424 bytes Variable Size 221254544 bytes Database Buffers 616562688 bytesRedo Buffers 262144 bytes Database mounted. Database opened.SQL exit$ rman nocatalogRMANconnect targetRMANconnect t

6、arget system/manager2db连接正常，不报错，表示RMAN正常运行。这次由于客户oracle补丁打的有问题，RMAN一直不正常，可以在配置RMAN前先测试一下RMAN的状态。2 配置RMAN for NBU创建一个instance vertias 用来存放catalog库。Instance名字可以随便起$ dbca 用dbca工具创建创建catalog库/我706以上做了但补丁未打/$ drtias$ sqlplus /as sysdbaSQLstartup;SQLcreate tablespace rcvcat datafile /oradata/veritas/rcvca

7、t01.dbf size 100M extent management local segment space management auto;SQLcreate user rman identified by rman default tablespace rcvcat temporary tablespace temp quota unlimited on rcvcat;SQLgrant connect,resorce,recovery_catalog_owner to rman; /是resourceSQLexit$ rman catalog rman/rmanRMAN create c

8、atalog;注册备份数据库$ export ORACLE_SID=db （your instance need backup）$ rman catalog rman/rmanrman target / /7.25这里报错,我想是veritasRMAN register database;7.25为止3 编写rman for NBU 备份脚本脚本模版在installpath/netbackup/ext/db_ext/oracle/samples/rman目录下有hot_database_backup.sh和hot_database_restore.sh修改hot_database_backup

9、.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 (inconsist

10、ent) 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 orde

11、r 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 |

12、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 then rm -f $RMAN_L

13、OG_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=/

14、oracle/product/9.2.0export ORACLE_HOME# -# Replace ora81, below, with the Oracle SID of the target database.# -ORACLE_SID=dbexport 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

15、 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

16、_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_O

17、RA_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 e

18、nvironment 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 INC

19、REMENTAL 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=INCREM

20、ENTAL 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 $RMA

21、N_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 $

22、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.# -