Restore Method - Delta and Incremental Backups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anurag - 24 Dec 2004 05:17 GMT

Hello,
I wish to find out the restore method for database that have been
incrementally backed up and in the scenario where just the delta has
been backed up.
For example sake, let us assume the following 2 scenarios:

(1) Delta Backup of database "delta_db"
Full offline backup of database "delta_db" is taken on Dec 15 and then
offline delta backup is taken every day till Dec 19. If "delta_db"
crashes on Dec 20, what steps do I follow (pl mention relevant keywords
also) to restore this db?

(2) Incremental Backup of database "incre_db"
Full offline backup of database "incre_db" is taken on Dec 15 and then
"incre_db" is backed up incrementally Dec 19. If "incre_db" crashes on
Dec 20, what steps do I follow (pl mention relevant keywords also) to
restore this db?

Any links to redbooks / technote / relevant URL for restore method
would also be useful.

Regards............anurag

Reply to this Message

Ian - 24 Dec 2004 06:03 GMT

> Hello,
> I wish to find out the restore method for database that have been
[quoted text clipped - 16 lines]
> Any links to redbooks / technote / relevant URL for restore method
> would also be useful.

This is documented clearly in the manuals. Search for INCREMENTAL and/
or DELTA.

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

Reply to this Message

Pierre Saint-Jacques - 24 Dec 2004 18:11 GMT

In each case, mount the backup image you want to restore to which should
be the one closest to Dec. 20. This is irrespective of the state,
incr_delta, Incr_full or full image. Write down the timestamp of the
backup image (You can get it from the recovery history file).
Issue the command
db2ckrst -d <dbname> -t yyymmmdddhhmmss -r database

The ouuput will list for you which images need to be restored and in
which sequence.

Your only Command Reference shows the command and even has examples.<
HTH, Pierre.

> Hello,
> I wish to find out the restore method for database that have been
[quoted text clipped - 18 lines]
>
> Regards............anurag

Signature

Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Reply to this Message

Stanley Sinclair - 28 Dec 2004 23:18 GMT

Can't exactly remember now. . . Wasn't there something new in 8.2, or
about to happen, where one can specify the restore timestamp (of the
last full backup) and db2 restores all necessary subsequent partial
backups and logs (roll-forward)?

Or was that an optimistic dream?

(Gotta quit that peyote stuff . . .)

SS

> In each case, mount the backup image you want to restore to which should
> be the one closest to Dec. 20. This is irrespective of the state,
[quoted text clipped - 36 lines]
> IBM DB2 Cerified Solutions Expert - Administration
> SES Consultants Inc.

Reply to this Message

Ian - 28 Dec 2004 23:35 GMT

> Can't exactly remember now. . . Wasn't there something new in 8.2, or
> about to happen, where one can specify the restore timestamp (of the
> last full backup) and db2 restores all necessary subsequent partial
> backups and logs (roll-forward)?

Yes, this is the RECOVER DATABASE command, which takes the place of
RESTORE/ROLLFORWARD.

Reply to this Message

Pierre Saint-Jacques - 29 Dec 2004 19:18 GMT

I think it's about to happen. I don't remember from reading the what'S
new stuff about doing this automatically.
But then again, old age may be creeping on me and I could have not
noticed that function.

Given the temperature here, peyote is definetely not available but you
may remember that we do have liquid stuff that can be very potent. Does
caribou ring any bells??
Happy New Year and may DB2 do what you want it to do as opposed to what
you tell it to do!
Regards, Pierre.

> Can't exactly remember now. . . Wasn't there something new in 8.2, or
> about to happen, where one can specify the restore timestamp (of the
[quoted text clipped - 68 lines]
>>IBM DB2 Cerified Solutions Expert - Administration
>>SES Consultants Inc.

Signature

Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Reply to this Message