DB2数据库重定向表空间恢复实例

db2 restore database sino  into jinan3 redirect without rolling forward

db2 "set tablespace containers for 2 using (file '/opt/data/jinan3/ct/userspace1' 65536, file '/opt/data/jinan3/ct/userspace2' 65536 , file '/opt/data/jinan3/ct/userspace3' 65536, file '/opt/data/jinan3/ct/userspace4' 65536 , file '/opt/data/jinan3/ct/userspace5' 65536)"
db2 "set tablespace containers for 3 using (path '/opt/data/jinan3/ct_temp_sys_16')"
db2 "set tablespace containers for 4 using (path '/opt/data/jinan3/ct_temp_user_16')"
db2 restore db sino continue
------------实际操作的过程--------注意：重新定向的表空间位置根据实际需求自己定义-----------------------
F:/2008_1_21>db2 restore db gzk_1_5 into gzk_1 redirect without rolling forward

F:/2008_1_21>db2 "set tablespace containers for 3 using (file 'E:/db2/gzk_1/data
8/data8-1.dat' 64000, file 'e:/db2/gzk_1/data8/data8-2.dat' 64000)"
DB20000I  SET TABLESPACE CONTAINERS命令成功完成。

F:/2008_1_21>db2 "set tablespace containers for 4 using (file 'E:/db2/gzk_1/data
16/data16-1.dat' 32000)"
DB20000I  SET TABLESPACE CONTAINERS命令成功完成。

F:/2008_1_21>db2 "set tablespace containers for 5 using (file 'E:/db2/gzk_1/inde
x8/index8-1.dat' 64000)"
DB20000I  SET TABLESPACE CONTAINERS命令成功完成。

F:/2008_1_21>db2 "set tablespace containers for 6 using (file 'E:/db2/gzk_1/long
8/long8-1.dat' 64000)"
DB20000I  SET TABLESPACE CONTAINERS命令成功完成。

F:/2008_1_21>db2 "set tablespace containers for 7 using (path 'E:/db2/gzk_1/temp
8')"
DB20000I  SET TABLESPACE CONTAINERS命令成功完成。

F:/2008_1_21>db2 "set tablespace containers for 8 using (path 'E:/db2/gzk_1/temp
16')"
DB20000I  SET TABLESPACE CONTAINERS命令成功完成。

F:/2008_1_21>db2 restore db gzk_1_5 continue
DB20000I  RESTORE DATABASE命令成功完成。