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相關配置文件，防止備份邏輯日志在壓力測試時候寫入帶庫。
