有关文件系统的外部备份的问题 [英] Question about external backups to filesystems
问题描述
大家好，
我来自Informix世界，我有一位客户在Red Hat上使用DB2
8.2.3 for Linux企业ES。
客户正在执行容器等的文件系统备份
每晚但他们没有关闭数据库服务器而
这样做。我只假设这个最有可能会留下一个
不一致的备份映像，因为没有什么可以确保缓冲池中的
修改后的页面在
文件系统备份开始。数据库上有很多动作
24x7。
问题：除了在执行这样的实例之前关闭实例
an外部备份，有没有办法在db2中阻止所有访问并使
确保内存中的所有已修改页面都写入磁盘？我已经尝试了不那么用户友好的在线db2文档，但没有
运气好。使用Informix Dynamic Server（IDS），可以通过发出命令onmode -c BLOCK来实现这一目标。然后在外部备份完成后onmode -c UNBLOCK
。
任何输入都表示赞赏。
RoB
Hi all,
I''m coming from the Informix world and I have a customer using DB2
8.2.3 for Linux on Red Hat Enterprise ES.
The customer is performing filesystem backups of the containers etc
every night but they are not shutting down the database server while
doing this. I only assume that this most likelly would leave an
inconsistant backup image as there is nothing assuring that the
modified pages in the buffer pool get written to disk before the
filesystem backup starts. There is plenty of acticivty on the database
24x7.
Question: Apart from shutting down the instance before performing such
an external backup, is there a way in db2 to block all access and make
sure that all modified pages in memory gets written to disk? I''ve
tried the not so user-friendly online db2 documentation but without
any luck. With Informix Dynamic Server (IDS) this would be archieved
by issuing the commands "onmode -c BLOCK" and then "onmode -c UNBLOCK"
once the external backup has finished.
Any input is appreciated.
RoB
推荐答案
3月23日上午8:25，RoB < pluma ... @ yahoo.comwrote：
On Mar 23, 8:25 am, "RoB" <pluma...@yahoo.comwrote:
大家好，
我来自Informix世界和我有一个客户在Red Hat Enterprise ES上使用DB2
8.2.3 for Linux。
客户正在执行容器的文件系统备份等
每晚但他们没有关闭数据库服务器，而
这样做。我只假设这个最有可能会留下一个
不一致的备份映像，因为没有什么可以确保缓冲池中的
修改后的页面在
文件系统备份开始。数据库上有很多动作
24x7。
问题：除了在执行这样的实例之前关闭实例
an外部备份，有没有办法在db2中阻止所有访问并使
确保内存中的所有已修改页面都写入磁盘？我已经尝试了不那么用户友好的在线db2文档，但没有
运气好。使用Informix Dynamic Server（IDS），可以通过发出命令onmode -c BLOCK来实现这一目标。然后在外部备份完成后onmode -c UNBLOCK
。
任何输入都表示赞赏。
RoB
Hi all,
I''m coming from the Informix world and I have a customer using DB2
8.2.3 for Linux on Red Hat Enterprise ES.
The customer is performing filesystem backups of the containers etc
every night but they are not shutting down the database server while
doing this. I only assume that this most likelly would leave an
inconsistant backup image as there is nothing assuring that the
modified pages in the buffer pool get written to disk before the
filesystem backup starts. There is plenty of acticivty on the database
24x7.
Question: Apart from shutting down the instance before performing such
an external backup, is there a way in db2 to block all access and make
sure that all modified pages in memory gets written to disk? I''ve
tried the not so user-friendly online db2 documentation but without
any luck. With Informix Dynamic Server (IDS) this would be archieved
by issuing the commands "onmode -c BLOCK" and then "onmode -c UNBLOCK"
once the external backup has finished.
Any input is appreciated.
RoB
如果需要全天候使用数据库，则无需关闭数据库。
设置日志存档并开始进行在线备份。
There''s no need to shutdown the database if it needs to be used 24x7.
Set up Log archival and start taking online backups.
3月23日，下午12:51，krx < kedar.she ... @ gmail.comwrote：
On Mar 23, 12:51 pm, "krx" <kedar.she...@gmail.comwrote:
3月23日上午8:25，RoB < pluma ... @ yahoo.comwrote：
On Mar 23, 8:25 am, "RoB" <pluma...@yahoo.comwrote:
大家好，
Hi all,
我来自Informix世界，我有一位客户在Red Hat Enterprise ES上使用DB2
8.2.3 for Linux。
I''m coming from the Informix world and I have a customer using DB2
8.2.3 for Linux on Red Hat Enterprise ES.
客户正在执行容器等的文件系统备份
每晚但他们没有关闭数据库服务器而
这样做。我只假设这个最有可能会留下一个
不一致的备份映像，因为没有什么可以确保缓冲池中的
修改后的页面在
文件系统备份开始。数据库上有很多活动
24x7。
The customer is performing filesystem backups of the containers etc
every night but they are not shutting down the database server while
doing this. I only assume that this most likelly would leave an
inconsistant backup image as there is nothing assuring that the
modified pages in the buffer pool get written to disk before the
filesystem backup starts. There is plenty of acticivty on the database
24x7.
问题：除了在执行这样的外部备份之前关闭实例外，db2还有一种方法可以阻止所有访问并使
确保内存中的所有已修改页面都写入磁盘？我已经尝试了不那么用户友好的在线db2文档，但没有
运气好。使用Informix Dynamic Server（IDS），可以通过发出命令onmode -c BLOCK来实现这一目标。然后在外部备份完成后onmode -c UNBLOCK
。
Question: Apart from shutting down the instance before performing such
an external backup, is there a way in db2 to block all access and make
sure that all modified pages in memory gets written to disk? I''ve
tried the not so user-friendly online db2 documentation but without
any luck. With Informix Dynamic Server (IDS) this would be archieved
by issuing the commands "onmode -c BLOCK" and then "onmode -c UNBLOCK"
once the external backup has finished.
任何输入都表示赞赏。
Any input is appreciated.
RoB
RoB
如果需要，无需关闭数据库24x7全天候使用。
设置日志存档并开始在线备份.-隐藏引用文字 -
- 显示引用文字 -
There''s no need to shutdown the database if it needs to be used 24x7.
Set up Log archival and start taking online backups.- Hide quoted text -
- Show quoted text -
这位客户遇到问题设置适当的db2
备份策略，以便继续使用文件系统备份。至于
因为他们担心，他们认为这很好，并希望继续
这样做。所以我基本上不在这里寻找其他解决方案，
虽然我知道它们存在，但我正在寻找一种方法来调整它们目前的策略实际上将恢复一个
一致备份的东西。
RoB
Hi,
This customer was "having problems" with setting up a proper db2
backup strategy so they went on with using filesystem backups. As far
as they are concerned, they think this works fine and want to continue
doing it. So I''m bascially not looking for other solutions here,
although I know that they exist, but I''m looking for a way to tweak
their current strategy into something that actually will restore a
consistent backup.
RoB
RoB写道：
RoB wrote:
3月23日12:51 pm，krx < kedar.she ... @ gmail.comwrote：
On Mar 23, 12:51 pm, "krx" <kedar.she...@gmail.comwrote:
> 3月23日上午8:25，RoB < pluma ... @ yahoo.comwrote：
>On Mar 23, 8:25 am, "RoB" <pluma...@yahoo.comwrote:
大家好，
Hi all,
我来自Informix世界，我有一位客户在Red Hat Enterprise ES上使用DB2
8.2.3 for Linux。
I''m coming from the Informix world and I have a customer using DB2
8.2.3 for Linux on Red Hat Enterprise ES.
客户正在执行容器等的文件系统备份
每晚但他们没有关闭数据库服务器而
这样做。我只假设这个最有可能会留下一个
不一致的备份映像，因为没有什么可以确保缓冲池中的
修改后的页面在
文件系统备份开始。数据库上有很多活动
24x7。
The customer is performing filesystem backups of the containers etc
every night but they are not shutting down the database server while
doing this. I only assume that this most likelly would leave an
inconsistant backup image as there is nothing assuring that the
modified pages in the buffer pool get written to disk before the
filesystem backup starts. There is plenty of acticivty on the database
24x7.
问题：除了在执行这样的外部备份之前关闭实例外，db2还有一种方法可以阻止所有访问并使
确保内存中的所有已修改页面都写入磁盘？我已经尝试了不那么用户友好的在线db2文档，但没有
运气好。使用Informix Dynamic Server（IDS），可以通过发出命令onmode -c BLOCK来实现这一目标。然后在外部备份完成后onmode -c UNBLOCK
。
Question: Apart from shutting down the instance before performing such
an external backup, is there a way in db2 to block all access and make
sure that all modified pages in memory gets written to disk? I''ve
tried the not so user-friendly online db2 documentation but without
any luck. With Informix Dynamic Server (IDS) this would be archieved
by issuing the commands "onmode -c BLOCK" and then "onmode -c UNBLOCK"
once the external backup has finished.
任何输入都表示赞赏。
Any input is appreciated.
RoB
RoB
如果需要全天候使用数据库，则无需关闭数据库。
设置日志存档并开始进行在线备份.-隐藏引用文本 -
- 显示引用文本 -
There''s no need to shutdown the database if it needs to be used 24x7.
Set up Log archival and start taking online backups.- Hide quoted text -
- Show quoted text -
您好，
该客户遇到问题设置适当的db2
备份策略，以便继续使用文件系统备份。至于
因为他们担心，他们认为这很好，并希望继续
这样做。所以我基本上不在这里寻找其他解决方案，
虽然我知道它们存在，但我正在寻找一种方法来调整它们目前的策略实际上将恢复
一致备份的东西。
RoB
Hi,
This customer was "having problems" with setting up a proper db2
backup strategy so they went on with using filesystem backups. As far
as they are concerned, they think this works fine and want to continue
doing it. So I''m bascially not looking for other solutions here,
although I know that they exist, but I''m looking for a way to tweak
their current strategy into something that actually will restore a
consistent backup.
RoB
RoB，
我会说，如果客户正在使用文件系统备份，特别是如果他实际上没有关闭实例，那么全部投注已关闭可以恢复任何东西。
实际上，没有使用工作提供的工具$ b多年来对我来说非常好，如果他丢失了所有数据，我认为他不会得到IBM的任何同情。
我想知道他是否曾试图用他所拥有的东西进行恢复。
所以确实没有解决办法，只能实施备份和恢复
策略使用DB2 BACKUP命令作为他所做事情的基础。
如果他需要有人为他做这件事，那么他只需要问。我确定
列表上有很多人（包括我自己），他们的技能可以做到这一点。
Phil Nelson
ScotDB Limited
（te*****@scotdb.com）
RoB,
I''d say that if the customer is using filesystem backups, especially if he
actually isn''t shutting down the instance, then "all bets are off" on being
able to recover anything at all.
In fact, without using the tools provided for the job, which have worked
exceptionally well for me over many years, I don''t think he will get any
sympathy from IBM if he loses all his data.
I wonder if he has ever attempted a restore with what he has.
So there really is no solution but to put in place a backup and recovery
strategy using the DB2 BACKUP command as the foundation for what he does.
If he needs someone to do this for him, then he just has to ask. I''m sure
there are plenty of people on the list (myself included) with the skills to
do such a thing.
Phil Nelson
ScotDB Limited
(te*****@scotdb.com)
这篇关于有关文件系统的外部备份的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
