I got a question today on if migrating off Oracle Streams need to be considered. The answer is yes. Oracle Stream has been deprecated since Oracle Database 12.1 release. You can now use Oracle GoldenGate to replace all replication features of Oracle Streams.
Oracle provides a tool to simplify the migration. Please check the Oracle Streams to GoldenGate Migration Utility (Doc ID 1912338.1) for the detailed information. You can also refer to Oracle GoldenGate Best Practices: Oracle Streams to Oracle GoldenGate Conversion (Doc ID 1383303.1) for the best practices. Thomson Reuters is one of the customers who had evaluated and completed the migration of its Active-Active database replication solution from Oracle Streams to Oracle GoldenGate.
If you'd like to learn more about the differences between Oracle Streams and Oracle GoldenGate, you can also read the following Oracle Notes: Comparison Between Oracle Streams and GoldenGate (Doc ID 1437736.1).
The followings are some case studies:
Oracle provides a tool to simplify the migration. Please check the Oracle Streams to GoldenGate Migration Utility (Doc ID 1912338.1) for the detailed information. You can also refer to Oracle GoldenGate Best Practices: Oracle Streams to Oracle GoldenGate Conversion (Doc ID 1383303.1) for the best practices. Thomson Reuters is one of the customers who had evaluated and completed the migration of its Active-Active database replication solution from Oracle Streams to Oracle GoldenGate.
If you'd like to learn more about the differences between Oracle Streams and Oracle GoldenGate, you can also read the following Oracle Notes: Comparison Between Oracle Streams and GoldenGate (Doc ID 1437736.1).
The followings are some case studies:
- A global supplier of telecommunication network equipment, software and services replaced the Oracle Streams implementation with Oracle GoldenGate. Oracle GoldenGate is used to synchronize data between their OLTP and Data Warehouse systems for financial reports.
- A major home improvement retailer was facing issues with Oracle Streams for their reporting database creation. The issues include data loss and difficult recovery after the network outage. Oracle GoldenGate can then efficiently load data from their supply chain system to the reporting database for real-time reports.