Shareplex

Log Based replication      :   Capture changes to the selected objects  from Oracle redo or  archive log files.

Oracle Supported version    :   Supports multiple Oracle versions, including 8i  through 11gR2,       RAC.

Flexible Data type Support    : Support LOBs , LONG , VARRAY , Oracle advanced
       compression and  Oracle  Table Encryption.

The SharePlex comes licensed with all the tools required for replication,
including data compare-and-repair, synchronization, and graphical interface for managing and monitoring replication activity.

Platform independent  : Source and target can be running different operating systems

         or Oracle versions.

Minimal Overhead    : Does not use DB engine or Oracle SQL*Net . Uses it’s own

         Oracle log reading and queuing technology to capture and ship

         data.

Horizontal partitioning    : To replicate specific rows in table.

Vertical partitioning   :   To replicate specific columns in table.

Minimal Latency  : Even before the commit hits the redo logs, a transaction is

          replicated to the target, where the transaction is completed

         upon receipt of the commit. If the transaction is cancelled,

          SharePlex replicates the rollback so that the target instance is

          an accurate representation of the source database.

•Requires that minimal supplemental logging be set  on the database or  log the primary key / unique  columns of every row.

•Recommend that both primary and unique key supplemental logging be enabled.

•Shareplex key can be primary key , unique key or user-defined key  or it construct a key(least desirable option due to full table scan) using all columns except LOB and LONG.

Recommendations :

Disable Triggers at the target side.

Redo logs size at the source side : No.  of online redo logs – No. of switches in 2 hours   >/=  0

Do not replicate sequences.

Disable ON DELETE CASCADE integrity constraint at the target side.

Disable check constraints on the target system for improved performance.

Set PROCESSES parameter high enough on target .

(peak number of source database sessions) + (peak number of target database

       sessions) + (background Oracle processes) = PROCESSES value

Resolution for out of sync :

Run  compare and repair.

If Archive log is missing , restore the archive log. If sharePlex is several hundred logs behind, consider resynchronizing the data  instead of restoring the logs

To disable the effects of triggers on target objects , run the sp_add_trigger.sql wrapper script, which directs

triggers to ignore the SharePlex Oracle user  or disable the triggers

Export / Import .

Add more space.