Oracle GoldenGate Overview
\n1. Oracle GoldenGate software enable real-time, continuous movement of transactional data across operational and analytical business systems;
\n2. Real-Time Acccess to Real-Time Information
\n 1. Real-Time Access:availability,the degree to which information can be instantly accessed;
\n 2. Real-Time Information:integration,the process of combining data from different sources to provide a unified view;
\n3. Transactional Data Management
\n 1. Oracle GoldenGate provides low-impact capture, routing, transformation, and delivery of database transactions across heterogeneous environments in real time;
\n 2. Key Capabilities:
\n 1. Real Time:moves with sub-second latency;
\n 2. Heterogeneous:moves changed data across different databases and platforms;
\n 3. Transactional:maintains transaction integrity;
\n 3. Additoinal Differentiators:
\n 1. Performance:log-based capture moves thousands of transactions per second with low impact;
\n 2. Extensibility and Flexibility:meets variety of customer needs and data environments with open, modular architecture;
\n 3. Relibility:resilient against interrputions and failures;
\n4. Technical Architecture Overview;
\n5. Oracle GoldenGate Topologies;
\n6. Oracle GoldenGate Solutions:
\n 1. High Availability and Disaster Torlerance:
\n 1. Live Standby;
\n 2. Active-Active;
\n 3. Zero-Downtime Operations for upgrades, migrations, Maintenance;
\n 2. Real-Time Data Integration:
\n 1. Real-time Data warehousing;
\n 2. Live Reporting;
\n 3. Transactional Data Integration;
\n 3. Oracle GoldenGate Solutions Overview;
\n7. Oracle GoldenGate:Databases and Platforms
\n 1. O\/S and Platforms:
\n 1. Windows 2000, 2003, xp;
\n 2. Linux;
\n 3. Sun Solaris;
\n 4. HP NonStop;
\n 5. HP-UX;
\n 6. HP TRU64;
\n 7. HP OpenVMS;
\n 8. IBM AIX;
\n 9. IBM z\/OS;
\n 2. Databases:
\n 1. Capture:
\n 1. Oracle;
\n 2. Mysql;
\n 3. IBM DB2;
\n 4. MSSQL;
\n 5. Sybase ASE;
\n 6. Ingres;
\n 7. Teradata;
\n 8. Enscribe;
\n 9. SQL\/MP;
\n 10. SQL\/MX;
\n 2. Delivery:
\n 1. all listed above;
\n 2. HP Neoview, Netezza and any ODBC compatible databases;
\n 3. ETL products;
\n 4. JMS message queues or topics;
\n8. Oracle GoldenGate and Oracle Active Data Guard;
\n 1. For information distribution and consolidation, application upgrades and changes:use goldengate-heterogeneous,active-active,transformations,subsetting;
\n 2. for disaster recovery\/data protection\/ha:
\n 1. simple full oracle database protection:use active data guard;
\n 2. applicatoin desiring flexible ha,active-active,schema change,platform changes:use oracle goldengate;
\n 3. combine the two for full database protection and information distribution;
\n9. Oracle GoldenGate Advantages;
\n10. Oracle GoldenGate Director(gg\u7684\u56fe\u5f62\u5316\u7ba1\u7406\u754c\u9762)
\n 1. Manages,defines,configures,and reports on Oracle GoldenGate components;
\n 2. Key features:
\n 1. Centralized management of Oracle GoldenGate modules;
\n 2. Rich-client and Web-based inferfaces;
\n 3. Alert notifications and integration with 3rd-party monitoring products;
\n 4. Real-time feedback;
\n 5. Zero-impact implementation;
\n 3. A graphical enterprise application that offers a visual and intuitive way to define,configure,manage,and report on all GoldenGate transactional data synchronization processes;
\n 4. Prerequisites:
\n 1. oracle weblogic server 11g standard,includes a JDBC driver needed for the Diector repository and appropriate version of JRE;
\n 2. the Director Server repository requires databses:oracle or mysql 5.x;
\n 3. Director installer requires a windows system and Unix or Linux systems;
\n11. Oracle GoldenGate Veridata(\u6570\u636e\u6bd4\u8f83\u5de5\u5177);
\n 1. A high-speed,low impact data comparison solution:
\n 1. identifies and reports data discrepancies between two database without interrupting those systems or the business processes they support;
\n 2. supports Oracle, Teradata, MSSQL, NonStop, SQL\/MP and Enscribe;
\n 3. Support homogeneous and heterogeneous compares;
\n 2. Benefits:
\n 1. Reduce financial\/legal risk exposure;
\n 2. Speed and simplify IT work in comparing data sources;
\n 3. No disruption to business systems;
\n 4. Imporved failover to backup systems;
\n 5. Confident decision-making and reporting;
\n12. Oracle GoldenGate products
\n 1. Oracle GoldenGate:Includes GoldenGate Capture,Deliver and Active Data Guard and XSystem;
\n 2. Oracle GoldenGate for Mainframe:Includes GoldenGate Capture and Deliver for HP NonStop and IMB DB2 on z\/OS;
\n 3. Oracle GoldenGate Veridata:Add-on capability to validate data in replicated systems;
\n 4. Management Pack for GoldenGate:Add-on management pack,includes Oracle GoldenGate Director;
\n 5. Oracle GoldenGate Adapters:Pre-packaged application content,such as for Flat File and Java adapters;
\n13. GodelGate and Streams
\n 1. GoldenGate is Oracle’s strategic replicatoin solution;
\n 2. Streams continues to be a supported Oracle Databases feature;
\n 3. Best Stream technology will be integrated into GoldenGate;<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle GoldenGate Overview 1. Oracle GoldenGate softwar […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-1408","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1408"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1408\/revisions"}],"predecessor-version":[{"id":1409,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1408\/revisions\/1409"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1408"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}