[转载]dg v.s. streams v.s. gg

最新推荐文章于 2025-12-11 17:34:52 发布

原创最新推荐文章于 2025-12-11 17:34:52 发布 · 144 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #dg #gg #streams

Oracle 专栏收录该内容

34 篇文章

订阅专栏

本文讨论了使用Oracle DataGuard进行灾难恢复（DR）的优势，并将其与Streams和GoldenGate进行了比较。作者建议保持当前的复制状态不变，因为它正在运行并且得到了支持。

Tom Said:
As for setting up the DR we are inclined to use DataGuard.

perfect, because data guard does disaster recovery (DR) out of the box and the other two are technologies that could be used to BUILD a DR.

to me, tt is sort of like deciding between:

a) Oracle Human Resources, the application
b) Oracle 11g R2, the database

(a) is like data guard, it is an DR (HR) application - it does DR (HR).
(b) is like streams/golden gate, you could use them to BUILD DR (HR).

As for your current replication, I personally would not be inclined to change it. It is working, it is supported, it is supportable, it will be maintained (although it may not be enhanced going forward into the future as much)

[url]http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3349335100346299316[/url]