备份文件大小 28.1 G,9.7的DB2,Windows Server 2003 64位的服务器
执行重定向恢复的命令:
db2 restore database topicis into topicis redirect
db2 set tablespace containers for 0 using (file 'D:topsystemsystemspace1' 51200)
db2 set tablespace containers for 1 using (file 'D:topuserTEMPSPACE1' 51200)
db2 set tablespace containers for 2 using (file 'D:topuserUSERSPACE1'51200)
db2 set tablespace containers for 3 using (file 'D:topsystemSYSTOOLSPACE' 1024)
db2 set tablespace containers for 4 using (file 'D:topuserUSERSPACE4_1' 750000, file 'D:topuserUSERSPACE4_2' 750000, file 'D:topuserUSERSPACE4_2_1' 768000,file 'D:topuserUSERSPACE4_3' 1024000,file 'D:topuserUSERSPACE4_4' 1024000,file 'D:topuserUSERSPACE4_5' 1024000)
db2 set tablespace containers for 5 using (path 'D:topuserUSERSPACE8')
db2 set tablespace containers for 6 using (path 'D:topuserUSERSPACE16')
db2 set tablespace containers for 7 using (file 'D:topuserUSERSPACE32' 150000)
db2 set tablespace containers for 8 using (path 'D:topuserUSERTEMPSPACE')
db2 set tablespace containers for 9 using (path 'D:topsystemTOPSYSTEMPSPACE')
db2 set tablespace containers for 10 using (path 'D:topsystemSYSTOOLSTMPSPACE')
db2 restore database topicis continue
查看恢复的进度:
D:>db2 list utilities show detail
标识 = 4
类型 = RESTORE
数据库名称 = TOP
分区号 = 0
描述 = db
开始时间 = 2012-08-27 12:26:59.060584
状态 = 执行
调用类型 = 用户
进度监视:
已完成的工作 = 83910656 bytes
开始时间 = 2012-08-27 12:26:59.060593
一个小时 后,再次查看 恢复的进度,还是 83910656 bytes,
不知道为什么这么慢,会不会跟 tablespace containers for 4 这个表空间容器大小不一致有关系?
附件是 从开始恢复的时间,抓取的日志
附件:
diag.txt (271.33 KB)
收起