473,735 Members | 1,992 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What is ONLINE BACKUP intended for ? Is it fake feature ?

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 backup". With this option "online backup" looks getting usable. But before v8.2 "online backup" looks absolutly unusable, fake feature. Please, correct me If I wrong.
--
Konstantin Andreev.
Aug 21 '06 #1
10 3176
Online Backup is the ability to take a backup image copy without having
to take the database offline. I'm not sure what you mean by "fake
feature" ... online backup is used by a multitude of customers ... in
fact, it is normally preferred over offline backup because you don't
have to take the database offline. Unless I'm misunderstandin g, I can't
see how you can say that it is a fake feature ... a backup is a basic
tenet of recovery strategy that most (if not all) customers need and use.

Larry Edelstein

Konstantin Andreev wrote:
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 backup". With this option "online backup" looks getting
usable. But before v8.2 "online backup" looks absolutly unusable, fake
feature. Please, correct me If I wrong.
--
Konstantin Andreev.
Aug 21 '06 #2
Larry wrote:
Online Backup is the ability to take a backup image copy without having to take the database offline. I'm not sure what you mean by "fake feature" ... online backup is used by a multitude of customers ... in fact, it is normally preferred over offline backup because you don't have to take the database offline.
My trouble is - I can't invent any workable scenario with online backup. For instance:

Scenario A
----------
1) I issue "BACKUP ONLINE" and move backup image into safe location.
2) Database system is burned out due fire in a building.
2) Backup image is here, but restoring from is *NOT* possible, because no logs. My backup is effectively the "fake".

Scenario B
----------
1) I issue "BACKUP ONLINE".
2) I change something in database
3) I want to revert the database to the state at the backup time, but it's *NOT* possible, because I *must* roll forward all logs. My backup is useless again.

Scenario C
----------
1) I issue "BACKUP ONLINE".
2) I change something in database
3) Unce upon a time a want to create some "restore point", for rolling forward could stop there. Therefore I must *QUIESCE* the database. But quiesce database is the same as OFFLINE from the users' point of view.
When in 1994 Microsoft started reselling Sybase ASE as it's pioneering SQL Server (v. 4.21) the simple tasks were already done simple. I just wrote "dump database db01 to device", and I was sure it's consistent and capable to be restored.

With DB2 the simple tasks tends getting more and more complicated. I've already spent the enormous amount of time trying to make the workable online backup. Please, direct me to the right way to proceed...
--
Konstantin Andreev.
Aug 21 '06 #3
You are confusing operational issues with a very simple technical issue
that you need logs to move forward from a restore:

Scenario A: Apply scenario A to your SQL Server dump example and you
have the same issue. The point in time dump doesn't magically
incorporate new data as time passes.
Scenario B: Why anyone would use a restore operation to undo a
database change is beyond me. One doesn't fix bad form with
BACKUP/RESTORE, they fire the person who tries to ;-)
Scenaro C: This is just a modified scenario B.


You need the logs. E
Konstantin Andreev wrote:
Larry wrote:
Online Backup is the ability to take a backup image copy without having to take the database offline. I'm not sure what you mean by "fake feature" ... online backup is used by a multitude of customers ... in fact, it is normally preferred over offline backup because you don't have to take the database offline.

My trouble is - I can't invent any workable scenario with online backup. For instance:

Scenario A
----------
1) I issue "BACKUP ONLINE" and move backup image into safe location.
2) Database system is burned out due fire in a building.
2) Backup image is here, but restoring from is *NOT* possible, because no logs. My backup is effectively the "fake".

Scenario B
----------
1) I issue "BACKUP ONLINE".
2) I change something in database
3) I want to revert the database to the state at the backup time, but it's *NOT* possible, because I *must* roll forward all logs. My backup is useless again.

Scenario C
----------
1) I issue "BACKUP ONLINE".
2) I change something in database
3) Unce upon a time a want to create some "restore point", for rolling forward could stop there. Therefore I must *QUIESCE* the database. But quiesce database is the same as OFFLINE from the users' point of view.
When in 1994 Microsoft started reselling Sybase ASE as it's pioneering SQL Server (v. 4.21) the simple tasks were already done simple. I just wrote "dump database db01 to device", and I was sure it's consistent and capable to be restored.

With DB2 the simple tasks tends getting more and more complicated. I've already spent the enormous amount of time trying to make the workable online backup. Please, direct me to the right way to proceed...
--
Konstantin Andreev.
Aug 21 '06 #4
If you read your documentation carefully, you find:
To do online backup your database must be roll forward enabled. This means
that you have the "capability " to keep your logs and decide to archive them
on the server or somewhere else if you want/need to.
You will also find that online backup "requires" you to, when you restore,
to roll forward at least to to the timestamp of the end of the backup.

Therefore, if you manage your logs properly with your backup image, you can
restore under all conditions that an offline backup offers and gain the
advantage of not putting the db offline when you backup.
The techniqur of backing up online and providing logs to restore has been
available from at least DB2 V7.2.

Your scenarios imply that you make changes to iether the server and/or the
date after the backup. It would suppose that logs would be available to
restore the db and bring it to a point odf consistency?

Hope this helps, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Konstantin Andreev" <pl**********@d atatech.rua écrit dans le message de
news: ec**********@dn s.comcor.ru...
Larry wrote:
Online Backup is the ability to take a backup image copy without having
to take the database offline. I'm not sure what you mean by "fake
feature" ... online backup is used by a multitude of customers ... in
fact, it is normally preferred over offline backup because you don't
have to take the database offline.

My trouble is - I can't invent any workable scenario with online backup.
For instance:

Scenario A
----------
1) I issue "BACKUP ONLINE" and move backup image into safe location.
2) Database system is burned out due fire in a building.
2) Backup image is here, but restoring from is *NOT* possible, because no
logs. My backup is effectively the "fake".

Scenario B
----------
1) I issue "BACKUP ONLINE".
2) I change something in database
3) I want to revert the database to the state at the backup time, but it's
*NOT* possible, because I *must* roll forward all logs. My backup is
useless again.

Scenario C
----------
1) I issue "BACKUP ONLINE".
2) I change something in database
3) Unce upon a time a want to create some "restore point", for rolling
forward could stop there. Therefore I must *QUIESCE* the database. But
quiesce database is the same as OFFLINE from the users' point of view.
When in 1994 Microsoft started reselling Sybase ASE as it's pioneering SQL
Server (v. 4.21) the simple tasks were already done simple. I just wrote
"dump database db01 to device", and I was sure it's consistent and capable
to be restored.

With DB2 the simple tasks tends getting more and more complicated. I've
already spent the enormous amount of time trying to make the workable
online backup. Please, direct me to the right way to proceed...
--
Konstantin Andreev.
Aug 21 '06 #5
21 Aug 2006, ts******@gmail. com wrote:
You are confusing operational issues with a very simple technical issue that you need logs to move forward from a restore:
Scenario A: Apply scenario A to your SQL Server dump example and you have the same issue. The point in time dump doesn't magically incorporate new data as time passes.
No need to incorporate later updates. From the dummy point of view:
- I make a backup
- I copy backup image to CD or DVD and put it in my pocket.
- I'm sure I have at least these data if my computer system is shooted with machine-gun.
Scenario B: Why anyone would use a restore operation to undo a database change is beyond me.
For example, you need to make the regression test of new version of application. Imagine Oracle/Peoplesoft issue an update of their ERP system. You would not blindly update your enterprise production system.
Another example is a diagnostic of complex application where you suspect a bug. You will need multiple runs against same data.
You need the logs.
It seems I can formulate correct question. Could you, please, read my answer to Pierre, just not to duplicate one here ?
Thank you.
--
Konstantin Andreev.
Aug 22 '06 #6
21 Aug 2006, 20:33:03, Pierre Saint-Jacques wrote:
If you read your documentation carefully, you find: To do online backup your database must be roll forward enabled.
Sure.
This means that you have the "capability " to keep your logs and decide to archive them on the server or somewhere else if you want/need to. You will also find that online backup "requires" you to, when you restore, to roll forward at least to to the timestamp of the end of the backup. Therefore, if you manage your logs properly with your backup image, you can restore under all conditions that an offline backup offers and gain the advantage of not putting the db offline when you backup.
Thank you, Pierre, this sounds reasonably. The simular discussions I have read in the various DB2 docs (Information Center, Data recovery guide, Raul F. Chong's book). But I can not find a workable invention from these discussions.

Maybe you could better help me by the example ? Let I

1) just issued "BACKUP ONLINE"
2) copyied backup image to DVD and put it in my pocket
3) ---- (unknown) ----- !!!

What else should I copy to DVD to be able to restore the database from backup in my pocket ?

The real database log's configuration ( from "get db config" CLP command ) :
LOGPRIMARY = 10
LOGSECOND = 118
LOGRETAIN = RECOVERY
USEREXIT = OFF
First active log file = S0006087.LOG
For now ( just after issuing BACKUP ONLINE ) the database log directory contains 22 log files: S0006075.LOG ... S0006096.LOG.

Theoretically, I should ask the database system to copy-out the active part of log to make my backup consistent. But what should I do in actual fact ?

Thank you in advance.
--
Konstantin Andreev.
Aug 22 '06 #7
Konstantin,

for a better handling of archive log files you need to activate the
userexit, a program that will copy the logs to another destination.
Follow this link for a guide:
http://publib.boulder.ibm.com/infoce...n/c0006086.htm

After installing the userexit you activate the archive logging with
"db2 update dbm cfg using userexit yes"

According to your example you create the online backup and copy it
together with the necessary archive log files to your dvd. How to know
what files are necessary?
Issue "db2ckbkp -H [Backupfile]", you need all archive log files since
the timestamp (see output of db2ckbkp)!

HTH, Oliver.

Aug 22 '06 #8
"Konstantin Andreev" <pl**********@d atatech.ruwrote in message
news:ec******** **@dns.comcor.r u...
Thank you, Pierre, this sounds reasonably. The simular discussions I have
read in the various DB2 docs (Information Center, Data recovery guide,
Raul F. Chong's book). But I can not find a workable invention from these
discussions.

Maybe you could better help me by the example ? Let I

1) just issued "BACKUP ONLINE"
2) copyied backup image to DVD and put it in my pocket
3) ---- (unknown) ----- !!!

What else should I copy to DVD to be able to restore the database from
backup in my pocket ?

The real database log's configuration ( from "get db config" CLP command )
:
LOGPRIMARY = 10
LOGSECOND = 118
LOGRETAIN = RECOVERY
USEREXIT = OFF
First active log file = S0006087.LOG
For now ( just after issuing BACKUP ONLINE ) the database log directory
contains 22 log files: S0006075.LOG ... S0006096.LOG.

Theoretically, I should ask the database system to copy-out the active
part of log to make my backup consistent. But what should I do in actual
fact ?

Thank you in advance.
--
Konstantin Andreev.
If you use the INCLUDE LOGS keywords in the backup command, then you have
all the logs that were active during the on-line backup built into the
backup image, and you don't need anything else on your CD. I would also use
the COMPRESS keyword, to keep the backup to the minimum size possible.
Including the logs active during the backup in the backup image will enable
you to restore and roll the logs forward (which is mandatory) to the end of
the backup timestamp. If you are not sure what timestamp to roll the logs
forward to, just use a fictitious timestamp in the past, and DB2 will tell
you the minimum timestamp you must use in the roll forward command.

If you take an offline backup, you do not need to include any logs, and you
do not need to roll forward.
Aug 22 '06 #9
22.08.2006 22:18, Mark A wrote:
"Konstantin Andreev" <pl**********@d atatech.ruwrote in message news:ec******** **@dns.comcor.r u...
>Maybe you could better help me by the example ? Let I
1) just issued "BACKUP ONLINE"
2) copyied backup image to DVD and put it in my pocket
3) ---- (unknown) ----- !!!

What else should I copy to DVD to be able to restore the database from backup in my pocket ?
If you use the INCLUDE LOGS keywords in the backup command, then you have all the logs that were active during the on-line backup built into the backup image, and you don't need anything else on your CD.
Sorry, Mark, I misled you unintentionally . I did not mention in this thread I have DB2 version 8.1 which does not support "INCLUDE LOGS". My perplexity concerning online backup persists.

Indeed, what could be done ? Copy the whole bunch of current log files ( the whole log space ) to backup device (DVD) ? But...

- they are in use by database. I'm not sure that copying such files at filesystem level wouldn't break them.
- it's absurdly silly waste of space. At least all primary log space would be copied, even though *ACTIVE* part of logs IS zero, or close to zero.

Meanwhile I continue the daily denial of service to my users, because I obliged to perform the *offline* backup.
--
Konstantin Andreev.
Aug 24 '06 #10

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

Similar topics

10
3409
by: Greener | last post by:
Hi, I need help badly. Can you do client-side programming instead of server-side to capture the Browser type info? If this is the case, what's wrong with the following? <script language="JavaScript"> function doWord(file) { if (navigator.userAgent.indexOf("MSIE")!=-1)
3
3359
by: Almund Sebi | last post by:
(Using UDB 7.2 FP11). Given this output from LIST BACKUP HISTORY FOR MYDB: (It's an online backup image) > Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID > -- --- ------------------ ---- --- ------------ ------------ -------------- > B D 20040217102712001 N D S0000194.LOG S0000196.LOG > ---------------------------------------------------------------------------- and:
6
5196
by: Charles Morrall | last post by:
I have no experience with DB2 as such, but I've been tasked with configuring backup of a server running DB2 v8 on Windows Server 2003. I do have some experience with backups in general though. The backup software I'll be using is Backup Exec 10, but Backup Exec doesn't have a specific agent for DB2, as it does for SQL and Oracle. The supplier of Backup Exec claims I can use the Open File option of Backup Exec to backup DB2. I find this a...
4
9476
by: manwiththeaxe.70 | last post by:
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?
6
3675
by: Raj | last post by:
How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option in load) to revover the tablespace? Thanks, Raj
5
1940
by: Gladiator | last post by:
Hai..... I have a database............ i took an online backup for tht..... After tht mistakenly i dropped the database.......... now i dont have the logs also....... now after i restore the database it will be in rollforward pending state........ when i am rollforwarding it is saying cannot rollforward........ can anyone tell me how to bring the database back again........
4
5487
by: Al | last post by:
We have a production DB that is running DB2 v8 fix pak 8. Some of configuration parameter on the primary DB config file is: Logretain = NO Userexit = NO Logarchmeth1 = Disk:/aa/bb/ccc/ when I ran: db2 backup DB <DBNAMEonline the command ran successful, I ran db2ckbkp on the backup, result is successful.
6
7721
by: michael.spoden | last post by:
Hi, how can I fix lock-waits during an online backup? Is an online backup in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux. The command to perform the backup is: db2 backup db BPEDB online to / var/tmp During the backup the application hangs on just one table
2
11074
by: alex250374 | last post by:
Hi all, db2 9.1 fixpak 0 aix 5.3 I have a big problem every time I start an online backup with include logs via veritas comes out an error!!! The db2diag shows: 2009-10-29-17.57.22.240269+060 E10634592A396 LEVEL: Info PID : 995458 TID : 1 PROC : db2agent (idle) INSTANCE: db2inst1 NODE : 000 DB : ATMDB
0
9466
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9253
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
9201
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8202
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...
1
6747
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4823
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3277
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
2740
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2190
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.