DB2 Incremental Restore

A DB2 Incremental Restore recovery strategy requires:

a)       The full backup image

b)       0 or more incremental backup

c)       The days logs

 The db2ckrst utility parses the history file and allows you to source the relevant backup images.

 Method 1 -  Automatic Restore of Incremental Backup

 db2 RESTORE DB MYDB INCREMENTAL AUTOMATIC TAKEN AT <time_last_incremenatl_backup>

 The INCREMENTAL AUTOMATIC , attempts the restore automatically. Based on the history file information.  DB2 will manage finding the last backup with a full copy of the tablespaces and then apply subsequent incremental changes.

Method 2 -  Manual Restore of Incremental backup 

1)       Mount the backup image you want to restore , closest to the date you’re trying to restore. Refer to this image as the target image

2)       Issue a db2ckrst MyDB –t yyymmmdddhhmmss –r database

3)       This command issues a list of images to restore and the order of restore

4)   Apply any logs

An example: 

#Step 1
db2 RESTORE db mydb INCREMENTAL TAKEN AT 
#Step 2
db2 RESTORE db mydb INCREMENTAL TAKEN AT 
#Step 3
#continue repeating this step for every incremental including step 1
db2 RESTORE db mydb INCREMENTAL TAKEN AT 

See Also

DB2 – Restore database from a ONLINE backup

DB2 backup online summary