By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,933 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,933 IT Pros & Developers. It's quick & easy.

Online backup to restore onto another system (or for disaster recovery): how to?

P: n/a
Hello, everybody.

I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with
Examples", but still unable to answer this simple question.

I need to perform the full database backup for at least these two goals:

- to restore data onto developers' database system.
- to ensure disaster recovery

I can't perform the "OFFLINE" backup because database must be available 24x7. Also, "INCLUDE LOGS" option is not available in
database, because its version is 8.1 ( on Windows platform ).

But everybody knows, the "BACKUP ONLINE" database image is good-for-nothing by itself, it requires some logs to be restored.

Help, please. What should I do for this database image (backup online) could be restored in workable state onto another system ?
--
Konstantin Andreev.
Aug 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Perform a re-directed restore into the development database - the
database will remain in rollforward pending as it is an online backup.
You can attempt to take the database out of RF pending,
by...rollforward database DBNAME complete...you may well get an error,
as a log/or logs are required (DB2 will advise which one).
Keep in mind the rollforward query status command is also useful, to
determine which log is requried.

Konstantin Andreev wrote:
Hello, everybody.

I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with
Examples", but still unable to answer this simple question.

I need to perform the full database backup for at least these two goals:

- to restore data onto developers' database system.
- to ensure disaster recovery

I can't perform the "OFFLINE" backup because database must be available 24x7. Also, "INCLUDE LOGS" option is not available in
database, because its version is 8.1 ( on Windows platform ).

But everybody knows, the "BACKUP ONLINE" database image is good-for-nothing by itself, it requires some logs to be restored.

Help, please. What should I do for this database image (backup online) could be restored in workable state onto another system ?
--
Konstantin Andreev.
Aug 20 '06 #2

P: n/a

Konstantin Andreev wrote:
Hello, everybody.

I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with
Examples", but still unable to answer this simple question.

I need to perform the full database backup for at least these two goals:

- to restore data onto developers' database system.
- to ensure disaster recovery

I can't perform the "OFFLINE" backup because database must be available 24x7. Also, "INCLUDE LOGS" option is not available in
database, because its version is 8.1 ( on Windows platform ).

But everybody knows, the "BACKUP ONLINE" database image is good-for-nothing by itself, it requires some logs to be restored.

Help, please. What should I do for this database image (backup online) could be restored in workable state onto another system ?
--
Konstantin Andreev.
Hi,
execute in production environment:

list history backup since yyyyMMDD for DBNAME

and look first and last logs information.

Copy all logs between first and last to development environment
(database log directory), with database in rollforward pending state.
You need al least this logs (plus your backup image) to restore your
database.

Execute in development environment:

rollforward deatabase DBNAME to end of logs and stop
Mel.

Aug 21 '06 #3

P: n/a
If you're at V8.1 below Fix Pack for 8.2, and you are archiving your logs
somewhere, the DB2 ARCHIVE LOGS command is still available.
Do your online backup
use: db2 archive log command

One of the things it will do is "cut" the last archive log when the backup
finished.
db2 list history backup will show you this for that backup entry: first and
last log active as the backup finished.

You now know which logs to bring to the target system. In V8.2 the online
backup command does this automatically unless you tell it not to.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"graham_martin" <gr***********@uk.ibm.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...
Perform a re-directed restore into the development database - the
database will remain in rollforward pending as it is an online backup.
You can attempt to take the database out of RF pending,
by...rollforward database DBNAME complete...you may well get an error,
as a log/or logs are required (DB2 will advise which one).
Keep in mind the rollforward query status command is also useful, to
determine which log is requried.

Konstantin Andreev wrote:
>Hello, everybody.

I've spent a lot of time reading "DB2 Information Center" and Raul
Chong's book "Understanding DB2. Learning Visually with
Examples", but still unable to answer this simple question.

I need to perform the full database backup for at least these two goals:

- to restore data onto developers' database system.
- to ensure disaster recovery

I can't perform the "OFFLINE" backup because database must be available
24x7. Also, "INCLUDE LOGS" option is not available in
database, because its version is 8.1 ( on Windows platform ).

But everybody knows, the "BACKUP ONLINE" database image is
good-for-nothing by itself, it requires some logs to be restored.

Help, please. What should I do for this database image (backup online)
could be restored in workable state onto another system ?
--
Konstantin Andreev.
Aug 21 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.