473,373 Members | 1,141 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,373 software developers and data experts.

Online Backup versus Offline Backup ?? What's the point ??

I have recently begun to migrate our DB2 UDB v7.2 enterprise databases
up to DB2 UDB v8.2.

One question I can't seem to understand is why would I want to run an
offline backup for a database now that the online backup includes the
necessary log files.

Is there a reason why I would need or want to go through the hassle of
getting exclusive control of a db for an offline backup?
(ps - forgive me if this is a question that lets my inexperience show
through...........)
Regards,
Richard M.

Jan 9 '06 #1
4 9435
First, you need to be careful.
The include logs option as far as I know only includes the logs that were
active from the start of the backup to the end of the backup.
For example, if the first active log is log 15 when you launch the backup
and the when you took the previous backup and finished with log 10; then,
logs 11,12,13,14 will NOT be included in your current online backup with
include logs.

Some disaster recovery strategies are easier to implement when you are
coming from an offline backup.
Given where V8.2 is, I don't see any glaring requirements for offline
backups apart from the DBA'S peace of mind!!
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ma**************@gmail.com> a écrit dans le message de news:
11*********************@o13g2000cwo.googlegroups.c om...
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases
up to DB2 UDB v8.2.

One question I can't seem to understand is why would I want to run an
offline backup for a database now that the online backup includes the
necessary log files.

Is there a reason why I would need or want to go through the hassle of
getting exclusive control of a db for an offline backup?
(ps - forgive me if this is a question that lets my inexperience show
through...........)
Regards,
Richard M.


Jan 9 '06 #2
Pierre Saint-Jacques wrote:
First, you need to be careful.
The include logs option as far as I know only includes the logs that were
active from the start of the backup to the end of the backup.
For example, if the first active log is log 15 when you launch the backup
and the when you took the previous backup and finished with log 10; then,
logs 11,12,13,14 will NOT be included in your current online backup with
include logs.
Pierre, I'd say that the logs 11 thru 14 are the data changes that are
actually backup up. Or do you mean that you still have to keep the log
files if you want to recover to a point in time that is before the current
backup?
Some disaster recovery strategies are easier to implement when you are
coming from an offline backup.
Given where V8.2 is, I don't see any glaring requirements for offline
backups apart from the DBA'S peace of mind!!


Offline backups were there first. So they won't go away so quickly.
Besides, an offline backup should run much faster because no locking issues
need to be considered. And if the environment allows to take the DB
offline, this might be important when working out the backup strategies.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 10 '06 #3
All right, I should have been clearer.
The changes in logs 11-14 are obviously in the tables as the logs are now
archivable. However, if your current online backup cannot be restored,
you'll need the previous one and also logs 11.-14 + whatever goes beyoond to
restore rollforward. And yes if you need to recover to a PIT before the
online backup, you'll need the previous image and logs 11-14 + whatever logs
are beyound to reach your PIT.

Another point that a post in this newsgroup made me think about. Sometimes,
when you need to migrate to a new version of DB2, there's seems to be a
problem in rolling forward logs of a version to another db of another
version.
Say:
Current V72+ online backups and logs
Restore to a V8.2+ system. The restore migrates the db to a V8 But...
Roll Forward has apparently reported problems in trying to roll forward a V7
log on V8 db or so the post seems to indicate.

That would be another reason why an off line backup may be needed.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Knut Stolze" <st****@de.ibm.com> a écrit dans le message de news:
dq**********@lc03.rz.uni-jena.de...
Pierre Saint-Jacques wrote:
First, you need to be careful.
The include logs option as far as I know only includes the logs that were
active from the start of the backup to the end of the backup.
For example, if the first active log is log 15 when you launch the backup
and the when you took the previous backup and finished with log 10; then,
logs 11,12,13,14 will NOT be included in your current online backup with
include logs.


Pierre, I'd say that the logs 11 thru 14 are the data changes that are
actually backup up. Or do you mean that you still have to keep the log
files if you want to recover to a point in time that is before the current
backup?
Some disaster recovery strategies are easier to implement when you are
coming from an offline backup.
Given where V8.2 is, I don't see any glaring requirements for offline
backups apart from the DBA'S peace of mind!!


Offline backups were there first. So they won't go away so quickly.
Besides, an offline backup should run much faster because no locking
issues
need to be considered. And if the environment allows to take the DB
offline, this might be important when working out the backup strategies.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


Jan 10 '06 #4
Thank you gentlemen. That is the kind of information that I need to
help decide on my strategy.

Part of my problem is that we have a number of third party applications
(such as Tivoli TEC, PeopleSoft, SmartTeam, etc.) that have been
implemented with admin ids as part of the instance group. This is the
documented requirement for some of these apps and makes a DBA's skin
crawl...............My problem is that we occassionally can't get
exclusive control for offline backups so we are flirting with the idea
of online only.

Pierre you mentioned something I heard about as well, but have
forgotten. Thank you.
Regards,
Richard McCutcheon,
Honda of Canada, Manufacturing.

Jan 12 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Arijit Chatterjee | last post by:
Dear Friends, I don't know anybody has asked this question before or not.But I need a support urgently.How to take online backup in MS Sql server 2000. Thanks Arijit Chatterjee
2
by: Trent | last post by:
Hello, all. I have the following production DB2 environment. DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003 standard edition. My first question is regard with...
16
by: andy.standley | last post by:
Hi, we are running DB2 V8.2 (8.1.0.80) on redhat linux and I am trying to set the reorg to be online. I use the control center on the box - db2cc and then configure automatic maintenance wizard -...
14
by: johnm | last post by:
Hello All, I appreciate all of the help with my previous posts. It's nice having such a knowledgeable group to draw upon for help. I have taken all of your previous suggestions to heart and...
1
by: Lan W via DBMonster.com | last post by:
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...
3
by: Konstantin Andreev | last post by:
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...
10
by: Konstantin Andreev | last post by:
Hello. Some time ago I asked in this conference, - How to use an ONLINE BACKUP to restore database onto another system? - but got no answers. Therefore I can conclude it is not possible. But......
1
by: bwmiller16 | last post by:
Folks - DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and...
3
by: alex250374 | last post by:
Hello to all, I do a backup of an online db and I changed from db cfg parameter logretain on recovery, then I made the backup full offline, what other parameters to be amended? especially I...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.