安装配置手册模板.docx_咨信网zixin.com.cn

资源描述

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也要对应双向解析。 #[root@p550b:/]#more /etc/hosts 127.0.0.1 loopback localhost # loopback (lo0) name/address 10.10.10.1 p550a_boot1 p550a 20.20.20.1 p550a_boot2 172.16.1.7 p550a_per 10.10.10.2 p550b_boot1 p550b 20.20.20.2 p550b_boot2 172.16.1.8 p550b_per 172.16.1.9 ora_svr =====NBU backup server===== 172.16.1.242 hpdl380-backup 2、#放入NBU 7.0 For AIX光盘，在系统挂载安装盘 [root@p550a:/dev]#mount -v cdrfs -o ro /dev/cd0 /mnt 3、实施安装，并选择2用户端安装，提醒选择Y继续 [root@p550a:/mnt]#./install 然后依据提醒输入备份服务器名称hpdl380-backup（一定要为备份服务器名，不提议用IP）, 提醒选择Y继续选择后则开始安装软件以下：安装结束后选择3退出 4、修改用户端NBU配置参数 [root@p550b:/usr/openv/netbackup]#vi bp.conf 修改双机HACMP系统一台P550/usr/openv/netbackup/bp.conf配置文件信息 SERVER = hpdl380-backup CLIENT_NAME = p550a 改为 SERVER = hpdl380-backup CLIENT_NAME = ora_svr REQUIRED_INTERFACE = ora_svr 5、修改用户端oracle数据库为归档模式 [root@p550b:/usr/openv/netbackup]#su - oracle [oracle@p550b:/home/oracle]$sqlplus "/as sysdba" SQL*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 Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/product/10.2.0/dbs/arch Oldest online log sequence 255 Next log sequence to archive 257 Current log sequence 257 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area bytes Fixed Size 2084400 bytes Variable Size bytes Database Buffers bytes Redo Buffers 14692352 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter system set log_archive_dest_1='location=/archlog' scope=spfile; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area bytes Fixed Size 2084400 bytes Variable Size bytes Database Buffers bytes Redo Buffers 14692352 bytes Database mounted. Database opened. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /archlog Oldest online log sequence 255 Next log sequence to archive 257 Current log sequence 257 SQL> create pfile from spfile; File created. 至此oracle数据库归档开启完成； 6、oracle用户实施备份软件NBU和oracle数据库连接库程序oracle_link [root@p550b:/]#su - oracle [oracle@p550b:/home/oracle]$cd /usr/openv/netbackup/bin [oracle@p550b:/usr/openv/netbackup/bin]$./oracle_link 提醒选择Y继续至此NBUoracle数据库用户端安装完成；二、NBU 7.0 AIX用户端脚本配置 1、先创建相关目录和文件 [root@p550b:/]#cd /usr/openv [root@p550b:/usr/openv]#mkdir controlfile [root@p550b:/usr/openv]#mkdir orascripts [root@p550b:/usr/openv]#cd controlfile [root@p550b:/usr/openv/controlfile]#touch control.ora [root@p550b:/usr/openv/controlfile]#cd .. [root@p550b:/usr/openv]#cd orascripts [root@p550b:/usr/openv/orascripts]#touch aix_ora_full.sh 2、相关目录和文件给予属主和权限 [root@p550b:/usr/openv/orascripts]#cd .. [root@p550b:/usr/openv]#ls -l total 72 drwxr-xr-x 2 root system 256 Feb 25 16:03 controlfile drwxr-xr-x 5 root bin 4096 Feb 25 15:40 java drwxr-xr-x 7 root bin 8192 Feb 25 15:37 lib drwxr-xr-x 5 root system 256 Feb 25 15:40 logs drwxr-xr-x 2 root bin 256 Jan 05 msg drwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackup drwxr-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.swidtag drwxr-xr-x 2 root bin 4096 Jan 05 resources drwxr-xr-x 2 root bin 256 Jan 05 share -r--r--r-- 1 root bin 5435 Jan 05 swidtag.xml drwxr-xr-x 2 root bin 256 Feb 25 15:43 tmp drwxr-xr-x 5 root bin 256 Feb 25 15:37 var [root@p550b:/usr/openv]#chown -R oracle:dba controlfile [root@p550b:/usr/openv]#chmod -R 777 controlfile [root@p550b:/usr/openv]#chown -R oracle:dba orascripts [root@p550b:/usr/openv]#chmod -R 777 orascripts [root@p550b:/usr/openv]#ls -l total 72 drwxrwxrwx 2 oracle dba 256 Feb 25 16:03 controlfile drwxr-xr-x 5 root bin 4096 Feb 25 15:40 java drwxr-xr-x 7 root bin 8192 Feb 25 15:37 lib drwxr-xr-x 5 root system 256 Feb 25 15:40 logs drwxr-xr-x 2 root bin 256 Jan 05 msg drwxr-xr-x 8 root bin 4096 Feb 25 15:40 netbackup drwxrwxrwx 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.swidtag drwxr-xr-x 2 root bin 4096 Jan 05 resources drwxr-xr-x 2 root bin 256 Jan 05 share -r--r--r-- 1 root bin 5435 Jan 05 swidtag.xml drwxr-xr-x 2 root bin 256 Feb 25 15:43 tmp drwxr-xr-x 5 root bin 256 Feb 25 15:37 var 3、编辑NBU备份数据库Rman脚本aix_ora_full.sh [root@p550b:/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 #*************************************************************************** #* $VRTScprght: 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 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 under a user account that has Oracle dba # privilege, it will be executed using this user's account. # --------------------------------------------------------------------------- # --------------------------------------------------------------------------- # Determine the user which is executing this script. # --------------------------------------------------------------------------- CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1` # --------------------------------------------------------------------------- # Put output in <this file name>.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_FILE" ] then rm -f "$RMAN_LOG_FILE" fi # ----------------------------------------------------------------- # Initialize the log file. # ----------------------------------------------------------------- echo >> $RMAN_LOG_FILE chmod 666 $RMAN_LOG_FILE # --------------------------------------------------------------------------- # Log the start of this script. # --------------------------------------------------------------------------- echo Script $0 >> $RMAN_LOG_FILE echo ==== started on `date` ==== >> $RMAN_LOG_FILE echo >> $RMAN_LOG_FILE # --------------------------------------------------------------------------- # Replace /db/oracle/product/ora81, below, with the Oracle home path. # --------------------------------------------------------------------------- ORACLE_HOME=/oracle/product/10.2.0 export ORACLE_HOME # --------------------------------------------------------------------------- # Replace ora81, below, with the Oracle SID of the target database. # --------------------------------------------------------------------------- ORACLE_SID=orclyw export 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=$ORACLE_HOME/bin/rman # --------------------------------------------------------------------------- # Print out the value of the variables set by this script. # --------------------------------------------------------------------------- echo >> $RMAN_LOG_FILE echo "RMAN: $RMAN" >> $RMAN_LOG_FILE echo "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE echo "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE echo "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE # --------------------------------------------------------------------------- # Print out the value of the variables set by bphdb. # --------------------------------------------------------------------------- echo >> $RMAN_LOG_FILE echo "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE echo "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE echo "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE echo "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE echo "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 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 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 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 "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="INCREMENTAL LEVEL=1 CUMULATIVE" elif [ "$BACKUP_TYPE" = "" ] then echo "Default - Full backup requested" >> $RMAN_LOG_FILE BACKUP_TYPE="INCREMENTAL LEVEL=0" fi # --------------------------------------------------------------------------- # 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 <userid>/<passwd>@<tns alias>' 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 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 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 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 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 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 yo

展开阅读全文