Thread: Online or offline backup?
12-15-05, 16:07 #1Registered User
- Join Date
- Feb 2005
Unanswered: Online or offline backup?
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/articl...&seqNum=3&rl=1. which caused us confusion. We hope someone who can give us an answer.
12-16-05, 03:54 #2Registered User
- Join Date
- Nov 2004
if you have the backup file (online backup) and log files, you can restore a db and rollforward the transactions through the available logfiles, as far as available in the shipped/copied logs. transactions that are not finished in available logs will not be appliedBest Regards, Guy Przytula
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified