Online or offline backup?

L Wei

Online or offline backup?
Hi,

If we want to replace our current production server with DB2 UDB 8.1 on AIX
5.3 and use redirected restore for the production databases to be “copied”
into our new db2 with server. Which backup is more appropriate for our
databases that have not too much but constant data change? Our current
database is set archieved log. We’re afraid that it could take us up to a
few days to complete the whole process including server setup DB2
installation and database restore. Online backup seem to be able to
roll-forward to the point of the latest transaction log after the backup was
made. It seems a right way to do the backup for us. However, it is saying
that “in order to restore a recoverable database (using version recovery and
roll-forward recovery), the database must be taken offline.” On the page of
http://www.phptr.com/articles/article.asp?p=169530&seqNum=3&rl=1. which
caused us confusion. We hope someone who can give us an answer.
Thanks!
Lan

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Gunning

Re: Online or offline backup?
(in response to L Wei)
A version recovery is just that, a copy of a database taken offline. An
online backup is needed to do a rollforward recovery. Most companies in the
OLTP/ERP/MIXED area need recovery to a point in time and use archival
logging to accomplish that. It really depends on what the business requires.



www.gunningts.com/db2zone.htm
610.451.5801 Fax 514-509-6886
"We help people succeed with DB2"
See us at IDUG Asia-Pacific Forum 23-24 Mar 2006 and IDUG North America,
7-11 May 2006, Tampa, Fl.
ITgain:http://www.itgain.de
GET READY TO RELEASE THE VIPER
AT:http://www-306.ibm.com/software/data/db2/udb/viper/

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of lan
Sent: Thursday, December 15, 2005 4:02 PM
To: [login to unmask email]
Subject: [DB2-L] Online or offline backup?

Hi,

If we want to replace our current production server with DB2 UDB 8.1 on AIX
5.3 and use redirected restore for the production databases to be "copied"
into our new db2 with server. Which backup is more appropriate for our
databases that have not too much but constant data change? Our current
database is set archieved log. We're afraid that it could take us up to a
few days to complete the whole process including server setup DB2
installation and database restore. Online backup seem to be able to
roll-forward to the point of the latest transaction log after the backup was
made. It seems a right way to do the backup for us. However, it is saying
that "in order to restore a recoverable database (using version recovery and
roll-forward recovery), the database must be taken offline." On the page of
http://www.phptr.com/articles/article.asp?p=169530&seqNum=3&rl=1. which
caused us confusion. We hope someone who can give us an answer.
Thanks!
Lan

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm