Hi,

I'm just wondering if this backup/restore setup will work...we have a production db and backup db. The production db has a full backup done on the 1st Sunday of every month and an incremental for the rest of the days.

We plan to copy over the backup images (with the logs included as a part of the image) to our backup server every night and then perform a restore.

If I try the full restore and an automatic incremental restore after, it works fine but fails to successfully restore the next incremental image after that. (I'm assuming this is because an automatic incremental restore 'always' requires a full backup image restore first?)

This currently does not work ---

1.
(FULL BACKUP RESTORE -- THIS PART WORKS FINE)
db2 restore db dbname from /dir1/ taken at 20080906050002 logtarget /home/dir2/logs/

db2 rollforward db dbname to end of logs and stop overflow log path \(/home/dir2/logs\)

2.
(INCREMENTAL BACKUP RESTORE -- THIS PART WORKS FINE)
db2 restore db dbname incremental automatic from /dir1/ taken at 20080928050002 logtarget /home/dir2/logs/ REPLACE EXISTING

db2 rollforward db dbname to end of logs and stop overflow log path \(/home/dir2/logs\)

3. (INCREMENTAL BACKUP RESTORE -- THIS PART FAILS)
db2 restore db dbname incremental automatic from /dir1/ taken at 20080929050002 logtarget /home/dir2/logs/ REPLACE EXISTING

db2 rollforward db dbname to end of logs and stop overflow log path \(/home/dir2/logs\)


I'm assuming this will work (without the automatic keyword)---

1. db2 restore db dbname from /dir1/ taken at 20080906050002 logtarget /home/dir2/logs/

db2 rollforward db dbname to end of logs and stop overflow log path \(/home/dir2/logs\)

2. db2 restore db dbname incremental from /dir1/ taken at 20080928050002 logtarget /home/dir2/logs/ REPLACE EXISTING

db2 rollforward db dbname to end of logs and stop overflow log path \(/home/dir2/logs\)

3. db2 restore db dbname incremental from /dir1/ taken at 20080929050002 logtarget /home/dir2/logs/ REPLACE EXISTING

db2 rollforward db dbname to end of logs and stop overflow log path \(/home/dir2/logs\)

Please correct me if I'm wrong.. thanks!

if using incremental - you should only restore the base/full backup and last incremental backup. if using delta backup you need to restore the full and each delta. you can also use the recover command

Hi..do you mean that if you're using 'incremental automatic' then you should only restore the base/full backup and last incremental backup? I thought this method was used if using the 'automatic' option. And if I'm using simply incremental (no automatic keyword).. why won't it work if I restore each incremental backup daily? Thank you!

the incremental keeps the modifications from last backup - second incremental has data from first incremental and changes after incremental....
delta keeps modifications from last delta only

I suggest you read the manual about restoring from the incremental backup. If you don't use the AUTOMATIC keyword, you have to specify the backup images yourself in the correct order: latest incremental, full (base), first incremental, second..., last incremental. Obviously, you only do a rollforward once, when the entire restore is complete.

thanks for the replies.. am aware that if you don't use the AUTOMATIC keyword, then all the backup images between the full and last incremental must be restored in order.. the problem is that I want to do a restore of the latest incremental on a daily basis on our backup server... it seems like the delta option might work in this case?

The INCREMENTAL DELTA backups will work absolutely in the same manner as the INCREMENTAL, because they _are_ incremental.