Oracle Database 11g R2 Standard Edition One 可以使用什么类型的复制?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/5071729/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 22:49:56  来源:igfitidea点击:

What type of replication can be used with Oracle Database 11g R2 Standard Edition One?

oraclereplicationoracle11g

提问by JSP

My organization plans to buy two servers with two Oracle 11g R2 SE1 licenses. It is need to set up bidirectional replication between servers' databases (both databases are fully identical in DB structure and practically identical in data except table with server-specific data (application parameters values, such as server ID and so on).

我的组织计划购买两台带有两个 Oracle 11g R2 SE1 许可证的服务器。需要在服务器的数据库之间建立双向复制(两个数据库在数据库结构上完全相同,除了包含服务器特定数据(应用程序参数值,如服务器 ID 等)的表外,数据几乎完全相同。

I think about Advanced replication (multimaster), is this match with the 11g R2 SE1 license? Is there any other Oracle solution, suitable for my circumstances and the 11g R2 SE1 license? Or, in other case, what third-party Oracle replication engine you can advise?

我想到了高级复制(多主),这与 11g R2 SE1 许可证匹配吗?是否有其他适用于我的情况和 11g R2 SE1 许可证的 Oracle 解决方案?或者,在其他情况下,您可以建议哪些第三方 Oracle 复制引擎?

Thanks.

谢谢。

采纳答案by Justin Cave

From the Oracle 11.2 Licensing Guide, it appears that Streams is available in SE1. That is Oracle's preferred technology for bidirectional data replication. There are some limitations of Streams in SE1-- it appears, for example, that you are limited to synchronous capturebased on My Oracle Support document 567872.1.

Oracle 11.2 许可指南看来,Streams 在 SE1 中可用。这是 Oracle 首选的双向数据复制技术。SE1 中的 Streams 有一些限制——例如,您似乎仅限于基于 My Oracle Support 文档 567872.1 的同步捕获