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.
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.
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.