db2数据库复原

最新推荐文章于 2021-12-03 17:03:23 发布

meloveself

最新推荐文章于 2021-12-03 17:03:23 发布

阅读量1.1k

点赞数

分类专栏：数据库文章标签：数据库 db2 containers path file database

本文链接：https://blog.csdn.net/meloveself/article/details/5735027

版权

数据库专栏收录该内容

19 篇文章 0 订阅

订阅专栏

db2数据库复原支持的文件类型主要有三种：裸设备、path路径、文件类型

一个表空间的大小不能超过64G.每个页大小为4K.

有时候需要将数据库架构放到数据库的安装目录，而数据库容器可以指定到其他地方。

昨天还原的原始命令为：

RESTORE DATABASE T_CENTER FROM "E:/T_CENTER" TAKEN AT 20091231124541 TO "C:" INTO T_CENTER WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING;
SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "C:/DB2/NODE0000/SQL00003");
SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "C:/DB2/NODE0000/SQL00004/SQLT0001.0");
SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "C:/DB2/NODE0000/SQL00003");
SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "C:/DB2/NODE0000/SQL00003/TSASNCA03" 512000,FILE "C:/DB2/NODE0000/SQL00003/TSASNCA01" 512000);
SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "C:/DB2/NODE0000/SQL00003/TSASNUOW" 5888);
SET TABLESPACE CONTAINERS FOR 5 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "D:/DBFILES/TSETC.01");
SET TABLESPACE CONTAINERS FOR 6 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "C:/DB2/NODE0000/SQL00003/CDA35_SYSTEMPARA" 512);
SET TABLESPACE CONTAINERS FOR 7 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "C:/DB2/NODE0000/SQL00003");
SET TABLESPACE CONTAINERS FOR 8 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "C:/DB2/NODE0000/SQL00003");
SET TABLESPACE CONTAINERS FOR 9 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "C:/DB2/NODE0000/SQL00003/TSASNCA_LZJ" 768000,FILE "C:/DB2/NODE0000/SQL00003/TSASNCA01_LZJ" 512000,FILE "C:/DB2/NODE0000/SQL00003/TSASNCA02_LZJ" 512000);
RESTORE DATABASE T_CENTER CONTINUE;

经过快通公司管伟的帮忙，将程序调整为：

RESTORE DATABASE T_CENTER FROM "E:/T_CENTER" TAKEN AT 20091231124541 TO "C:" INTO T_CENTER WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING;
SET TABLESPACE CONTAINERS FOR 0 USING (PATH "D:/T_CENTER/tablespace/0");
SET TABLESPACE CONTAINERS FOR 1 USING (PATH "D:/T_CENTER/tablespace/1");
SET TABLESPACE CONTAINERS FOR 2 USING (PATH "D:/T_CENTER/tablespace/2");
SET TABLESPACE CONTAINERS FOR 3 USING (FILE "D:/T_CENTER/TSASNCA03" 16500000);
SET TABLESPACE CONTAINERS FOR 4 USING (FILE "D:/T_CENTER/TSASNUOW" 5888);
SET TABLESPACE CONTAINERS FOR 5 USING (PATH "D:/T_CENTER/tablespace/5");
SET TABLESPACE CONTAINERS FOR 6 USING (FILE "D:/T_CENTER/CDA35_SYSTEMPARA" 512);
SET TABLESPACE CONTAINERS FOR 7 USING (PATH "D:/T_CENTER/tablespace/7");
SET TABLESPACE CONTAINERS FOR 8 USING (PATH "D:/T_CENTER/tablespace/8");
SET TABLESPACE CONTAINERS FOR 9 USING (FILE "D:/T_CENTER/TSASNCA_LZJ" 1788000);
RESTORE DATABASE T_CENTER CONTINUE;

其中主要调整的地方一是容器路径，另外一个是页面的大小。