以下的文章主要描述的是实现DB2数据库复原的实际操作，我们首先是从对其在实际操作中要用到的实际操作代码的描述，我们大家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;
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
经过快通公司管伟的帮忙，将程序调整为：
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;
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
其中主要调整的地方一是容器路径，另外一个是页面的大小。
以上的相关内容就是对DB2数据库复原的介绍，望你能有所收获。
【编辑推荐】
