《NetbackupforOracle备份实施手册》由会员分享，可在线阅读，更多相关《NetbackupforOracle备份实施手册（11页珍藏版）》请在金锄头文库上搜索。
1、通过 rman 从 NBU 备份恢复 ORACLE环境：redhat 4 as update 7NUB6.5.2Oracle 10.2.0.1ORACLE SID=LJY1. 安装 database设置 oracle 用户及安装目录/usr/sbin/groupadd oinstall/usr/sbin/groupadd dba/usr/sbin/useradd -m -g oinstall -G dba oraclemkdir -p /u01/app/oraclemkdir -p /u02/oradatachown -R oracle:oinstall /u01/app/oracle /u0
2、2/oradatachmod -R 775 /u01/app/oracle /u02/oradata更改主机配置文件i. Root 用户vi /etc/sysctl.confkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 1048576net.core.rmem_max = 104
3、8576net.core.wmem_default = 262144net.core.wmem_max = 262144vi /etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536vi /etc/pam.d/loginsession required /lib/security/pam_limits.sosession required pam_limits.sovi /etc/profileif $USER = o
4、racle ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifiii. oracle 用户su - oraclevi ./.bash_profileORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1ORACLE_SID=LJYexport ORACLE_HOME ORACLE_BASE ORACLE_SIDPATH=$PATH:$HOME/bin:$ORACLE_HO
5、ME/bin安装 libaio 在第 4 张光盘。否则安装 oracle 检测出错。安装 oracle 应用并创建数据库su - oracle安装 oracle 应用程序创建数据库配置归档模式shutdown immediate;startup mount;ALTER DATABASE ARCHIVELOG;alter database open;2. 安装 NBU Clientsu - root安装 ICS bpx安装 NBU Client安装 Database Agent for oraclesu - oracle运行 oracle_link 脚本：/usr/openv/netbackup
6、/bin/oracle_link3. 配置 rman 脚本配置策略配置 rman 脚本send NB_ORA_SERV=ljy_nbu7,NB_ORA_CLIENT=oracle10a;BACKUPFORMAT cntrl_%I_%s_%p_%t4. 完成创建、配置、启动监听器 lsnrctl start5. 附录 1：nbu oracle 备份脚本#!/bin/sh# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $#bcpyrght#*#* $VRTScprght: Copyright 1993 - 2007 Syman
7、tec 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 progressin
8、g.# 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# p
9、rivilege, 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=$0.out# -# You may want to delete the
10、 output file so that backup information does# not accumulate. If not, delete the following lines.# -if -f $RMAN_LOG_FILE thenrm -f $RMAN_LOG_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 = start
11、ed on date = $RMAN_LOG_FILEecho $RMAN_LOG_FILE# -# Replace /db/oracle/product/ora81, below, with the Oracle home path.# -ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1export ORACLE_HOME# -# Replace ora81, below, with the Oracle SID of the target database.# -ORACLE_SID=LJYexport ORACLE_SID# -# Replace ora81, below, with the Oracle DBA user id (account).# -
