Unsolved
This post is more than 5 years old
2 Intern
•
643 Posts
0
1866
March 12th, 2012 02:00
Oracle GoldenGate, Stream, Data Guard
Oracle GoldenGate delivers real-time access of real-time information, enabling companies to dramatically improve the availability, reliability, and performance of critical data across enterprise systems.
Golden Gate vs Stream
GoldenGate is Oracle’s strategic replication solution
• Streams continues to be a supported Oracle Database feature
• Best Streams technology will be integrated into GoldenGate
GoldenGate vs Data Guard
• Information Distribution & Consolidation, Application Upgrades & Changes
– Use GoldenGate - heterogeneous, active-active, transformations, subsetting
• Disaster Recovery / Data Protection / HA
– Simple Full Oracle Database Protection
• Use Active Data Guard
• High-performance, simple, drop-in solution for HA and DR, readable at standby
• Works for all apps and data types, including packaged apps that can’t be changed
– Application desiring flexible HA, active-active, schema changes, platform changes
• Use GoldenGate
• Avoid or manage active-active conflicts at application level
• Combine the two for full database protection and information distribution
http://www.oracle.com/technetwork/database/features/availability/312833-129009.pdf
zhaos2
2 Intern
•
643 Posts
0
March 13th, 2012 01:00
The main difference between Oracle Stream and GoldenGate, aside from the extra licensing costs associated with GoldenGate, is the ease of setup, installation and configuration.
GoldenGate is geared more towards a heterogeneous environment, so it doesn’t depend on Oracle-specific items. Well, it does in one sense in terms of applying your own SQL statements in a call to SQLEXEC(). However, as far as relying on being able to access online redo logs, standby redo logs, or archived redo logs, no big deal. GoldenGate uses its own proprietary trail files (one set on the source and one on the target). It doesn’t care about Oracle Net Services either when it comes time to transport data from the source to the target.
Another way to compare Streams and GoldenGate is to think of coupling. Obviously, Streams would be considered to be tightly coupled with Oracle. GoldenGate, on the other hand, would be considered as being loosely coupled. Given that GoldenGate is Oracle Corporation’s strategic solution for at least replication and data integration, you can be sure that whatever is loose today won’t be nearly as much in the future.
reseach
2 Intern
•
225 Posts
0
March 14th, 2012 02:00
From my perspective, the major differences of them are about “Cross Platform”
Golden Gate is using method of transferring open SQL text, that make it able to sync between Oracle to Oracle and with 3rd DB, like BD2 etc. it could be a DB migration tool.
Others are using Oracle redo tech, that limits them within Oracle environment
Eddy