NBU 7.0 Oracle for AIX安裝配置手冊(cè)

1、NBU7.0 Oracle for AIX安裝配置手冊(cè)目 錄 TOC o 1-3 h z u HYPERLINK l _Toc286444969 一、NBU 7.0 AIX客戶端安裝配置 PAGEREF _Toc286444969 h 3 HYPERLINK l _Toc286444970 二、NBU 7.0 AIX客戶端腳本配置 PAGEREF _Toc286444970 h 8 HYPERLINK l _Toc286444971 三、NBU 7.0 Catalog目錄庫(kù)備份設(shè)置 PAGEREF _Toc286444971 h 17 HYPERLINK l _Toc286444972 四、N

2、BU 7.0 oracle for aix備份作業(yè)設(shè)置 PAGEREF _Toc286444972 h 22一、NBU 7.0 AIX客戶端安裝配置1、先設(shè)置客戶端的hosts文件，包括備份服務(wù)器的hosts也要對(duì)應(yīng)雙向解析。#rootp550b:/#more /etc/hosts127.0.0.1 loopback localhost # loopback (lo0) name/address10.10.10.1 p550a_boot1 p550a20.20.20.1 p550a_boot2172.16.1.7 p550a_per10.10.10.2 p550b_boot1 p550b20.

3、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、#放入 For AIX光盤，在系統(tǒng)掛載安裝盤rootp550a:/dev#mount -v cdrfs -o ro /dev/cd0 /mnt 3、執(zhí)行安裝，并選擇2客戶端安裝，提示選擇Y繼續(xù) rootp550a:/mnt#./install然后根據(jù)提示輸入備份服務(wù)器的名稱hpdl380-backup（一定要為備份服務(wù)器名，不建議用IP）, 提示選擇Y繼續(xù)選擇后則開(kāi)始安裝軟件如下：安裝

4、結(jié)束后選擇3退出4、修改客戶端NBU配置參數(shù)rootp550b:/usr/openv/netbackup#vi 修改雙機(jī)HACMP系統(tǒng)一臺(tái)P550的/usr/openv/netbackup/配置文件信息SERVER = hpdl380-backupCLIENT_NAME = p550a改為SERVER = hpdl380-backupCLIENT_NAME = ora_svrREQUIRED_INTERFACE = ora_svr5、修改客戶端oracle數(shù)據(jù)庫(kù)為歸檔模式rootp550b:/usr/openv/netbackup#su - oracleoraclep550b:/home/or

5、acle$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 Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Tes

6、ting optionsSQL archive log list;Database log mode Archive ModeAutomatic archival Enableddbs/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 instanc

7、e started.Total System Global Area 1610612736 bytesFixed Size 2084400 bytesVariable Size 436208080 bytesDatabase Buffers 1157627904 bytesRedo Buffers 14692352 bytesDatabase mounted.SQL alter database archivelog;Database altered.SQL alter system set log_archive_dest_1=location=/archlog scope=spfile;S

8、ystem altered.SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startupORACLE instance started.Total System Global Area 1610612736 bytesFixed Size 2084400 bytesVariable Size 436208080 bytesDatabase Buffers 1157627904 bytesRedo Buffers 14692352 bytesDatabase moun

9、ted.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 spfile;File created.至此oracle數(shù)據(jù)庫(kù)歸檔開(kāi)啟完成；6、oracle用戶執(zhí)行備份軟件NBU和oracle數(shù)據(jù)庫(kù)

10、連接庫(kù)程序oracle_linkrootp550b:/#su - oracleoraclep550b:/home/oracle$cd /usr/openv/netbackup/binoraclep550b:/usr/openv/netbackup/bin$./oracle_link提示選擇Y繼續(xù)至此NBU的oracle數(shù)據(jù)庫(kù)客戶端安裝完成；二、NBU 7.0 AIX客戶端腳本配置先創(chuàng)建相關(guān)目錄和文件rootp550b:/#cd /usr/openvrootp550b:/usr/openv#mkdir controlfilerootp550b:/usr/openv#mkdir orascript

11、srootp550b:/usr/openv#cd controlfilerootp550b:/usr/openv/controlfile#touch rootp550b:/usr/openv/controlfile#cd .rootp550b:/usr/openv#cd orascriptsrootp550b:/usr/openv/orascripts#相關(guān)目錄和文件賦予屬主和權(quán)限r(nóng)ootp550b:/usr/openv/orascripts#cd .rootp550b:/usr/openv#ls -ltotal 72drwxr-xr-x 2 root system 256 Feb 25 16

12、: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 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,Ent

13、erprisedrwxr-xr-x 2 root bin 4096 Jan 05 2010 resourcesdrwxr-xr-x 2 root bin 256 Jan 05 2010 share-r-r-r- 1 root bin 5435 Jan 05 drwxr-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 c

14、ontrolfilerootp550b:/usr/openv#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 syst

15、em 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 netbackupdrwxrwxrwx 2 oracle dba 256 Feb 25 16:04 orascripts-r-r-r- 1 root bin 5435 Feb 25 15:40 ,Enterprisedrwxr-xr-x 2 root bin 4096 Jan 05 2010 resourcesdrwxr-xr-x 2 root bin 256 Jan 05 2010 s

16、hare-r-r-r- 1 root bin 5435 Jan 05 drwxr-xr-x 2 root bin 256 Feb 25 15:43 tmpdrwxr-xr-x 5 root bin 256 Feb 25 15:37 var編輯NBU備份數(shù)據(jù)庫(kù)的Rman腳本rootp550b:/usr/openv/orascripts#vi粘貼如下內(nèi)容（完全備份oracle數(shù)據(jù)庫(kù)和歸檔日志，并刪除備份好的歸檔日志，注意修改實(shí)例名oracle_sid和oracle_home和實(shí)際環(huán)境一致）=#!/bin/sh# $Header: ,v 1.9 2002/02/06 16:48:56 lstrub

17、Stab $#bcpyrght#*#* $VRTScprght: Copyright 1993 - 2002 VERITAS Software Corporation, All Rights Reserved $ *#*#ecpyrght# # # 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

18、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 properly we switch user (su -) to the oracle dba account before# execution. If this script runs u

19、nder 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 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 of th

21、is 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=export ORACLE_HOME# # Replace ora81, below, with the Oracle SID of the target database.# ORACLE_SID=orclywexport OR

22、ACLE_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=$ORACLE_HOME/bin/rman# # Print out the va

23、lue 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 variables set by bphdb.# echo $RMAN_LOG_FILE

24、echo 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 assumes that the database is properly opened. If

25、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 BACKUP_TYPE# For example, when:# schedule ty

26、pe 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# level 0 (full). To change the default for a user ini

27、tiated# 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 because, although they are identical in content,

28、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 backup requested $RMAN_LOG_FILE BACKUP_TYPE=INCREM

29、ENTAL 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=0fi# # Call Recovery Manager to initiate the back

30、up. 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.# # Ba

31、cks 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 automatically included each time file 1 of# the system

32、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 week.# The scenario assumes:# o you are backing your d

33、atabase 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 are not using a Recovery Catalog# o you are explicitl

34、y 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 want to archive the current log, bac

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

36、LIAS: When connecting to a database# using a TNS alias, you must use a send command or a parms operand to # specify environment 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

37、 information on the environment# variables, please refer to the NetBackup for Oracle Admin. Guide.# CMD_STR=ORACLE_HOME=$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 successfull