INFORMIX基于TSM备份异机恢复
ZB0000HB01主机INFORMIX数据库备份配置;
$ls –l /home/informix/lib/ibsad001.so
lrwxr-xr-x 1 informix informix 11 Sep 22 2012 ibsad001.so -> libtxbsa.so
配置存储管理器版本
$ more /home/informix/etc/sm_versions
1|5.3.2|adsm|5
$ more /home/informix/etc/sm_versions.std
1|1.0.1|ism|ISM.2.20.UC1.114|
jszs_test主机:
当前设置:
$ls –l /home/informix/lib
lrwxr-xr-x 1 informix informix 35 Mar 5 10:27 ibsad001.so -> /usr/openv/netbackup/bin/infxbsa.so
jszs_test:[/home/informix/lib]#more /home/informix/etc/sm_versions
1|1.1.0|VERITAS-NetBackup|1|
jszs_test:[/home/informix/lib]#more /home/informix/etc/sm_versions.std
1|1.0.1|ism|ISM.2.20.UC1.114|
jszs_test:[/home/informix/etc]#grep -v '#' onconfig.hbtxids (检查对informix数据库应项配置)
调整设置:
jszs_test hbtxids [/home/informix/lib]$rm ibsad001.so
jszs_test hbtxids [/home/informix/lib]$ln -s ./libtxbsa.so ibsad001.so
从ZB0000HB01生产主机复制如下文件,存放路径与生产主机相同:
/home/informix/etc/sm_versions
/home/informix/etc/onconfig.hbtxids
/home/informix/etc/oncfg_hbtxids.0 (恢复后more了一下文件内容,见附件2)
/home/informix/etc/ixbar.0
/home/informix/.profile
在jszs_test安装TSM客户端软件,并配置相关配置文件(可以从ZB0000HB01生产主机):
/opt/tivoli/tsm/client/api/bin64/dsm.opt
/opt/tivoli/tsm/client/api/bin64/dsm.sys
/opt/Tivoli/tsm/optdb/ dsm_IFX.opt
/opt/tivolil/tsm/pwd/ ZB0000HB01_IFXND/TSM.PWD
恢复过程 :
设置节点选项文件:
jszs_test:[/opt/tivoli/tsm/optdb]#vi /opt/tivoli/tsm/optdb/dsm_IFX.opt
SERVername ZBTSM1_HB_IFX
给TSM备份节点设置日志文件:
jszs_test:[/opt/tivoli/tsm/pwd/ZB0000HB01_IFXND]#touch /opt/tivoli/tsm/pwd/ZB0000HB01_IFXND/dsierror.log
jszs_test:[/opt/tivoli/tsm/pwd/ZB0000HB01_IFXND]#chmod 775 dsierror.log
jszs_test hbtxids [/home/informix]$export DSMI_LOG=/opt/tivoli/tsm/pwd/ZB0000HB01_IFXND
jszs_test hbtxids [/home/informix]$onbar -r -w -p
jszs_test hbtxids [/home/informix/tmp]$tail -f bar_act.log
2013-03-22 21:30:40 7790 7788 Completed reserved pages restore (level 0 of rootdbs).
2013-03-22 21:30:40 7790 7788 (-43341) Logical log 2919 is needed by this restore but cannot be found in OnBar ixbar file.
..............................
2013-03-22 21:45:04 7790 7788 /home/informix/bin/onbar_d complete, returning 0 (0x00)
恢复完成:删除dsm相关配置文件,防止备份逻辑日志在压力测试时候写入带库。