银行数据库
如何在部分数据库表空间重建后恢复余下的表空间
做了个简单的实验，想用testdb1的完整备份用rebuild的方式恢复部分表空间至testdb12，再用testdb1的完备来恢复前面未恢复的表空间，但是在做后一步的时候，一直报SQL2560N错误，具体见下面的摘要，不知哪里有问题
>db2 "restore db testdb1 rebuild with all tablespaces in database except
tablespace (USERSPACE1) from E:fordb2testbackup taken at
20110105085934 into testdb12"
DB20000I RESTORE DATABASE命令成功完成。
>db2 "rollforward db testdb12 to end of logs and stop"
SQL1271W 恢复了数据库 "TESTDB12"，但一个或多个表空间在节点 "0" 上已脱机。
>db2 "restore db testdb1 tablespace (USERSPACE1) from
E:fordb2testbackup taken at 20110105085934 into testdb12"
SQL2560N 对于从表空间级别备份的复原，目标数据库与源数据库不完全相同。
>db2 "restore db testdb1 rebuild with all tablespaces in database except
tablespace (USERSPACE1) from E:fordb2testbackup taken at
20110105085934 into testdb12"
DB20000I RESTORE DATABASE命令成功完成。
>db2 "rollforward db testdb12 to end of logs and stop"
SQL1271W 恢复了数据库 "TESTDB12"，但一个或多个表空间在节点 "0" 上已脱机。
>db2 "restore db testdb1 tablespace (USERSPACE1) from
E:fordb2testbackup taken at 20110105085934 into testdb12"
SQL2560N 对于从表空间级别备份的复原，目标数据库与源数据库不完全相同。
3同行回答
simply you can't do that, once database is restored using specific tablespaces, you can't restore other tablespaces into it, you need to start a brand new restore to another database, with all expected tablespaces收起
浏览375
回复 3# wangzhonnew
Hi Tao, not sure about this. See below link
http://it.toolbox.com/blogs/db2luw/recover-database-from-only-tablespace-backups-10194收起
Hi Tao, not sure about this. See below link
http://it.toolbox.com/blogs/db2luw/recover-database-from-only-tablespace-backups-10194收起
浏览422