Oracle 数据库镜像
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5320475/
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
Oracle database mirroring
提问by Faren
We have ERP application that store the data to ORACLE database. And also we have a lot of another application that use the ERP database. Same database but different instances. We got the performance issues when ERP and another application use the same database.
我们有将数据存储到 ORACLE 数据库的 ERP 应用程序。而且我们还有很多使用 ERP 数据库的其他应用程序。相同的数据库但不同的实例。当 ERP 和另一个应用程序使用相同的数据库时，我们遇到了性能问题。
We are planning to separate the database server become three. One for ERP and two others for report and applications. these new database servers are came from ERP database, because they use the same database structure and data. So we could say these new database servers are mirror of ERP database. And also sometime data on the mirror database could be updated by other application, and it should be also updated on ERP database.
我们打算把数据库服务器分开变成三台。一个用于 ERP，另外两个用于报告和应用程序。这些新的数据库服务器来自ERP数据库，因为它们使用相同的数据库结构和数据。所以我们可以说这些新的数据库服务器是ERP数据库的镜像。有时镜像数据库上的数据可能会被其他应用程序更新，也应该在 ERP 数据库上更新。
What best practice and method should be used for mirroring this condition? Is it enough by use Data guard from ORACLE?
应该使用什么最佳实践和方法来反映这种情况？使用 ORACLE 的数据保护就足够了吗？
This is the picture of the architecture plan.
这是架构图的图片。
回答by Rob van Laarhoven
Data guard does not allow writing to the stand-by. Active dataguard does allow reading from the stand-by while archiving transactions from the primary node. So the report server using your ERP Mirror 1 is not a problem as long as it only reads data. Writing from the other applications to ERP Mirror 2 is. What you are looking for is advanced replication or Oracle streams. This is a very complex task. Maybe offloading your reporting to a data-guard stand-by solves your problems.
数据保护不允许写入待机。Active dataguard 允许在从主节点归档事务的同时从备用节点读取。所以使用你的ERP Mirror 1的报表服务器只要只读取数据就不是问题。从其他应用程序写入 ERP Mirror 2 是。您正在寻找的是高级复制或 Oracle 流。这是一项非常复杂的任务。也许将您的报告卸载到数据保护待机可以解决您的问题。
