GCOUG_goldengate.ppt

1、Oracle 8i or 9i to version 10g Upgrading or Migrating with Eliminated Downtime,GCOUG Meeting, October 17, 2007 Chuck Duncan, Sr. Solutions Consultant,Challenges for Major Upgrade/Migration Projects,Maintaining SLA during planned outage Revenue Impact Customer Expectations Interdependencies, Integrat

2、ion Synchronization issues Incremental data movement Source database impact,Data issues Instantiating Terabytes/Petabytes Staging areas Change Management Special Handling Fail-back strategy System/Application verification Continued data growth,Possible Technologies Evaluated for Oracle Migrations,Ex

3、port/Import Flat files/SQL*Loader Data Pump Synchronous replication Backup/Recovery,Transportable tablespaces Cross-platform transportable tablespaces Standby databases Oracle Streams Transactional Data Management,Non Mission-Critical Systems,High Availability Systems,Technology Choices for Oracle M

4、igrations: Considerations,Assume a moderate to significant amount of planned downtime Significant overhead on the source database No ongoing management of transactions Complex, error prone, unmanageable Migration time dependent on size of data No manageable failback strategy No real-time data verifi

5、cation strategy,Export/Import Flat files/SQL*Loader Data Pump Synchronous replication Backup/Recovery,Non Mission-Critical Systems,Technology Choices for Oracle Migrations: Considerations,Transportable Tablespaces No updates possible No incremental solution No failback solution No 9i-10g Cross Platf

6、orm Standby Databases (logical) No rolling upgrade in 9i Cannot be used for heterogeneous migration/upgrade No real-time verification solution Streams No rolling upgrade in 9i Limited datatype support (e.g. no LONG support in 9i) No real-time verification solution Heterogeneity very complex,Transpor

7、table tablespaces Cross-platform transportable tablespaces Standby databases Oracle Streams Transactional Data Management,High Availability Systems,Available Solutions/Techniques & Tradeoffs,Transactional Data Management,Real-time capture, routing, transformation, delivery, and verification of data

8、transactions across heterogeneous environments with low impact.,TDM is: Real time Moves data with sub-second latency Heterogeneous Moves transactions across different databases and platforms Transactional Maintains transaction integrity,GoldenGate further differentiates on: Performance Handles thous

9、ands of transactions per second with very low overhead Extensibility & Flexibility Open architecture, modularity enables wide range of solutions Reliability Supports continuous operations and availability,GoldenGate TDM for Oracle Database Capture,LAN / WAN / Internet,Oracle Database,Target Database

10、,Trail files: Universal data format enables heterogeneity.,Route: No distance constraints via TCP/IP. Compression & encryption.,Capture: Committed changes are captured (and can be filtered) as they occur by reading the transaction logs.,Delivery: Applies transactional data with guaranteed integrity.

11、,redo log,Oracle 8i or 9i to 10g Upgrades/Migrations,What TDM offers: Minimal impact and continuous availability during the project Technology solution for eliminating database downtime Improved capabilities for data integrity, accuracy Fail-back solution in the event of unexpected issues/downtime P

12、roven with customers in production,No Downtime Migration: 9i 10g Cross-Platform,9i Solaris,Start GoldenGate TDMs Capture process Set up Clone database, then Upgrade to 10g Cross platform transportable tablespaces metadata export Use a full database NOROWS export (Views, Packages, etc),9i Clone 10g S

13、olaris,No Downtime Migration: 9i 10g Cross-Platform,9i Solaris,9i Clone 10g Solaris,10g Linux,Start GoldenGate TDMs Capture process Set up Clone database, then Upgrade to 10g Cross platform transportable tablespaces metadata export Use a full database NOROWS export (Views, Packages, etc) Set up a ne

14、w 10g vanilla target,Cross platform transportable tablespaces metadata import Full import with IGNORE option,No Downtime Migration: 9i 10g Cross-Platform,9i Solaris,9i Clone 10g Solaris,10g Linux,Start GoldenGate TDMs Capture process Set up Clone database, then Upgrade to 10g Cross platform transpor

15、table tablespaces metadata export Use a full database NOROWS export (Views, Packages, etc) Set up a new 10g vanilla target,Cross platform transportable tablespaces metadata import Full import with IGNORE option Start GoldenGate TDM Apply process at target *SWITCHOVER* (not depicted),No Downtime Migr

16、ation: 9i 10g Cross-Platform,9i Solaris,10g Linux,Start GoldenGate TDMs Capture process Set up Clone database, then Upgrade to 10g Cross platform transportable tablespaces metadata export Use a full database NOROWS export (Views, Packages, etc) Set up a new 10g vanilla target,Cross platform transpor

17、table tablespaces metadata import Full import with IGNORE option Start GoldenGate TDM Apply process at target Verify data (optional) *SWITCHOVER* (not depicted) Start TDM Capture at target (new source) Start TDM Apply at target (old source),9i Clone 10g Solaris,Failback contingency,TDM in Summary,Go

18、ldenGate Major Customer Examples,Database and/or Platform Migrations in all-Oracle environments: O: Oracle 9i on Linux Oracle 10g on AIX HP internal testing: Oracle 9i on HP Tru64 Oracle 9i on HP UX Cerners Millennium Application: Oracle 9i on OpenVMS Oracle 10g on HP UX or AIX Migrations from non-O

19、racle to Oracle database environments: Sabre Holdings: HP Nonstop Oracle Siebel on Demand: IBM DB2 Oracle Integrating non-Oracle data into Oracle BI systems: Dell: OLTP on HP NonStop Oracle Data Warehouse AMD: IBM DB2 Oracle reporting database,GoldenGates Partnership with Oracle: Highlights,Oracle C

20、ertified Partner (worldwide) since fall 2006 Oracle Database 11g beta test partner Oracle Modernization Alliance member partner (July 2007) Siebel CRM - GoldenGate TDM has Validated Integration Oracle Data Integrator Proven solutions for real-time data integration and warehousing,Solution Focus Area

21、s for Oracle Customers,High Availability & Disaster Tolerance Unplanned Outages: Live (Hot) Standby “Planned Outages”: Oracle database upgrades & migrations Application, platform migrations Non-Oracle to Oracle migrations Performance & Transaction Load Balancing: Active-Active,Real-Time Data Integra

22、tion Real-Time Data Warehousing (with transformation support) Offload Live “Real-Time” Reporting Data Consolidation Oracle Data Hubs,GoldenGate TDM: Heterogeneity Supports Applications Running On,TDM Key Architecture Features,Log-based extraction Reads transaction logs directly, enabling advanced ch

23、anged data capture with high performance and minimum impact to source systems. Routing, flexible topologies Enables users to support various topologies, such as one-to-one, many-to-one, one-to-many, many-to-many, and bi-directional movement of data. Dynamic rollback and selective recovery Point-in-t

24、ime and selective recovery. Data filtering and transformations Table and row filtering can be applied based on user-defined criteria. Users can map, enrich, translate, and transform transactional data in real time as it is captured or applied to target systems. Archival and Audit Capabilities Custom

25、ization: User Exits, Stored Procedures and Queries, Macros Compression and Encryption,GoldenGate Veridata,“GoldenGate Veridata is a high-speed, low impact data comparison solution that identifies and reports data discrepancies between two databases, without interrupting those systems or the business

26、 processes they support.” Benefits: Reduce risk exposure and act on data discrepancies sooner Speed and simplify IT work in comparing data sources No disruption to business systems,GoldenGate Veridata,Key features: Support for large data volumes Comparisons ran while data sources are kept online Fle

27、xible reporting for discrepancy analysis Unparalleled speed and efficiency Selective comparison options Oracle to Oracle HP NonStop to NonStop Enscribe & SQL/MP,GoldenGate Veridata: How it Works,The user chooses tables or files on the source and target databases The comparison is initiated from the

28、GUI, command line or batch As the databases continue to change, GoldenGate Veridata reports: Persistent discrepancies In-flight data discrepancies (user configurable),GoldenGate Veridata: Architectural Advantages,Initial read and local conversion to a digital signature: Maximum speed Minimal network

29、 load Optional unstructured read and server side sorting Two step comparison cycle allows for: Operation on replicated production system intelligent identification of “In flight” records Extremely fast! In testing on moderate hardware 25,000 rows/sec No interruption of service,Thank you., ,Oracle 9i

30、 Oracle 10g LinuxAIX,Enterprise Data Warehouse,Oracle 9i Oracle 10g LinuxAIX,Oracle 9i Oracle 10g LinuxAIX,Case Study: OMultiple Enterprise Solutions Drive Revenue, Enhanced BI,Business Challenges: Minimize downtime for e-commerce systems during database & platform migration Improve Business Intelli

31、gence by reducing data latency for the data warehouse Gain a single view of the customer to better understand purchasing habits, refine marketing campaigns to be more targeted, and ultimately drive more business Implement a reliable, in-house disaster recovery solution GoldenGate Solution: Zero down

32、time during migration project for 3 business-critical e-commerce systems Enabled an operational Teradata EDW through real-time data integration from e-commerce systems High Availability for Teradata to balance transaction load and enable failover solution,“Accessing the data in real time using GoldenGate we can immediately see if were profitable and if our business processes are working.” - Sam Peterson, SVP Technology, O,Hig