Differences between Oracle DataGuard and GoldenGate


Golden Gate
Data Guard
    • High latency (latency is the duration of redo transfer)
Low latency
    • Uses TCP/IP to connect
Uses Tnsnames to connect
    • Doesn't have the fast-start failover utility
Has the fast-start failover utility
    • Little or no gaps

    • Near zero downtime upgrade

    • Live reporting

    • Operational Business Intelligence (Data warehouse)

    • Transactional Data integration
Always have gap issues

Down-time
Can replicate Just a table
Would always replicate the entire data
Can be open read write
 recovery mode (mount mode)
Capable Query offloading


Comments

Post a Comment

Popular posts from this blog

ERROR   OGG-02022  Oracle GoldenGate Capture for Oracle, ext.prm:  Logmining server does not exist on this Oracle database.

Solution: set the correct DB environment and register OGG extract GGSCI (oracledev.domain.com) 4> info all Program     Status      Group       Lag at Chkpt  Time Since Chkpt MANAGER     RUNNING EXTRACT     STOPPED     EXT      00:00:00      00:33:03 EXTRACT     STOPPED     PUMP      00:00:00      00:56:48 GGSCI (oracledev.domain.com) 5>  register Extract EXT database 2017-02-28 16:32:46  ERROR   OGG-08216  ERROR: Cannot register or unregister EXTRACT EXT because no database login was provided. Use DBLOGIN to establish a connection. GGSCI (oracledev.domain.com) 6>  dblogin useridalias ggadmin Successfully logged into database. GGSCI (oracledev.domai...
Read more