ITPub博客

首页 > Linux操作系统 > Linux操作系统 > aix平台部署tsm tdpo for oracle参考流程

aix平台部署tsm tdpo for oracle参考流程

原创 Linux操作系统 作者:tivoli2000 时间:2009-02-12 16:40:06 0 删除 编辑
tsm server 部署在一台aix机器上,tsm client和tdpo for oracle(oracle安装在此机器上)部署在另外一台机器上,通过配置tdpo for oracle实现oracle(rman)结合tsm的自动备份功能。


oslevel -r
5300-06

tsm 5.3 tdpo 5.3

//通过dsmadmc:

tsm存储池和备份节点定义:

define stgpool orap 3580LTO3  maxscratch=20
copy domain standard orap
update copy orap STANDARD STANDARD STANDARD  type=backup verexists=1 verdeleted=0 retextra=0 retonly=0  dest=orap
validate policy orap standard
activate policy orap standard
reg node  oraclea p550a domain=orap backdel=yes

//在client端:
tdpo配置:
su - oracle
ln -s /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a

/usr/tivoli/tsm/client/api/bin64/dsm.opt
/usr/tivoli/tsm/client/api/bin64/dsm.sys

/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt

DSMI_ORC_CONFIG    /usr/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG           /oracle
TDPO_FS            orc10_db
TDPO_NODE          oraclea
TDPO_OWNER         root
TDPO_PSWDPATH      /usr/tivoli/tsm/client/oracle/bin64

./tdpoconf password

./tdpoconf showenv

IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 3, Level 3.0
(C) Copyright IBM Corporation 1997, 2006. All rights reserved.

Data Protection for Oracle Information
 Version:              5
 Release:              3
 Level:                3
 Sublevel:             0
 Platform.:             64bit TDP Oracle AIX

Tivoli Storage Manager Server Information
 Server Name:          TSMSVR
 Server Address:       P550TSM_SRV
 Server Type:          AIX-RS/6000
 Server Port:          1500
 Communication Method: TCP/IP

Session Information
 Owner Name:           root
 Node Name:            oraclea
 Node Type:            TDP Oracle AIX
 DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
 DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/api/bin64/dsm.opt
 TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
 Password Directory:   /usr/tivoli/tsm/client/oracle/bin64
 Compression:          FALSE
 License Information:  License file exists and contains valid license data.

测试tdpo是否链接成功:

export TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
sbttest test
The sbt function pointers are loaded from libobk.a(shr.o) library.
-- sbtinit succeeded

oracle备份脚本:

cat bkdb.scr
#!/bin/ksh
cur_date=`date +%Y%m%d`
export ORACLE_SID=xxxx
export TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
rman target sys/future  >/oracle/rmanscr/bkdb_$cur_date.log<CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 days;
backup database plus archivelog delete input;
exit;
EOF

cat bkdboraclea.sh
su - oracle -c /oracle/rmanscr/bkdb.scr

丢失归档同步控制文件的方法:
crosscheck archivelog all;

tip:检查tdpoerror.log定位错误真正出现的位置。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/18983976/viewspace-548874/,如需转载,请注明出处,否则将追究法律责任。

下一篇: TSM+ORACLE+rman
请登录后发表评论 登录
全部评论

注册时间:2009-02-10

  • 博文量
    103
  • 访问量
    127823