NBU 70 Oracle for AIX安装配置手册_第1页
NBU 70 Oracle for AIX安装配置手册_第2页
NBU 70 Oracle for AIX安装配置手册_第3页
NBU 70 Oracle for AIX安装配置手册_第4页
NBU 70 Oracle for AIX安装配置手册_第5页
已阅读5页,还剩25页未读 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

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 3、执行安装,并选择2客户端安装,提示选择Y继续 rootp550a:/mnt

3、#./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_svrREQUIRED_INTER

4、FACE = 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 Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Relea

5、se 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 257C

6、urrent log sequence 257SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startup mount; ORACLE instance started.Total System Global Area 1610612736 bytesFixed Size 2084400 bytesVariable Size 436208080 bytesDatabase Buffers 1157627904 bytesRedo Buffers 14692352 b

7、ytesDatabase 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.Total System Global Area 16

8、10612736 bytesFixed Size 2084400 bytesVariable Size 436208080 bytesDatabase Buffers 1157627904 bytesRedo Buffers 14692352 bytesDatabase mounted.Database opened.SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /archlogOldest online log sequence 255Next

9、log sequence to archive 257Current 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

10、数据库客户端安装完成;二、NBU 7.0 AIX客户端脚本配置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 orascripts

11、rootp550b:/usr/openv/orascripts#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 sy

12、stem 256 Feb 25 15:40 logsdrwxr-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 20

13、10 resourcesdrwxr-xr-x 2 root 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/op

14、env#chown -R oracle:dba orascriptsrootp550b:/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 logsdrw

15、xr-xr-x 2 root bin 256 Jan 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

16、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 var3、 编辑NBU备份数据库的Rman脚本aix_ora_full.shrootp550b:/usr/openv/orascripts#vi aix_ora_full.sh粘贴如下内容(完全备份oracle数据库和归档日志,并删除备份好的归档日志,注意修改实例名oracle_sid和ora

17、cle_home和实际环境一致)=#!/bin/sh# $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 (inconsi

18、stent) 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 or

19、der 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

20、| 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_FI

21、LE then rm -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 = started on date = $RMAN_LOG_FILEecho $RMAN_LOG_FILE # -# Replace /db/oracle/product/ora81, below, with the Oracle home

22、path.# -ORACLE_HOME=/oracle/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 sy

23、s/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_FILEecho RMAN: $RMAN $RMAN_LOG_FILEecho ORACLE_SID: $ORACLE_SID $RMAN_LOG_FI

24、LEecho ORACLE_USER: $ORACLE_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_

25、FILEecho NB_ORA_SERV: $NB_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,

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

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

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

29、 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=INCREMENTA

30、L LEVEL=1 CUMULATIVE elif $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 c

31、ommand 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 o

32、f 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

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

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

35、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 want to archive the current log, back up all the# archive logs using two channels, putting a maximum of 20 logs# in a backup set, and deleting them once the

36、backup is complete.# Note that the format string is constructed to guarantee uniqueness and# to enhance NetBackup for Oracle backup and restore performance.# NOTE WHEN USING TNS ALIAS: When connecting to a database# using a TNS alias, you must use a send command or a parms operand to # specify envir

37、onment variables. In other words, when accessing a database# through a listener, the environment variables set at the system level are not # visible when RMAN is running. For more information on the environment# variables, please refer to the NetBackup for Oracle Admin. Guide.# -CMD_STR=ORACLE_HOME=

38、$ORACLE_HOMEexport ORACLE_HOMEORACLE_SID=$ORACLE_SIDexport ORACLE_SID$RMAN target / nocatalog msglog $RMAN_LOG_FILE append $RMAN_LOG_FILE RSTAT=$?else /usr/bin/sh -c $CMD_STR $RMAN_LOG_FILE RSTAT=$?fi # -# Log the completion of this script.# - if $RSTAT = 0 then LOGMSG=ended successfully/usr/openv/netbackup/bin/bpbackup -p oracle_c

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论