SharePlex ® for Oracle

1. SharePlex® for Oracle A detailed technical presentation January 2001

2. Presentation Overview • Introduction to Quest Software • What is SharePlex for Oracle? • Configuration options • SharePlex architecture • Customer uses and results with SharePlex • Complementary solutions

3. DEVELOP/DEPLOY MANAGE DB Server Development DB Change Management Database Performance Management High Availability DB & Application Monitoring Application Offloading The Complete Quest Solution

4. SharePlex Continuous, real-time (LAN or WAN) • 24x7 Alternate Server • Relocate activities that reduce or • cause spikes in OLTP performance • - Reports & Queries • - Backups & Extracts • Reduces risks of unplanned downtime • Protection from ORA-600s • Protection from table drops • Reduced stress on OLTP system OLTP Server • Provides up to 80% OLTP • performance improvement at • month-end by relocating • reports & queries • Enables higher daily SLA • Reduces planned downtime for • end users by enabling rolling • OS and ORACLE upgrades • Reduces planned downtime for • routine maintenance because • business can continue on the • other database SharePlex®High-Speed, Log-Based ReplicationProvides Continuous Access to Continuously Updated Target Instances

5. Configuration Options Reporting Instance Fail-over Active/Active Data Distribution Consolidation Discrete 2-Way Tables A, B, C Tables X, Y, Z

6. SharePlex and Clustering LAN or WAN Remote Database Local Cluster

7. How to Set up SharePlex with Automated Failover WWW users SharePlex We have customers who’ve used tools from Resonate, F5 Labs, Tuxedo, and Internap

8. Design Goals High speed replication • Continuous: Uninterrupted access to target database • Lightweight: Minimal impact on the source • Complete: supports all Oracle data types • Accurate: respects Oracle’s read consistency • Fault tolerant: can withstand failures • Flexible, configurable, and manageable • Differing platforms, O/S, Oracle versions, & schemas • Many different replication topologies, easy to change

9. Archive Logs Capture Process Reader Q On-line Redo Logs Reader Process Export Process ExportQ Source System Quest Transport Layer Network Target System Import Process Post Q Architecture Post Process SQL

10. SharePlex Control Options

11. How to Setup SharePlex 5.SharePlex Post and Query Access Resume 3. DBCopy performs a hot backup from the source to the target system. 1.SharePlex Post is Stopped 4. SharePlex reconciles its queues SharePlex 2. Config listing tables to replicate is activated.

12. The target instance on the 3rd mirror is accessible for queries SharePlex replicates the transactions as they occur SRDF from EMCsynchronously replicates to the target for DR SharePlex Overdrive + EMC2 Corp. Offerings 3rd Mirror SharePlex EMC’sTimeFinder™ periodically refreshes the environment with updates to files outside the database, and/or with DDL changes SRDF™

13. Protection from ORA600 Datafile Corruption Errors Continuous updates increase value of reports Target database is always accessible Offloading queries improves OLTP performance SharePlex Improves a Mirrored Environment 3rd Mirror SharePlex Overdrive • Benefits: • Reduces setup time • Simplifies DDL changes • Enables hot resync option • Facilitates live activation • Allows hot DBCopy

14. Overdrive and Physical Refresh 4.SharePlex Post and Query Access Resume 1.SharePlex Post is Stopped 3rd Mirror 2. Refresh SharePlex 3.SharePlex Reconciles its Queues

15. Audit SharePlex with DataEquator • Problem: Discover out of sync conditions too late • Solution: SharePlex 3.0 offers DataEquator • Compares the content of source and target tables without locking the source table • Background job to periodically audit key tables

16. High Availability Benefits • Reduces Risks of Unplanned Downtime • Protects against software bugs like block corruptions • Insulates from hardware failure • Shields from human error • Reduces stress on production instance by enabling processing to be offloaded to target instance` • Minimizes Planned Downtime • Enables hardware migration • Facilitates rolling upgrades • Supports major preventive maintenance

17. Minimize Downtime to Migrate • Without SharePlex, extensive downtime is required to: • Export/import data • Rebuild the database • Verify the migration Ultimate target Intermediate SharePlex Primary SharePlex • With SharePlex, end-user downtime can be minimized - Failback position, rather than forcing you to “go for broke” - Allows you to take the time required to be careful and successful

18. Stop Post during an export • Setup replication to the new h/w Using SharePlex for Migration Ultimate target 1. Use DBCopy or Overdrive with a hot backup to create the intermediate database Intermediate SharePlex Primary SharePlex • Import the data onto the new h/w platform • Start Post to update the target with the updates from the primary system

19. Using SharePlex for Major Maintenance 4.SharePlex Post and Query Access Resume 3. A new SharePlex version is installed on the target 1.SharePlex Post is Stopped 2. OS / Oracle upgrade or database rebuild is performed on the target SharePlex

20. Customer Performance Tests Batch Processing • Sun E6000 source; Sun E4500 target • Inserted 4,000,000 rows • Completed on target 10 minutes later • 350 MB of data over LAN (source to target) • Bottom Line: 3000 inserts per second during the test Network Use • Using a trigger solution, replication would saturate multiple large lines, while replicating less data • SharePlex replicating all data (long columns, sequences) never saturated smaller line

21. Customer Performance Tests Performance during a Large Import • Unmodified installation - 32 minutes • Internalized triggers - 67 minutes • SharePlex - 33 minutes Installation and Maintenance • SharePlex can be installed in an hour • Full implementation in 3-10 days (or more for multi-master) • One-fifth of a DBA’s time during the first year

22. Replication Tool Kit Space Manager Enables easy analysis and correction of space issues SQLab Vision Identifies tuning opportunities with expert advice Schema Manager Propagates DDL Facilitates instance optimization SpotLight™ for Oracle Real-time graphical representation of the instance

23. Complementary Quest Solutions SharePlex FS™ Replicates files in the file system Foglight™ Enterprise lights-out monitor with drop-in components • Oracle instance • File system • Server • Network LiveReorg™ Hot reorgs for 24x7 operations

24. How LiveReorg Works

25. For More Information • To read, see, and hear how our customers have used SharePlex: http://www.quest.com/shareplex/press-white-case.asp (This contains case studies, video testimonials, white papers, and press releases.) • Joint presentations explaining how SharePlex solved specific issues at Lucent Technology and at LSI Logic, are also on our website: www.quest.com

26. 1. High performance Low latency Low overhead High volumes 2. Access to continuously updated targets 3. Complete Long columns Sequences 4. Accurate Maintains Oracle’s Read Consistency 5. Faulttolerant Log wraps Instance failure Physical corruption Accidental drops Server failure Network failure 6. LAN & WAN support 7. Flexible configuration options 8. Easier to implement and Manage SharePlex is the Best