db2 redirect restore

最新推荐文章于 2020-12-24 11:31:34 发布

guoyanxi

最新推荐文章于 2020-12-24 11:31:34 发布

阅读量225

点赞数

分类专栏： db2 文章标签：数据库

本文链接：https://blog.csdn.net/guoyanxi/article/details/84274887

版权

db2 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

same machine
online backup include logs
from db2inst1 to db2inst2


db2 "restore db sample from '/test' on '/home/db2inst2'  into sample LOGTARGET '/home/db2inst2/db2inst2/NODE0000/SQL00001/SQLOGDIR/' REDIRECT"

--db2 "set tablespace containers for 0 using (file '/home/db2inst2/db2inst2/NODE0000/SAMPLE/T0000000/C0000000.CAT' 20000)"
--db2 "set tablespace containers for 3 using (file '/home/db2inst2/db2inst2/NODE0000/SAMPLE/T0000003/C0000000.LRG' 20000)"
--db2 "set tablespace containers for 4 using (file '/home/db2inst2/db2inst2/NODE0000/SAMPLE/T0000004/C0000000.LRG' 20000)"
--db2 "set tablespace containers for 5 using (path '/home/db2inst2/db2inst2/NODE0000/SAMPLE/T0000005/')"
db2 "set tablespace containers for 6 using (file '/home/db2inst2/db2inst2/NODE0000/SAMPLE/TS1.CTN' 20000)"

db2 RESTORE DATABASE SAMPLE CONTINUE

db2 rollforward db sample to end of logs;
db2 rollforward db sample complete