Welcome to dbvisit replicate
This presentation is the property of its rightful owner.
Sponsored Links
1 / 34

Welcome to Dbvisit Replicate PowerPoint PPT Presentation


  • 134 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Welcome to dbvisit replicate

Welcome to Dbvisit Replicate

Overview and Architecture


Agenda

Agenda

  • Introduction to Dbvisit Software

  • Dbvisit Replicate Intro

  • Dbvisit Replicate Architecture

  • Dbvisit Replicate Demo

  • Q&A


Dbvisit

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


Trusted in 80 countries

Trusted in 80+ countries. . .

. . . By 800+ companies.


Product lineup

Product Lineup

World-leading Disaster Recovery

Solution for the

Oracle SE database

Affordable Alternative to GoldenGate: –

Data Replication for

Oracle-sourced databases


Two replication types

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


Welcome to dbvisit replicate

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


Dbvisit replicate use c ases

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


  • Dbvisit replicate architecture components

    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


    Welcome to dbvisit replicate

    Dbvisit Replicate Architecture

    Source

    Environment

    • ①Mine

      • Mines Oracle redo logs and creates PLOG data to move over network


    Welcome to dbvisit replicate

    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


    Welcome to dbvisit replicate

    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


    Welcome to dbvisit replicate

    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


    Welcome to dbvisit replicate

    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


    Dbvisit replicate and rds

    Dbvisit Replicate and RDS


    Dbvisit replicate for migrations

    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


    Migration objectives

    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


    Dbvisit replicate for migrations1

    Dbvisit Replicate for Migrations

    Install Dbvisit Replicate

    1

    1

    1


    Dbvisit replicate for migrations2

    Dbvisit Replicate for Migrations

    1

    Install Dbvisit Replicate

    Start the MINE process on the Source Database

    2

    1

    1

    2


    Dbvisit replicate for migrations3

    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


    Dbvisit replicate for migrations4

    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


    Dbvisit replicate for migrations5

    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


    Dbvisit replicate for migrations6

    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


    Dbvisit replicate feature highlight cdc audit real time bi ii

    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.


    Dbvisit replicate f eature h ighlight cdc audit real time bi ii

    Dbvisit Replicate Feature Highlight:CDC/Audit real-time BI (ii)

    • New row inserted in staging

    • table for every:

    • Insert

    • Update

    • Delete


    Automated conflict resolution

    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)


    Formal product training

    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)


    Welcome to dbvisit replicate

    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


    Welcome to dbvisit replicate

    Dbvisit Replicate

    Demos

    Dbvisit Replicate console overview

    Oracle to Oracle

    Oracle to MySQL

    Other demos are on our "Dbvisit" Youtube channel


    Summary dbvisit replicate advantages

    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


    Next steps

    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


    Thank you questions and answers

    Thank youQuestions and Answers?


    Welcome to dbvisit replicate

    Twitter: @dbvisit

    Blog: blog.dbvisit.com

    Forum: www.dbvisit.com/forums


  • Login