shareplex for oracle
Download
Skip this Video
Download Presentation
SharePlex ® for Oracle

Loading in 2 Seconds...

play fullscreen
1 / 27

SharePlex ® for Oracle - PowerPoint PPT Presentation


  • 827 Views
  • Uploaded on

SharePlex ® for Oracle. A detailed technical presentation. January 2001. Presentation Overview. Introduction to Quest Software What is SharePlex for Oracle? Configuration options SharePlex architecture Customer uses and results with SharePlex Complementary solutions. DEVELOP/DEPLOY.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SharePlex ® for Oracle' - carlow


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
shareplex for oracle

SharePlex® for Oracle

A detailed technical presentation

January 2001

presentation overview
Presentation Overview
  • Introduction to Quest Software
  • What is SharePlex for Oracle?
  • Configuration options
  • SharePlex architecture
  • Customer uses and results with SharePlex
  • Complementary solutions
slide3
DEVELOP/DEPLOY

MANAGE

DB Server Development

DB Change Management

Database Performance Management

High Availability

DB & Application Monitoring

Application Offloading

The Complete Quest Solution

slide4
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
slide5
Configuration Options

Reporting Instance

Fail-over

Active/Active

Data Distribution

Consolidation

Discrete 2-Way

Tables A, B, C

Tables X, Y, Z

shareplex and clustering
SharePlex and Clustering

LAN or WAN

Remote

Database

Local

Cluster

how to set up shareplex with automated failover
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

design goals
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
architecture
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

how to setup shareplex
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.

shareplex overdrive emc 2 corp offerings
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™

shareplex improves a mirrored environment
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
overdrive and physical refresh
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

audit shareplex with dataequator
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
high availability benefits
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
minimize downtime to migrate
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

using shareplex for migration
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
using shareplex for major maintenance
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

customer performance tests
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
customer performance tests21
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
replication tool kit
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

complementary quest solutions
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

for more information
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
shareplex is the best
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
ad