当前位置:操作系统 > Unix/Linux >>

INFORMIX基于TSM备份异机恢复

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相关配置文件,防止备份逻辑日志在压力测试时候写入带库。
 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,