问题描述
你好。
前段时间我在这次会议上问过， - 如何使用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.
推荐答案
我的麻烦是 - 我无法通过在线备份发明任何可行的场景。例如：
场景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
----------
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用于？这是假的功能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！