Re: Goldengate and DW

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 19 Jan 2020 10:16:04 -0500
Message-ID: <d5e9f114-19b7-6bbf-d227-204ae2c6ac8e_at_gmail.com>

Ram, GG and DG are different products. Logical standby DB is still just a copy of the database, despite all of the dbms_logstdby.skip rules. GG, on the other hand, is just a database replication product. You can do symmetric replication, which is not something you can do with DG. GG has a whole different set of rules and is, in my opinion, much better for creating a DW.

On 1/13/20 2:16 PM, Ram Raman wrote:
> Listers,
> Can we consider GG (goldengate) for replication of our multi TB data
> warehouse. Anything nuances, surprises there? Between GG and Dataguard
> which one can be a better product.
> Licensing cost is NOT an issue.
>
> Thanks
> Ram
> --
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jan 19 2020 - 16:16:04 CET

This message: [ Message body ]
Next message: kunwar singh: "Is enq: TX - row lock contention a wait or syscall"
Previous message: Ls Cheng: "Re: Offtopic: Linux ps aux sort cumulative CPU time"
In reply to: Ram Raman: "Goldengate and DW"
In reply to Ram Raman: "Goldengate and DW"
Next in thread: Ram Raman: "Re: Goldengate and DW"
Reply: Ram Raman: "Re: Goldengate and DW"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message