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

简介：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=h/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定位错误真正出现的位置。