Mutlipartition - online backup / restore and roll forward

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

beena - 01 Jul 2007 17:21 GMT

Hi All,
I'm familiar with the restore of single partition online backup
taken with INCLUDE LOGS.
Also familiar with the restore of multipartition using offline
backup...

We are in the process of implementing online backup for the first time
in a multipartition environment.....
db2level is as follows.......
Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and
FixPak "8".Product is installed at "/usr/opt/db2_08_01".

LOGARCHMETH1 to 'DISK: /db2backup/LOGARCHIVE'.

Just realized that INCLUDE LOGS is not an option in the backup stmt in
multipartition environment....

I have the following questions......
1. How to determine the logs needed to restore the online backup
taken without the INCLUDE LOGS option?
2. What will be the syntax of the rollforward command with the log
files of multi partitions ? (Yes I know that the roll forward
command has to be issued from catalog partition)...

Any thoughts/help is appreciated much

Thank you in advance
- beena

Reply to this Message

Ian - 02 Jul 2007 08:49 GMT

> Just realized that INCLUDE LOGS is not an option in the backup stmt in
> multipartition environment....
>
> I have the following questions......
> 1. How to determine the logs needed to restore the online backup
> taken without the INCLUDE LOGS option?

You can get this from the recovery history for each partition -- the
backup entries in the history will show which log files were in use
(again, for each partition).

> 2. What will be the syntax of the rollforward command with the log
> files of multi partitions ? (Yes I know that the roll forward
> command has to be issued from catalog partition)...

It's no different than for a single partition, unless you have to define
a unique overflow log path for each partition.

Reply to this Message