Recently I've done a db2 backup and restore/recovery, but the process
for recovering the database was different than what I thought to be.
here is what I did:
DB2 is set in online mode
- backup -
* backup db2 in full
* insert record
* backup db2 in incremental
* insert record
* backup db2 in delta
* run command "archive log for db abc" and three log files archived to
tape
drop the database
- restore/recovery -
* restore delta backup - read from tape
* restore incremental backup - read from tape
* restore full backup - read from tape
* restore delta backup - read from tape
rollforwarding to end of log
5 log files applied and it was much fast than I thought, during
backup, there where at least 30 log files being created and archived
to tape. Most of them were in size of about 1 GB, but the archive log
applied was very small for roll forward.
what logs being applied (needed) and why the data (delta backup) being
read twice from tape? DB2 document no where tell the process in
detail, any one can help to explain?
Thanks,
Jimmy