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

Noteser

我有一个FULL BACKUP 文件，是 具有 TSM 服务器上产生的。
现在需要恢复至没有 TSM 的服务器上。

使用的是 重定向 恢复。
但是在 RESTORE DATABASE PRDDB CONTINUE 时报错如下：

RESTORE DATABASE FRS CONTINUE
SQL2071N  An error occurred while accessing the shared library
"/home/db2inst1/sqllib/adsm/libtsm.a". Reason code: "1".

我怎样才能解决这个问题，
将  具有TMS 的备份文件，恢复 至没有 TSM 的 Server上？

谢谢大家，在线等待～

Noteser

我估计 原因如下，
带有TSM的数据库是 归档数据库，归档文件放在 TSM上，

First log archive method (LOGARCHMETH1) = TSM

但是在没有TSM的数据库上恢复 时，造成以上错误。

该如何解决呢？

[ 本帖最后由 Noteser 于 2009-8-22 00:09 编辑 ]

wangzhonnew

db2adutl to extract backup image and logs to disk

Noteser

原帖由 wangzhonnew 于 2009-8-22 06:47 发表
db2adutl to extract backup image and logs to disk

含有 LOG 的 在线全备份 IMAGE 已经被下载到 ServerB上了(没有TSM),
做Redirect restore,
在重新设置 TableSpace 之后,
执行 RESTORE DB CONTINUE 的时候报错的.

第一步, 没问题:
RESTORE DATABASE PRODB
FROM '/db/db2inst1/db2backup'
TAKEN AT 20080714567426
ON '/db/db2inst1/db2data'
LOGTARGET  '/db/db2inst1/db2data/tmplog'
NEWLOGPATH '/db/db2inst1/db2data/actlog'
REDIRECT

第二步, Set Tabespace Container, 没问题

之后, RESTORE DATABASE PRODB CONTINUE; 就报错了

[ 本帖最后由 Noteser 于 2009-8-22 14:23 编辑 ]

Noteser

http://www-01.ibm.com/support/docview.wss?uid=swg21231835
但是我看不明白，请高手解释一下，谢谢～

[ 本帖最后由 Noteser 于 2009-8-22 15:17 编辑 ]

wangzhonnew

can you show the output for ls -laR ~/sqllib
thx

wangzhonnew

and db2level output

wangzhonnew

and did you get the error immediately after you start "restore continue", or you get it after a while?

Noteser

原帖由 wangzhonnew 于 2009-8-23 09:46 发表
and did you get the error immediately after you start "restore continue", or you get it after a while?

/home/db2inst1$ db2level
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080911", "U820796", and Fix Pack
"2a".
Product is installed at "/opt/IBM/db2/V9.5".

并不是一执行 "RESTORE DB CONTRINUE"，而是执行了好一段时间后，在几乎快完成的时候报错的。

wangzhonnew

It seems db2logmgr was started at the last step of restore, and it required to load TSM because the database is configured to use TSM.
I don't believe there's anyway to bypass this step or change the setting during middle of restore.

You may have to change logarchmeth1 to OFF on primary side, and take backup again, and restore on the target database.

THanks