DB2增量备份恢复

Question

我们在WindowsServer2008R2.上使用IBMServer10.1

我试着测试DB2的恢复计划。

1. 我创建一个新的数据库

CREATE DATABASE EAPOTEST AUTOMATIC STORAGE YES ALIAS EAPOBLOB

1. Craate BufferPool和表空间

CREATE BUFFERPOOL "BufferPool32" IMMEDIATE ALL DBPARTITIONNUMS SIZE AUTOMATIC NUMBLOCKPAGES 0 PAGESIZE 32 K

CREATE REGULAR TABLESPACE "tablespace1"
IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
PAGESIZE 32 K
MANAGED BY AUTOMATIC STORAGE
AUTORESIZE YES
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL "BufferPool32"
OVERHEAD 10.5
TRANSFERRATE 0.14
DATA TAG NONE
USING STOGROUP "IBMSTOGROUP"
FILE SYSTEM CACHING

1. 创建两个简单的表。

CREATE TABLE "DB2ADMIN"."ARTIFACT_FILE1" ( "FILE_ID" DECIMAL(10 , 0) NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9999999999 NO CYCLE CACHE 20 NO ORDER ),"FILE_TYPE" VARCHAR(1) NOT NULL) DATA CAPTURE NONE IN "tablespace1" COMPRESS NO

CREATE TABLE "DB2ADMIN"."EA_PACKAGE1" (
"DOSSIER_NUMBER" VARCHAR(50) NOT NULL 
)
DATA CAPTURE NONE 
IN "tablespace1"
COMPRESS NO

1. 每个表加一行。
2. 启用增量备份

UPDATE DATABASE CONFIGURATION FOR EAPOTEST USING TRACKMOD YES

1. 准备完全脱机备份。

BACKUP DATABASE EAPOTEST TO %DB_PATH_BACKUP% COMPRESS EXCLUDE LOGS WITHOUT PROMPTING

1. 在此之后，我对数据库进行了一些更改，并进行了脱机增量备份。

BACKUP DATABASE EAPOTEST INCREMENTAL TO %DB_PATH_BACKUP% COMPRESS EXCLUDE LOGS WITHOUT PROMPTING

1. 删除数据库。

DROP DATABASE EAPOTEST

1. 恢复全速支援。，Ok，

RESTORE DB EAPOTEST FROM "..." TAKEN AT ... REPLACE HISTORY FILE WITHOUT PROMPTING

1. 恢复增量备份。

RESTORE DATABASE EAPOTEST INCREMENTAL FROM "..." TAKEN AT ... WITHOUT PROMPTING

消息是: SQL2540WВосстановлениеуспешно，однакоприработеутилиты数据库"2539".

Dtabese是不可访问的！当我试图连接：SQL1119N SQLSTATE=57019

这种可行的备份方法，我们是否采取了足够的备份和恢复步骤？

Answer 1

你的程序不对。您的第一个还原应该引用目标增量映像。

RESTORE DATABASE ... INCREMENTAL FROM "..." TAKEN AT <incremental backup timestamp>
RESTORE DATABASE ... INCREMENTAL FROM "..." TAKEN AT <full backup timestamp>
RESTORE DATABASE ... INCREMENTAL FROM "..." TAKEN AT <incremental backup timestamp>

在手册中非常详细地解释了这一点。