什么是ONLINE BACKUP用于？这是假的功能吗？ [英] What is ONLINE BACKUP intended for ? Is it fake feature ?
问题描述
你好。
前段时间我在这次会议上问过， - 如何使用ONLINE BACKUP将数据库恢复到另一个系统？ - 但没有答案。因此，我可以得出结论，这是不可能的。
但是......我可以用在线备份做什么呢？需要什么？我认为没有任何可能使用此备份。如果可以的话，请分享你的知识。
是的，自从版本8.2以来，我已经阅读了INCLUDE LOSG选项。用于在线备份。使用此选项在线备份看起来很有用。但在v8.2在线备份之前看起来绝对无法使用，假的功能。如果我错了，请纠正我。
-
Konstantin Andreev。
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.
推荐答案
在线备份是指在没有
的情况下进行备份映像复制以使数据库脱机的功能。我不确定你的意思是假的
功能 ...在线备份被众多客户使用...
其实，它通常比离线备份更受欢迎，因为你不需要
必须采取数据库离线。除非我误会，否则我不能看到你怎么说它是假的功能......备份是基本的恢复原则b / b
恢复原则大多数（如果不是全部）客户需要和使用的策略。
Larry Edelstein
Konstantin Andreev写道：
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 misunderstanding, 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:
你好。
前段时间我在这次会议上问过， - 如何使用在线备份
来恢复数据库到另一个系统？ - 但没有答案。因此
我可以断定这是不可能的。
但是......我可以用在线备份做什么呢？需要什么
for？我认为没有任何可能使用此备份。如果可以的话，请分享
你的知识。
是的，我从8.2版本开始就有一个选项INCLUDE LOSG
用于在线备份。使用此选项在线备份看起来好像可以使用
。但在v8.2在线备份之前看起来绝对无法使用，假的
功能。请纠正我如果我错了。
-
康斯坦丁安德列夫。
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.
Larry写道：
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.
我的麻烦是 - 我无法通过在线备份发明任何可行的场景。例如：
场景A
----------
1）我发出BACKUP ONLINE"并将备份映像移动到安全的位置。
2）数据库系统因建筑物发生火灾而烧毁。
2）备份映像在这里，但是从* NOT恢复*可能，因为没有日志。我的备份实际上是假的。
场景B
----------
1）我发出在线备份。
2）我在数据库中更改内容
3）我想在备份时将数据库恢复到状态，但是它是*不可能，因为我必须*前滚所有日志。我的备份再没用了。
场景C
----------
1）我发行在线备份。
2）我在数据库中更改了某些内容
3）曾经有一段时间想要创建一些还原点，以便向前滚动停在那里。因此我必须* QUIESCE *数据库。但是从用户的角度来看，quiesce数据库与OFFLINE相同。
1994年，微软开始转售Sybase ASE，因为它是SQL Server（v.4.21）的先驱，简单的任务是已经很简单了。我只是写了将数据库db01转储到设备，我确信它是一致的并且能够恢复。
使用DB2，简单的任务往往变得越来越复杂。我已经花了大量时间尝试进行可行的在线备份。请指导我以正确的方式继续...
-
Konstantin Andreev。
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.
你将操作问题与一个非常简单的技术问题相混淆
您需要日志从恢复中继续前进：
场景A：将场景A应用于SQL服务器转储示例和你
有同样的问题。随着时间的推移，时间点转储并不神奇地随着时间的推移包含新数据。
场景B：为什么有人会使用恢复操作撤消
数据库更改超出了我的范围。
BACKUP / RESTORE，它们不会修复坏形式，它们会触发尝试的人;-)
Scenaro C：这只是一个经过修改的方案B.
您需要日志。 E
Konstantin Andreev写道：
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写道：
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.
我的麻烦是 - 我无法用在线备份发明任何可行的场景。例如：
场景A
----------
1）我发出BACKUP ONLINE"并将备份映像移动到安全的位置。
2）数据库系统因建筑物发生火灾而烧毁。
2）备份映像在这里，但是从* NOT恢复*可能，因为没有日志。我的备份实际上是假的。
场景B
----------
1）我发出在线备份。
2）我在数据库中更改内容
3）我想在备份时将数据库恢复到状态，但是它是*不可能，因为我必须*前滚所有日志。我的备份再没用了。
场景C
----------
1）我发行在线备份。
2）我在数据库中更改了某些内容
3）曾经有一段时间想要创建一些还原点，以便向前滚动停在那里。因此我必须* QUIESCE *数据库。但是从用户的角度来看，quiesce数据库与OFFLINE相同。
1994年，微软开始转售Sybase ASE，因为它是SQL Server的先驱（v.4.21）简单的任务已经完成了。我只是写了将数据库db01转储到设备，我确信它是一致的并且能够恢复。
使用DB2，简单的任务往往变得越来越复杂。我已经花了大量时间尝试进行可行的在线备份。请指导我以正确的方式继续...
-
康斯坦丁安德列夫。
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.
这篇关于什么是ONLINE BACKUP用于？这是假的功能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
