现场环境Oracle数据同步
有哪些已知的可靠工具可用于在实时环境中的 Oracle 数据库实例之间同步大量数据？
要求是具有实时数据的主机在实时环境中运行，即数据库已更新。接收主机离线，数据同步完成后才会上线。
大多数数据存储在 blob 列中，要同步的数据量达到 ~100GB。仅表中的部分数据需要移动，而表的实际大小约为 50 TB。
这是一个集群系统，每台活动机器都是另一台机器的克隆，每台机器都包含一个 Oracle DB 实例。有时，机器需要进行维护，并且会丢失实时数据。当它们恢复时，需要同步数据。机器离线维护通常不超过 6 小时。如果没有克隆机器，当其中一台机器必须进行维护时，我们将无法确保系统正常运行。
同步不应严重影响实时计算机的 CPU 使用率。
What are known reliable tools for syncing huge amounts of data between Oracle DB instances in live environment?
Requirements are that the host with live data is running in a live environment, i.e. the database is updated. Receiving host is offline, and will go online only when data sync is complete.
Most of the data is stored in blob columns and amount of data to sync reaches ~100GB. Only part of data from a table needs to move, while the actual size of the table is around 50 TB.
This is a clustered system, and each live machine is a clone of the other, each machine contains an instance of Oracle DB. Sometimes machines need to go under maintenance and they lose live data. When they come back up, the data needs to be synchronized. Machine is brought offline for maintenance usually not longer for 6 hours. Without having clone machines, we would not be able to ensure that system is up, when one of the machines must go for maintenance.
Sync should not severely influence the live machine CPU usage.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先要了解的是 Oracle 高级复制 和 Oracle Streams。您可能需要考虑获取一本关于 Streams 的好书。
First thing to look at is Oracle Advanced Replication and Oracle Streams. You might want to consider getting a good book on Streams.