SharePlex for Oracle A megoldás műszaki ismertetése az OTP Bank Nyrt. számára 2013.05.28

1. SharePlex for Oracle A megoldás műszaki ismertetése az OTP Bank Nyrt. számára 2013.05.28 Nyikes Tamás – sales director Szécsi Balázs – presales mérnök

2. SharePlex® Product Overview SharePlex® for Oracle profoundly alters the economics of Oracle computing. SharePlex is the ultimate data replication solution for Business Critical Applications. SharePlex simplifies data replication to what is specifically needed to fit your business — replicate multiple copies of Oracle data locally, remotely or in-the-cloud for special purposes: • High Availability and Disaster Recovery • Operational Reporting • Migrations or Upgrades • Business Intelligence and Data Warehousing • Scalability (RAC alternative) • Change Tracking

3. Overview (continued) SharePlex® for Oracle is a “Data Availability Solution” for Oracle databases that is affordable, simple to use & easy to manage. • SharePlex has been a leading database replication product since 1998, with a global presence • Gartner 2010 Recommends SharePlex for Oracle to reduce costs with Oracle Standard Edition use • IDC 2010 shows SharePlex with over 19.1% of the Replication market share compared to our closest rival Oracle 25% (inclusive of GoldenGate, Data Guard, Active Data Guard and Streams)

4. SharePlex Customers

5. Industry Leaders Depend on Quest

6. RAC + Data Replication

7. Oracle Enterprise Edition to Oracle Standard Edition Data Replication Offload’s Operational Reporting • Environment • High availability database with 250 GB • SharePlex replication between two locations • Oracle 10g11gR2 • AIX OEE, Windows 2008 OSE, SQL Server • Business Problem • Ad hoc business reports for the customer • Impacting production system is critical • Error prone Export/Import, ETL process = 6 hours nightly • SharePlex Solution • Offload 150GB of data to OSE • Resource and cost savings • Improved IT staff’s reputation and relationship with BU’s

8. SharePlex Technical Overview

9. Why SharePlex® Over Oracle’s Solutions

10. Local, Remote or in-the-Cloud Post Queue Export Queue SharePlex® for Oracle - Product Architecture Export Import SQL Redo/Archive logs Read Target Cloud Target Post Post Capture Queue Source Capture

11. Use Case Scenarios

12. SharePlex® ZeroIMPACT Use Case Scenarios Local, Remote or in-the-Cloud Change Tracking

13. What Makes SharePlex® Different? • Fully automated and easy to use • Download, install and use in just 15 minutes • Expedite staff learning curve with 5 minute how-to videos • Learn from the experts 24x7 in the SharePlex® Community with online forums & blogs • Support for a multitude of platforms (mix and match) • Including Oracle Standard and Enterprise Edition, RAC, Exadata and Oracle 8i to 11g • Get all the functionality in one low price • Flexible licensing options (perpetual or term) • Achieve scalability with or without RAC • Does not require RAC Clusterware software

14. Köszönjük a figyelmet! www.kersoft.hu H-1119 Budapest, Szombathelyi tér 14. Tel: +36-1 206-2147 Fax: +36-1 206-2148 Nyikes Tamás, Szécsi Balázs Tamas.Nyikes@kersoft.hu Balazs.Szecsi@kersoft.hu

15. Supplemental Slides Migrations, SharePlex Manager, Space Manager with LiveReorg

16. Use Case Backup Slides

17. Offload Operational Reporting • Ad hoc querying, reporting, data warehousing or Business Intelligence can be run from a secondary copy of the instance (all or a subset). • Reduces contention, data footprint and improves performance on your production system. • Avoids performance degradation from times of high-volume reporting such as month, quarter or year end. • Immediate business benefits can be achieved offsite. Can be placed on Standard Edition database or in-the-cloud as a cost-effective SaaS Model to provide 24x7 reporting without production impact.

18. High Availability and Disaster Recovery • Ensure Business Continuity to meet five 9’s SLA requirements for unplanned & planned downtime. • Provides an alternate copy of production data for failover in the event of maintenance or downtime. • Ensures production databases are available 24x7. • Ensures high-level of User Experience and avoids loss in revenues or end-user satisfaction due to loss of critical data

19. Migrations, Upgrades and Patches • Migration of application version, database version, hardware platform or sometimes all three. • Decrease downtime by switching users to the replica system while the migration is being performed on production. • Eliminate risk providing a failback if the changes have undesired effect. Supports multiple dry-runs. • Reduce costs and mistakes by performing the changes during working hours.

20. Data Distribution and Distributed Processing • Databases are geographically dispersed over WAN, LAN or Satellite. • Distribute data to different servers, keeping all copies of the database current. • Copies can all be different database versions & indexed differently. • Replicate all or a subset.

21. Load Balancing • Data Replication in place of RAC • Applies conflict resolution as required by the circumstance and as defined by your business rules and needs. • Provides the fastest possible fail over time that can be achieved using any technology in a WAN environment. • Copies can all be different database versions & indexed differently.

22. Centralized Reporting/Consolidation • Consolidation of store(s) or multiple facilities can provide real-time replicate data to the corporate office over LAN, WAN, Cloud or Satellite networks. • Supports large topologies of remote offices / stores to consolidate data centrally. • Posting files can be managed by start/stop to control the flow of data real-time, hourly, daily or as requested to disseminate copies of production data wherever needed.

23. Cascading to Intermediary Systems • Provides regional distribution then allows for district and store distribution of data. • Replicate data between long distances and to targets not directly connected. • No Oracle software is required on this node if it will only be acting to store and forward. • Cascading or Fanning the data allows for different data to reach desired targets without sending all the network packets forward to every target location. • Move data past firewall thru secure servers without the need of Oracle licensing on transporting servers.

24. Change Tracking • For auditing and discovery purposes • Keep track of changes made to a defined set of tables • Records all changes including user id, timestamp, SCN, source row id, key values, transaction id, operation type • Store the change tracking data on the primary server or a secondary server Change Tracking

25. SharePlex ® Migrations

26. Oracle Database Migrations • With traditional migrations, extensive downtime is required: • Export/import data • High risk with in-place upgrades • Increased costs for failures • Can not test new functionality Oracle 11g SharePlex Oracle 9i • With SharePlex, end user downtime is minimized: • The process includes a failback position, rather than forcing you to “go for broke!” • The process allows you to take the time required to be careful, and to be successful.

27. SharePlex® Migration Steps SNAPSHOT, TimeFinder, BCV, RMAN, Export, Datapump, etc. Backup from Prod, Restore to New Production (Recover to SCN or LOG Number) Current Production New Production Capture Queue Export Queue Reconcile Post Queue Replication

28. SharePlex® Migration Steps Reverse Replication Current Production Move users to New Production (Considering Application is ready to accept user connection) New Production Capture Queue Capture Queue Export Queue Export Queue Post Queue Post Queue Replication

29. SharePlex® Reverse Replication (for Failback) Reverse Replication Current Production New Production Capture Queue Capture Queue Export Queue Export Queue Post Queue Post Queue Replication

30. Hardware Migrations AIX Oracle 11g • With traditional methods, extensive downtime is required: • Export/Import data • Rebuild the database • Verify the migration Solaris Oracle 9i SharePlex Export/Import Online backup Staging db • With SharePlex, End user downtime is minimized: • Off load the export from the production database • Optimize database, test new features • Ability to repeat migration with no extra downtime

31. SharePlex® Migration Steps Export, Datapump, RMAN, or Transportable Tablespaces Backup from Prod, Restore to Intermediate (Recover to SCN or LOG Number) Current Production Export from Intermediate, Import to New Platform Intermediate Server must be same platform as Production New Production Capture Queue Export Queue Reconcile Post Queue Replication

32. SharePlex® Migration Steps Reverse Replication Current Production New Production Capture Queue Capture Queue Export Queue Export Queue Post Queue Post Queue Replication

33. SharePlex® Reverse Replication (for Failback) Reverse Replication Current Production New Production Capture Queue Capture Queue Export Queue Export Queue Post Queue Post Queue Replication

34. SharePlex ® Manager

35. SharePlex® Manager Architecture Diagram Target Target Source Source Agent Server SharePlex Monitoring Adaptor Statistic Gathering HTTP access Repository

36. Discovery #1 After installation, discover a SharePlex Infrastructure at first time.

37. Instance Review - Rate - Time Remaining

38. Instance Detail - Processes - Queues - How replication is set up

39. Monitoring Instance Detail > Show Post Detail

40. Monitoring Instance Detail > Manage Monitoring To make a new config Can see the status or can do activate/deactivate

41. Alarms Administration > Rules & Notifications > Manage Rules

42. Alarms Administration Rule Definition

43. Dashboard Report Capture’operations/s ALL Post’operations/s queue10 queue2 queue3 ALL Post’Backlogs Queue10(max : 2Million) queue2

44. How to setup SharePlex ® (typical 24x7) Target Source • Install SharePlex • Build and activate the list of tables to replicate (changes queueing) • Perform an online database backup and recover to Archive log number or SCN • Recover SharePlex to same log or SCN • SharePlex post and query access resume

45. SharePlex® on RAC/ASM • Static Floating IP for machines in RAC (not SCAN) • Installation of SharePlex binaries on all nodes (remember to add the license key for all) • Shared file system so we can see the VARDIR upon failure • Manual script to handle the IP failover and starting SharePlex • oratab entry on each node for ORACLE TNS name of cluster • When running ora_setup, need to specify: • {system password}@TNS • splex/splex@TNS • ASM support is automatic (will find the location based upon meta data within db)

46. BACKUP SLIDESSpace Manager with LiveReorg®

47. Solutions for Business Critical Computing “Profoundly alters the economics of Oracle computing” Replication Oracle Replication and High Availability • Maximum Availability • SLA 99.999% • ZeroIMPACT • Critical Applications Our solution ensures business continuity while meeting your database operational goals. SharePlex text Maximum Availability SharePlex for Oracle Space Manager with LiveReorg Evolved from a long history of replication. This mature solution provides maximum availability ensuring data accuracy with data compare and repair, in-flight data integrity plus monitoring and altering functionalities in a single complete package. The original online reogranization tool. Manage database capacity to control costs and ensure optimal availability of disk space. Resolves performance issues caused by disk-space fragmentation while preventing application & database downtime. Space/LiveReorg text

48. Space Manager with LiveReorg® Optimize I/O and Disk Utilization in Oracle Databases • Patented technology • Think of its functionality like that of the ‘defrag’ tool in Windows • Functionality: • Resolves performance issues caused by disk-space fragmentation • Prevents application & database downtime • Monitors capacity and provides ”what-if” growth analysis. • Business Benefits: • Maximize application performance • Minimize storage costs • Maximize productivity • Minimize application downtime Saves

49. Space Manager with LiveReorg® Use Scenarios • Monitor and plan for future storage • Control database growth and maximize performance • Reorg after archiving, purging, or after many, large updates • Alleviate performance and optimize space usage • Move heavily accessed objects to fast, expensive storage • Move lookup and less accessed objects to slow, inexpensive storage • Separate tables and associated indexes • Migrate from Dictionary Managed to Locally Managed Tablespace • Partition large historical objects

50. SAP – When is a object reorganization useful? These are also pertinent to any OLTP environment • Reduce object size • Cleanup table or index fragmentation • Reduce chained and migrated rows • Reduce number of allocated extents • Change table storage parameters • Move table and/or index to different tablespace • Reduce hot spots on disk level • Activate new Oracle features: Transparent Data Encryption, Compression, SecureFILE LOBs