473,856 Members | 1,630 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 9485
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************* ********@o13g20 00...legro ups.com...
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**********@lc 03.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
5600
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
3693
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 locking. I found some escalations for X lock on some tables. How do I work out an appropriate MAXLOCK & LOCKTIMEOUT settings to optimize the lock escalation issue.
16
5473
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 - and can get runstats to be online but reorg only offers offline at the activities settings. I have tried to understand why - I thought that online was always offered ? I think that all my indexes are type 2 - I ran some reorg indexes all on the...
14
2051
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 have upgraded our DB/2 system to 8.2. However, I still have a problem with backup times and backup window size.
1
2701
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 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...
3
2519
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 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
10
3189
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... what can I do with "online backup", really ? What is it needed for ? I do not see any possibility to use this backup. Please, share your knowledge, if you can. Yes, I've read that since version 8.2 there is an option "INCLUDE LOSG" for "online...
1
2695
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 FixPak "9". Product is installed at "/opt/IBM/db2/V8.FP9". Red Hat AS 4 / fastT700 San 4400
3
2503
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 wonder how it should change the parameters logarchmeth1 / default 3)and 2 (default 2) and the path of arch logs so I created a special filesustem. Thanks
0
9918
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9763
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10697
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10786
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9532
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7097
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5959
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4578
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4175
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.