虚位以待(AD)
虚位以待(AD)
首页 > 数据库 > DB2数据库 > INFORMIX基于TSM备份异机恢复

INFORMIX基于TSM备份异机恢复
类别:DB2数据库   作者:码皇   来源:互联网   点击:

INFORMIX基于TSM备份异机恢复ZB0000HB01主机INFORMIX数据库备份配置;$ls –l home informix lib ibsad001 solrwxr-xr-x 1 informix informix 11 Sep 22 2012 ibsad001 so -> libtx
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相关配置文件,防止备份逻辑日志在压力测试时候写入带库。  
相关热词搜索: INFORMIX 基于 备份