On my previous post, I posted some differences between Active Data Guard and Golden Gate. But some people may find it more confusing and ask when should I use Active Data Guard? or Golden Gate?
So let me try to summarize it here:
Use Active Data Guard for:
Disaster Recovery, Data Protection/HA (Oracle environment)
Use Golden Gate for:
Information Distribution, Data Integration, Cross-platform migrations (For ex. SQL Server to Oracle)
They can also complements each other.
ADG provides read-only replica for standby database, and GG capturing standby archive logs then replicating it to 'n' different target systems.
So let me try to summarize it here:
Use Active Data Guard for:
Disaster Recovery, Data Protection/HA (Oracle environment)
Use Golden Gate for:
Information Distribution, Data Integration, Cross-platform migrations (For ex. SQL Server to Oracle)
They can also complements each other.
ADG provides read-only replica for standby database, and GG capturing standby archive logs then replicating it to 'n' different target systems.
1 comment:
For real time reporting can Oracle Active Data Guard an option?
Post a Comment