DB2 Incremental Restore

19 February,2012 by Jack Vamvas

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

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 Incremental Restore

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright