利用NBU65备份AIX53下的ORACLE 10G数据库28293.docx

《利用NBU65备份AIX53下的ORACLE 10G数据库28293.docx》由会员分享，可在线阅读，更多相关《利用NBU65备份AIX53下的ORACLE 10G数据库28293.docx（12页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、利用NBU6.5备份AIX5.3下的ORACLE 10G数据库NBU服务器端由一台IBM 226服务器及一台昆腾虚拟带库组成，需备份的客户端为安装AIX5.3的IBM小机，备份的对象为ORACLE 10G数据库。整个备份的拓扑图如下：环境说明：1、NBU备份主服务器与昆腾虚拟带库已配置完成2、次只为增加的一台Oracle数据库服务器安装NBU客户端相关软件并调试，然后在NBU备份主服务器上添加此客户端并建立备份策略等相关调试3、IP地址（化名）：NBU备份主服务器：10.31.111.111Oracle数据库服务器：10.31.111.100操作步骤：1、配置Oracle数据库服务器的host

2、s文件#cd /etc#vi hosts添加一行：10.31.111.111 nbuserver保存退出。2、安装NBU clients软件通过FTP将NBU客户端软件上传至小机的TMP目录下，然后运行：#cd /tmp#chmod R 777 unixclients#cd unixclients#./installSymantec Installation ScriptCopyright 1993 2007 Symantec Corporation, All Rights Reserved. Installing NetBackup Client SoftwareNOTE: To insta

3、ll NetBackup Server software, insert the appropriate NetBackup Server cdrom.Do you wish to continue? y,n (y) /输入yDo you want to install the NetBackup client software for this client? y,n (y) /输入yThis package will install RS6000/AIX5 client.This package will install NetBackup client 6.5.Enter the nam

4、e of the NetBackup server : nbuserver /输入NBU备份主服务器hostnameWould you like to use “oracle1 as the configuredname of the NetBackup client? y,n (y) /输入y，使用原小机的hostsname:oracle1确认后，就开始安装NBU客户端软件，安装的默认路径为/usr/openv/netbackup。3、配置和查看bp.conf#cd /usr/openv/netbackup#cat bp.confSERVER = nbuserverCLIENT_NAME =

5、 oracle14、安装database agent将database agent安装文件上传至上机的/tmp文件夹中，然后：#cd /tmp#chmod R 777 /agents#./installSymantec Installation ScriptCopyright 1993 2007 Symantec Corporation, All Rights Reserved. Installation Options 1 NetBackup Add-On Product Software 2 NetBackup Database Agent Software q To quit from

6、this scriptChoose an option default: q: 2 /选择2，安装database agent*There are two ways to install database agent software.1. Remote Installation: Loads the software on a server with the intent of pushing database software out to affected clients.2. Local Installation: Loads and installs the software onl

7、y to this local machine.*Do you want to do a local installation? y,n (n) y /进行本地安装* NetBackup Database Agent InstallationChoose the Database Agents you wish to installone at a time or select Install All Database Agents. 1) NetBackup for DB2 2) NetBackup for Informix 3) NetBackup for Lotus Notes 4) N

8、etBackup for Oracle 5) NetBackup for SAP 6) NetBackup for Sybase 7) Install All Database Agents q) Done Selecting Agents x) Exit from this ScriptChoose an option: 4 /选择oracleChoose an option: q /完成选择操作You have chosen to install these Database Agents: NetBackup for OracleIs this list correct? y,n (y)

9、 /确定安装oracle agents5、编辑sh备份脚本Database agent安装完后，会在/usr/openv/netbackup/ext/db_ext/oracle/samples/rman中有一些例子文件，利用其中的一个，运行：#cd /usr/openv/netbackup/ext/db_ext/oracle/samples/rman#cp hot_database_backup.sh hot_database_backup.10.31.111.100.sh然后使用vi编辑该sh，只需修改如下参数：ORACLE_HOME=/oracle/product/10Gexport OR

10、ACLE_HOMEORACLE_SID=orcl2export ORACLE_SIDORACLE_USER=oracleTARGET_CONNECT_STR=/完成设置后，保存退出。6、链接NetBackup for Oracle 和RMAN#su oracle#cd /usr/openv/netbackup/bin#./oracle_linkMon Mar 15 11:29:34 BEIST 2010All Oracle instances should be shutdown before running this script.Please log into the Unix syste

11、m as the Oracle owner for running this scriptDo you want to continue? (y/n) n y /输入y，开始安装LIBOBK path: /usr/openv/netbackup/binORACLE_HOME: /oracle/product/10GOracle version: 10.2.0.3.0Linking LIBOBK:ln -s /usr/openv/netbackup/bin/libobk.a64 /oracle/product/10G/lib/libobk.aDonePlease check the trace

12、file located in /tmp/make_trace.856304to make sure the linking process was successful.出现上面文字后，说明动态链接库已链接成功。7、NBU备份主服务器设置首先设置主服务器的hosts文件，将IBM小机的hostname:oracle1添加至hosts中，用记事本打开c:windowssystem32driversetchosts，添加如下：10.31.111.100 oracle1打开NBU主界面，开始为10.31.111.100创建一个备份策略在policies上点右键选择new policy，输入相应策略

13、名称后点击确定设置attributes选项卡，policy类型选择oracle，policy storage unix选择有效的存储单元设置Schedules选项卡，点击选项卡下面的New按扭，新建一个备份日程，选择automatic full backup，全备，frequency选择每星期一次备份，retention选择保留两个星期备份开始时间为星期日晚上9点开始设置完后，schedules有两个备份策略，全备和增量备份设置clients，输入IBM小机的hostname:oracle1，操作系统选择RS6000/AIX5设置backup selections，将上面新建并编辑好的.sh备份脚本输入至对话框中，点击确定后，完成策略的新建开始测试备份，在新建的policies的10.31.111.100上点右键选择Manual Backup，手动启动备份转至Activity Monitor，查看备份情况至此，IBM小机上的ORACLE已经可以定期的备份至昆腾虚拟磁带库中。