1 / 34

Welcome to Dbvisit Replicate

Welcome to Dbvisit Replicate. Overview and Architecture. Agenda. Introduction to Dbvisit Software Dbvisit Replicate Intro Dbvisit Replicate Architecture Dbvisit Replicate Demo Q&A. Dbvisit. Used in 80+ Countries Trusted by 800 + Companies

allegra-macias
Download Presentation

Welcome to Dbvisit Replicate

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to Dbvisit Replicate Overview and Architecture

  2. Agenda • Introduction to Dbvisit Software • Dbvisit Replicate Intro • Dbvisit Replicate Architecture • Dbvisit Replicate Demo • Q&A

  3. Dbvisit Used in 80+ Countries Trusted by 800+ Companies Worldwide leader in disaster recovery solutions for Oracle Standard Edition Exceptional Product Engineers with “real world” DBA Experience Two Oracle 11g Certified Masters Regular presenters at Oracle events such as OOWand Collaborate Passionate about Oracle Technology

  4. Trusted in 80+ countries. . . . . . By 800+ companies.

  5. Product Lineup World-leading Disaster Recovery Solution for the Oracle SE database Affordable Alternative to GoldenGate: – Data Replication for Oracle-sourced databases

  6. Two Replication Types Physical Replication “One on one” copy of the primary database in permanent recovery Use redo apply to keep up to date 100% binary copy, database are exact replicas Referred to as a standby database Best suited for DR Logical Replication Independent 2nd database in sync by replication mechanism Uses SQL statements to keep up to date Subset of data is replicated Cross version, cross platform Separate physical database structure Best suited for information sharing, migrations, real-time reporting etc

  7. Dbvisit Replicate Logical data replication solution • From Oracle to Oracle, SQL Server, MySQL • Topologies: one to one, one to many, many to one, cascading, unidirectional, bi-directional • Wizard-driven interface • Robust notification capabilities • Automated conflict detection and correction • “Audit” feature

  8. Dbvisit Replicate Use Cases • Offloaded reporting and query environments • Data warehousing • “Audit” feature • Integration with ETL tools • Migration projects • Term licenses • Oracle version upgrades, OS platform, to the Cloud, etc. • Cloud • Migration • Backup • Reporting • DRaaS

  9. Dbvisit Replicate- Architecture Components • Mine • Converts Oracle redo log data into PLOG data • PLOG • “Parsed log file” – binary files specific to Dbvisit Replicate • Platform independent • Apply • Converts PLOG data into target DB native SQL ----------------- • Fetcher (optional) • Offloads Mine process from source server onto intermediary server

  10. Dbvisit Replicate Architecture ① Source Environment • ①Mine • Mines Oracle redo logs and creates PLOG data to move over network

  11. Dbvisit Replicate Architecture LAN ① ② Source Environment • ①Mine • Mines Oracle redo logs and creates PLOG data to move over network • ② PLOG • - Parsed logs – binary files specific to Dbvisit Reporting • - Platform independent

  12. Dbvisit Replicate Architecture LAN ③ ① ② Source Environment Target Environment • ①Mine • Mines Oracle redo logs and creates PLOG data to move over network • ② PLOG • - Parsed logs – binary files specific to Dbvisit Reporting • - Platform independent • ③ Apply • Converts PLOG data into target DB native SQL

  13. Offload MINE using “Fetcher” LAN ④ ③ ① ② Source Environment Target Environment • ①Mine • Mines Oracle redo logs and creates PLOG data to move over network • ② PLOG • - Parsed logs – binary files specific to Dbvisit Reporting • - Platform independent • ③ Apply • Converts PLOG data into target DB native SQL • ④Fetcher (optional) • - Offloads Mine process from Source server onto intermediary server

  14. Offload APPLY LAN ③ ① ② Source Environment Target Environment • ①Mine • Mines Oracle redo logs and creates PLOG data to move over network • ② PLOG • - Parsed logs – binary files specific to Dbvisit Reporting • - Platform independent • ③ Apply • Converts PLOG data into target DB native SQL

  15. Dbvisit Replicate and RDS

  16. Dbvisit Replicate for Migrations Migrations happen! They are a fact of life and are required for any number of reasons including: Bug fixes Platform version or application upgrades New hardware or a migration to the cloud Data centre consolidation – e.g. due to a merger or acquisition Retiring old technology

  17. Migration objectives Migrate previous release database to new release database with: Minimal outage Low risk Low stress Extended testing with live data 100% Data integrity

  18. Dbvisit Replicate for Migrations Install Dbvisit Replicate 1 1 1

  19. Dbvisit Replicate for Migrations 1 Install Dbvisit Replicate Start the MINE process on the Source Database 2 1 1 2

  20. Dbvisit Replicate for Migrations 1 Install Dbvisit Replicate Start the MINE process on the Source Database as of SCN 123 Export the database as of SCN 123 2 3 3 1 1 2

  21. Dbvisit Replicate for Migrations Install Dbvisit Replicate Start the MINE process on the Source Database as of SCN 123 Export the database as of SCN 123 Import the database 1 3 4 2 3 4 1 1 2

  22. Dbvisit Replicate for Migrations 1 Install Dbvisit Replicate Start the MINE process on the Source Database as of SCN 123 Export the database as of SCN 123 Import the database Start the APPLY process 3 4 2 3 4 1 1 5 2 5

  23. Dbvisit Replicate for Migrations Install Dbvisit Replicate Start the MINE process on the Source Database as of SCN 123 Export the database as of SCN 123 Import the database Start the APPLY process When the APPLY process is current point the application to the Target. 1 6 2 3 4 3 4 1 1 5 2 5 6

  24. Dbvisit Replicate Feature Highlight:CDC/Audit real-time BI (ii) This does not maintain a copy of the source table(s), but logs all operations as separate entries.

  25. Dbvisit Replicate Feature Highlight:CDC/Audit real-time BI (ii) • New row inserted in staging • table for every: • Insert • Update • Delete

  26. Automated conflict resolution Dbvisit Replicate offers: • Conflict detection Data divergence triggers a notification • Conflict resolution Identifies source of conflict • Conflict handling Predefined rules handle conflicts automatically (includes setting PL/SQL business rules)

  27. Formal Product Training • Workshop style – combining lecture and hand’s on • Available now: Replicate LTD, XTD, MAX • Coming soon: Standby • Conducted via GoToTraining • Short segments (to fit into work schedule)

  28. Dbvisit Replicate Installation RPM on Linux Tar on Unix Windows installer on Windows Only 1 executable: dbvrep Clean and simple Download a free 30 day trial from our website www.dbvisit.com

  29. Dbvisit Replicate Demos Dbvisit Replicate console overview Oracle to Oracle Oracle to MySQL Other demos are on our "Dbvisit" Youtube channel

  30. Summary: Dbvisit Replicate Advantages • Low-cost, quickly deployed data replication solution for keeping a set of databases in sync, real time • Complete, real time system status overview on one screen • Real time notification and extensive reporting included • Automated conflict detection, handing and resolution capabilities • Configurations easily reran or copied over to new environments • Optional: Offload data mining with “Fetcher” tier

  31. Next steps • Plan and carry out POC test? • Size of redo logs and frequency (high and low volume ranges)? • Script to test for supported / unsupported datatypes

  32. Thank youQuestions and Answers?

  33. Twitter: @dbvisit Blog: blog.dbvisit.com Forum: www.dbvisit.com/forums

More Related