50 likes | 133 Views
ALMA Integrated Computing Team Coordination & Planning Meeting #3 Socorro, 17-19 June 2014. RoadMap for Golden Gate José Parra. Roadmap for Golden Gate. I. What is Golden Gate?
E N D
ALMA Integrated Computing TeamCoordination & Planning Meeting #3 Socorro, 17-19 June 2014 RoadMap for Golden Gate José Parra
Roadmap for Golden Gate • I. What is Golden Gate? • Oracle GoldenGate is a software package for real-time data integration and replication in heterogeneous IT environments. • The major benefit of GoldenGate over Oracle heterogeneous services is the ability to extract data from various source environments such as SQL Server, Sybase, Teradata, and DB2 and pump the data into an Oracle data warehouse environment
Roadmap for Golden Gate • II. ALMA replication needed? • Yes, ALMA uses “Oracle Streams” to replicate metadata from OSF to SCO and to the ARCs. This is key to keep all sites in-sync. • III. Why do we need to replace “Oracle Streams” with GG? • Oracle Streams is deprecated in Oracle Database 12c and may be desupported and unavailable in a later Oracle Database release. Besides this critical support issue, any new database features, data types, or capabilities will not be supported by Streams starting 2016 (End of support 11gR2) • IV. Coordination required • ARCs and JAO need to buy Oracle GoldenGate licenses in 2015 (*) • Maintenance window will be required @JAO and ARCs to replace Oracle Streams during 2015 • (*) Cost for ALMA (Price hold - 75% discount) • Oracle Golden Gate – Named User Plus Perpetual USD$ 87.50 • Oracle Golden Gate – Processor Perpetual USD 4,375
Roadmap for Golden Gate • V. Roadmap 2013 Golden Gate TEST 11gR1 – DONE Oracle upgrade TEST 11gR2 - DONE 2014 Oracle upgrade PRODUCTION 11gR2 - DONE Golden Gate TEST 11gR2 2015 Golden Gate PRODUCTION 11gR2 Oracle upgrade TEST 12C 2016 End of support 11gR2 Oracle upgrade PRODUCTION 12C Oracle upgrade TEST <next Oracle release> 2017 … … 2018 End of support 12C
Roadmap for Golden Gate • http://www.slideshare.net/oracleonthebrain/golden-gate-slide-deck END