LOB是否使用HADR进行了重新审核？ [英] Are LOB's replciated using HADR ?
问题描述
我正在尝试确定是否使用HADR对LOB进行了重新编译。
以下来自在线手册的文件
http://publib.boulder.ibm.com/infoce...help/index.jsp 建议不要复制
LOB' HADR：
---------------------------------------- --------
高可用性灾难恢复的非复制操作：
高可用性灾难恢复（HADR）使用数据库日志到
将数据复制到备用数据库。主数据库上允许的未记录操作是
，但未复制到备用数据库
数据库。非复制操作包括但不限于：
以下操作：
- 不复制BLOB和CLOB;但是，它们的空间将在备用数据库上分配。
------------------ -------------------------------
所以我假设即使是LOB'在主服务器上记录的是
没有复制到HADR中的备份？但我认为这也意味着如果LOB数据是只读的（未更新），那么我们可以在两台服务器上存储
数据。
I am trying to determine whether LOB''s are replciated using HADR. The
following documentation from the on-line manuals
http://publib.boulder.ibm.com/infoce...help/index.jsp suggest that
LOB''s are not replicated on HADR:
------------------------------------------------
"Non-replicated operations for high availability disaster recovery:
High availability disaster recovery (HADR) uses database logs to
replicate data to the standby database. Non-logged operations are
allowed on the primary database, but not replicated to the standby
database. Non-replicated operations include, but are not limited to,
the following operations:
- BLOBs and CLOBs are not replicated; however, the space for them will
be allocated on the standby database."
-------------------------------------------------
So I assuming that even LOB''s that are logged on the primary server are
not replicated to the backup in HADR? But I assume it also means that
if the LOB data is read only (not updated), then we could store the
data on both servers.
推荐答案
m0 **** @ yahoo.com 写道：
我试图确定是否使用HADR对LOB进行了重新编译。
以下来自在线手册的文档
http://publib.boulder.ibm.com/infoce...help/index.jsp 表明
LOB'不会在HADR上复制：
- ----------------------------------------------
... -
NOT LOGGED不复制BLOB和CLOB;但是，它们的空间将在备用数据库中分配。
-------------------------- -----------------------
I am trying to determine whether LOB''s are replciated using HADR. The
following documentation from the on-line manuals
http://publib.boulder.ibm.com/infoce...help/index.jsp suggest that
LOB''s are not replicated on HADR:
------------------------------------------------ ... - NOT LOGGED BLOBs and CLOBs are not replicated; however, the space for them will
be allocated on the standby database."
-------------------------------------------------
我被告知此文档错误将在下次刷新时更正。
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
I''m told this doc error will be corrected in the next refresh.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
你能具体告诉我什么是文档错误吗？
这是否意味着HADR将重新标记LOB'？
Can you tell me specifically what the doc error is?
Does that mean that HADR will replciate LOB''s?
当前文档在未记录的项目中对LOB进行分类是不正确的。
不正确。有些LOB被记录，有些则不然。记录的LOB是由HADR复制的好b $ b，未记录的LOB不是。
问候，
- Steve P.
--------------------------
Steve Pearson
DB2 UDB for LUW Development，Portland，OR，USA
The current documentation categorizing LOBs among non-logged items is
incorrect. Some LOBs are logged and some aren''t. Logged LOBs are
replicated just fine by HADR, non-logged LOBs are not.
Regards,
- Steve P.
--------------------------
Steve Pearson
DB2 UDB for LUW Development, Portland, OR, USA
这篇关于LOB是否使用HADR进行了重新审核？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
