[SOS]如何 利用 具有TMS 的备份文件，恢复 至没有 TSM 的 Server

wangzhonnew

btw have you ever used any heximal editor?

Noteser

原帖由 wangzhonnew 于 2009-8-23 14:19 发表
btw have you ever used any heximal editor?

Ultra Editor 算不算?

wangzhonnew

is it going to cause you any trouble to do another backup using logarchmeth1=off?
otherwise i can quickly write you a simple program to patch it

wangzhonnew

please backup the image to somewhere and try the tool i just made (rename patch.doc/patch_aix5.doc into patch/patch_aix5, and upload to your aix, and give 755)

(taoewang@db2debug) /home/taoewang/test $ cc test2.C -q64 -O2 -o patch

(taoewang@db2debug) /home/taoewang/test $ db2 restore db sample taken at 20090823123406
SQL2071N  An error occurred while accessing the shared library
"/home/taoewang/sqllib/adsm/libtsm.a". Reason code: "1".
(taoewang@db2debug) /home/taoewang/test $ ls -la | grep -i "20090823123406"
-rw-------    1 taoewang build     111534080 Aug 23 13:51 SAMPLE.0.taoewang.NODE0000.CATN0000.20090823123406.001
(taoewang@db2debug) /home/taoewang/test $ ./patch SAMPLE.0.taoewang.NODE0000.CATN0000.20090823123406.001
This tool is write for Noteser for a specific issue asked on ITPUB. This tool is NOT a generic tool to use in all situation, please DO NOT use it if you are NOT Noteser and it's not for the problem described in URL http://www.itpub.net/viewthread. ... ;extra=#pid14131754 . Otherwise this tool may corrupted your backup image permenantly.
Please press Ctrl+C if you want to exit, otherwise press Enter

i=1469800
DB PROFILE
offset_matchstring=0x166d68
offset_cksum=0x166d64
offset_flag=0x1678f5
cksum=0xa92a
(taoewang@db2debug) /home/taoewang/test $ db2 restore db sample taken at 20090823123406
DB20000I  The RESTORE DATABASE command completed successfully.
(taoewang@db2debug) /home/taoewang/test $ db2 get db cfg for sample | grep -i "LOGARCHMETH1"
First log archive method                 (LOGARCHMETH1) = OFF
Options for logarchmeth1                  (LOGARCHOPT1) =
(taoewang@db2debug) /home/taoewang/test $ db2 "rollforward db sample complete"

                                 Rollforward Status

Input database alias                   = sample
Number of nodes have returned status   = 1

Node number                            = 0
Rollforward status                     = not pending
Next log file to be read               =
Log files processed                    =  -
Last committed transaction             = 2009-08-23-16.34.08.000000 UTC

DB20000I  The ROLLFORWARD command completed successfully.
(taoewang@db2debug) /home/taoewang/test $ db2 connect to sample

   Database Connection Information

Database server        = DB2/AIX64 9.5.2
SQL authorization ID   = TAOEWANG
Local database alias   = SAMPLE

zhangzongjun

狼实在是厉害～
你的程序 是不是 将 备份文件的 "LOGARCHMETH1" 设置为了 "OFF" ?
能不能分享一下 你的 程序源文件，

这样如果再遇到这样的问题，也好 有个统一的解决方法。
谢谢～

[ 本帖最后由 zhangzongjun 于 2009-8-24 11:23 编辑 ]

wangzhonnew

呵呵，源程序就给不了了，涉及到一些内部的数据结构之类的咚咚 ：）
大概的思路就是在backup image里面找到其中的SQLDBCONF文件修改里面的logarchmeth1的flag，从TSM改到OFF

zhangzongjun

这个程序能修改所有的 备份文件 的 "LOGARCHMETH1" 修改成 'OFF' 吗？
还是有特定的限制？

[ 本帖最后由 zhangzongjun 于 2009-8-24 11:46 编辑 ]

wangzhonnew

v95, aix only

Noteser

原帖由 wangzhonnew 于 2009-8-24 11:48 发表
v95, aix only

太棒了～！

macrozeng

cool ！