SQL2542N 错误解析

字数 3783阅读 7397评论 3赞 0

最新恢复数据库碰到一个奇怪的问题,SQL2542N 环境: usserver001机器上安装sid为EPD sap系统,数据库为EPD. usserver002机器上安装sid为EP1 sap系统,数据库为EP1. 错误发生: 在zusserver002机器上利用usserver001机器上EPD的数据库备份来恢复EP1数据库,目的是刷新EP1系统: usserver002:db2 RESTORE DATABASE EPD USE TSM OPEN 2 SESSIONS TAKEN AT 20100806222624 TO /db2/EP1 INTO EP1 NEWLOGPATH /db2/EP1/log_dir/NODE0000/ WITH 8 BUFFERS BUFFER 10240 REDIRECT PARALLELISM 4 SQL2542N  No match for a database image file was found based on the source database alias "EPD" and timestamp "20100806222624" provided. 其实 db2adutl query看20100806222624时间戳的备份是存在的: usserver002:db2ep1 2> db2adutl query full db EPD password usserver001_EPD Query for database EPD Retrieving FULL DATABASE BACKUP information.     1 Time: 20100806222624  Oldest log: S0013998.LOG  DB Partition Number: 0    Sessions: 2      2 Time: 20100730222605  Oldest log: S0013977.LOG  DB Partition Number: 0    Sessions: 2  以前没有出现过此类错误,一开始还怀疑是否磁带有问题,后来 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 10"><meta name="Originator" content="Microsoft Word 10"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><style>

</style>

<o:p></o:p>db2adutl EXTRACT full  TAKEN at 20100806222624 db epd password usserver001_EPD也可以看到磁带上存在20100806222624 两份介质.进一步分析,判断tsm相关参数修改错误，检查确认发现，真的是错了,

usserver002:db2ep1 3> db2 get db cfg for ep1 | grep -i tsm  TSM management class                    (TSM_MGMTCLASS) =  TSM node name                            (TSM_NODENAME) = usserver001_EPD  TSM owner                                   (TSM_OWNER) = db2ep1(target db instancename)  TSM password                             (TSM_PASSWORD) = ***** 修改:db2 update db cfg for ep1 using   TSM_OWNER db2epd  restart db2 usserver002:db2ep1 3> db2 get db cfg for ep1 | grep -i tsm  TSM management class                    (TSM_MGMTCLASS) =  TSM node name                            (TSM_NODENAME) = usserver001_EPD  TSM owner                                   (TSM_OWNER) = db2epd(source db instancename)  TSM password                             (TSM_PASSWORD) = ***** 重新执行恢复ok RESTORE DATABASE EPD USE TSM OPEN 2 SESSIONS TAKEN AT 20100806222624 TO /db2/EP1 INTO EP1 NEWLOGPATH /db2/EP1/log_dir/ WITH 8 BUFFERS BUFFER 4096 REDIRECT PARALLELISM 4 SQL2529W  Warning!  Restoring to an existing database that is different from the backup image database, and the alias name "EP1" of the existing database does not match the alias name "EPD" of the backup image, and the database name "BG1" of the existing database does not match the database name "EPD" of the backup image. The target database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted. Do you want to continue ? (y/n) y   看来细心很重要啊,否则经常会遇到莫名其妙的错误,查都查不到:(

解析

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论3 条评论

hchao网站运营经理TWT
2010-08-11 09:42

2000，把之前的例子都搬出来晒晒呗！

start2000系统架构师ABB
2010-08-09 18:10

以前更多,现在做得不多了

hchao网站运营经理TWT
2010-08-09 18:08

2000的真实案例可真多！

Ctrl+Enter 发表

匿名评论

SQL2542N 错误解析

添加新评论3 条评论

作者其他文章

相关问题