重定向还原问题 [英] Redirected restore problem

问题描述

我搜索了这个小组的答案并尝试了回复。


我正在尝试使用我们的生产服务器上的完整在线备份和

申请它到我们的测试服务器。制作服务器中的表空间

在驱动器上，我的测试服务器没有驱动器。


我正在使用的恢复命令是：


RESTORE DATABASE CENTRAL FROM" C：\ DB2Backups"采取20050620000000

INTO CENT0620 REDIRECT;


SQL1277N恢复检测到一个或多个表空间容器



无法访问，或已将其状态设置为''存储必须定义''。

DB20000I RESTORE DATABASE命令成功完成。


消息按预期。然后我发出SET TABLESPACE命令，然后我就获得：


db2 => SET TABLESPACE CONTAINER for 4 USING（PATH" CMPDEFAULT.DATA"）

DB21034E该命令作为SQL语句处理，因为它是

而不是

有效的命令行处理器命令。在SQL处理期间它返回了
：

SQL1350N应用程序处于这个

请求的状态不正确。

原因代码=" 3"。


任何帮助都将不胜感激!!


谢谢，


克里斯

I have searched this group for answers and tried the responses.

I am trying to Use an full online backup from our production server and
apply it to our test server. The Tablespaces in the productions server
are on the d drive and my test server has no d drive.

The restore command i am using is:

RESTORE DATABASE CENTRAL FROM "C:\DB2Backups" TAKEN AT 20050620000000
INTO CENT0620 REDIRECT;

SQL1277N Restore has detected that one or more table space containers
are
inaccessible, or has set their state to ''storage must be defined''.
DB20000I The RESTORE DATABASE command completed successfully.

message as expected. I then go to issue SET TABLESPACE commands and I
get:

db2 => SET TABLESPACE CONTAINER FOR 4 USING (PATH "CMPDEFAULT.DATA")
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1350N The application is not in the correct state to process this
request.
Reason code="3".

Any help would be greatly appreciated!!

thanks,

Chris

推荐答案

对不起，我忘记了基本知识：


备份来自win32上的UDB worlgroup 8.1.7（2003服务器）


在win32上恢复UDB worlgroup 8.1.7（XP专业版）

>
我也尝试在win32（XP专业版）上恢复8.1.9同样的

结果


谢谢，


Chris

I am sorry i forgot the basics:

Backup came from UDB worlgroup 8.1.7 on win32 (2003 server)

Restore is going on UDB worlgroup 8.1.7 on win32 (XP Pro)

I have also tried the restore on 8.1.9 on win32 (XP pro) with the same
results

thanks,

Chris

尝试在in set tablespace命令中给出完整路径。

Try giving the full path in your in set tablespace command.

我也尝试过。同样的结果。

I did try that too. Same result.

这篇关于重定向还原问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！