《tsm备份oracle数据库安装配置》由会员分享，可在线阅读，更多相关《tsm备份oracle数据库安装配置（45页珍藏版）》请在金锄头文库上搜索。
1、TSM5.5 备份和恢复 Oracle 11gR2IBM Tivoli Storage Manager for Databases Data Protection for Oracle，以下简称：TDPO1、安装 TDPO1.1、软件选择tivoli.tsm.client.api.32bittivoli.tsm.client.api.64bittivoli.tsm.client.oracle.aix.64bittivoli.tsm.client.oracle.tools.aix.64bittivoli.tsm.loc.client.oracle.aix.64bit.ela1.2、软件安装1.2
2、.1、将所有需要安装的文件集上传到服务器上，假设上传到/tmp/soft/tsm/oracle 目录。1.2.2、进入软件集目录，然后执行安装命令：bash-3.2# cd /tmp/soft/tsm/oraclebash-3.2# smitty installInstall and Update SoftwareInstall and Update from ALL Available Software在* INPUT device / directory for software 中输入./SOFTWARE to install 中输入 allACCEPT new license agre
3、ements?选项中 no 改为 yes然后按回车键安装，再按回车键确认后，软件安装完成。2、将 RMAN 与 TDPO 重新链接a、设置 Oracle LD_LIBRARY_PATH 选项修改.proflie 文件，将$ORACLE_HOME/lib 放在 LD_LIBRARY_PATH 选项第一位，即：LD_LIBRARY_PATH=$ORACLE_HOME/libb、关闭使用$ORACLE_HOME 的所有 Oracle 实例c、转至 $ORACLE_HOME 目录d、将库文件符号连接到 libobk.aln -s /usr/lib/libobk64.a $ORACLE_HOME/lib
4、/libobk.a3、定义 tdpo.opt 文件中的 TDPO 选项bash-3.2# cd /usr/tivoli/tsm/client/oracle/bin64bash-3.2# vi tdpo.optDSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.optDSMI_LOG /usr/tivoli/tsm/client/oracle/bin64TDPO_FS db01_oraTDPO_NODE db01_oracleTDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/o
5、racle/bin64TDPO_DATE_FMT 1TDPO_NUM_FMT 1TDPO_TIME_FMT 14、将 TDPO 节点注册到 TSM 服务器register node db01_oracle password maxnummp=2 passexp=0 backdelete=yes5、在 dsm.opt 和 dsm.sys 文件中定义 TSM 选项5.1、配置 dsm.optbash-3.2# cd /usr/tivoli/tsm/client/oracle/bin64bash-3.2# vi dsm.optSErvername tsmserver注意：此文件必须位于 tdpo.o
6、pt 中的 dsmi_orc_config 指定的目录中。5.2、配置 dsm.sysbash-3.2# cd /usr/tivoli/tsm/client/api/bin64bash-3.2# vi dsm.sysSErvername tsmserverCOMMMethod TCPipTCPPort 1500TCPServeraddress 192.168.2.16NODEname db01_oraclePASSWORDAccess prompt6、修改 TSM API 和 TDPO 目录的权限bash-3.2# chmod -R 777 /usr/tivoli/tsm/client/api
7、/bin64/bash-3.2# chmod -R 777 /usr/tivoli/tsm/client/oracle/bin64/6、配置 TSM 服务器6.1、定义策略域tsm: TSMSERVERdefine domain oradomainANR1500I Policy domain ORADOMAIN defined.6.2、定义策略tsm: TSMSERVERdefine pol oradomain orapolANR1510I Policy set ORAPOL defined in policy domain ORADOMAIN.6.3、定义管理类tsm: TSMSERVERd
8、efine mgmt oradomain orapol oramgmtANR1520I Management class ORAMGMT defined in policy domain ORADOMAIN, set ORAPOL.6.4、指派缺省管理类tsm: TSMSERVERassign defmgmt oradomain orapol oramgmtANR1538I Default management class set to ORAMGMT for policy domain ORADOMAIN, set ORAPOL.6.5、定义存储池tsm: TSMSERVERdefine s
9、tgpool orapool diskANR2200I Storage pool ORAPOOL defined (device class DISK).6.6、定义存储池卷tsm: TSMSERVERdefine volume orapool /tsm1/ora.dsm formatsize=512 wait=yesANR0984I Process 9 for DEFINE VOLUME started in the FOREGROUND at 12:19:20.ANR2206I Volume /tsm1/ora.dsm defined in storage pool ORAPOOL (de
10、vice class DISK).ANR0986I Process 9 for DEFINE VOLUME running in the FOREGROUND processed 1 items for a total of 536,870,912 bytes with a completion state of SUCCESS at 12:19:26.6.7、定义存储池空间触发器tsm: TSMSERVERdefine spacetrigger stg stgpool=orapool spaceexpansion=50 expansionprefix=/tsm1/ANR4485I A sto
11、rage pool space trigger has been defined and enabled for storage pool ORAPOOL.6.8、定义副本组tsm: TSMSERVERdefine copy oradomain orapol oramgmt dest=orapool verdeleted=0 retonly=0Session established with server TSMSERVER: AIX-RS/6000Server Version 5, Release 5, Level 4.0Server date/time: 09/03/10 12:58:21
12、 Last access: 09/03/10 12:14:15ANR1530I Backup copy group STANDARD defined in policy domain ORADOMAIN, set ORAPOL, management class ORAMGMT.6.9、激活备份策略ANR1554W DEFAULT Management class ORAMGMT in policy set ORADOMAIN ORAPOL does not have an ARCHIVE copygroup: files will not bearchived by default if t
13、his set is activated.Do you wish to proceed? (Yes (Y)/No (N) yANR1554W DEFAULT Management class ORAMGMT in policy set ORADOMAIN ORAPOL does not have an ARCHIVE copygroup: files will not bearchived by default if this set is activated.ANR1514I Policy set ORAPOL activated in policy domain ORADOMAIN.6.1
14、0、更新客户端节点信息tsm: TSMSERVERupdate node db01_oracle domain=oradomainANR2063I Node DB01_ORACLE updated.注：将节点 db01_oracle 的策略域改为 oradomain.7、修改 TDPO 节点密码bash-3.2# cd /usr/tivoli/tsm/client/oracle/bin64/bash-3.2# tdpoconf password8、查看 TDOP 配置信息bash-3.2# cd /usr/tivoli/tsm/client/oracle/bin64/bash-3.2# tdp
15、oconf Showenvironment9、将数据库改为归档模式10、测试 TDPO 与 Oracle 数据库的连接db01:/home/oracle$sbttest testThe sbt function pointers are loaded from libobk.a(shr.o) library.- sbtinit succeededReturn code -1 from sbtinit, bsercoer = 0, bsercerrno = 0Message 0 not found; product=RDBMS; facility=SBT如图：显示如上，表示测试成功，如果不成功，
16、有可能是 TDPO 目录或 TSM API 目录权限设置不对或者 tdpo.opt 文件配置错误。10、备份数据库10.1、备份数据文件通过 RMAN 执行备份数据文件脚本，过程如下：db01:/home/oracle$rmanRecovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 4 06:46:33 2010Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.RMAN connect targetconnected to target database: ZGWANG (DBID=74727
