What is the syntax for running compare in a Horizontal and/or Vertical partitioned replication environment?
NOTE: This solution refers to Shareplex partitions, NOT Oracle partitions.
When issued for tables that are configured for partitioned replication, the compare
table command determines the rows and columns to compare by reading the configuration
file and, for horizontally partitioned replication, the column conditions in the
For vertically partitioned tables where source and target column names are different,
the compare table command maps the source columns to the target columns and
constructs the correct WHERE clause for each table.
For horizontally partitioned replication, the compare table command reads the column
conditions for the source table and selects rows for the source and target tables
based on those conditions.
Rows and columns that are excluded from replication are not compared or repaired.
Therefore the compare syntax for a table that is vertically and horizontally partitioned is the same as for a regular table
compare table owner.source_table to owner.target_table target target_host @o.target_SID
compare table owner.source_table to owner.target_table target target_host @o.target_SID repair
When running compare in a Horizontal or Vertical partitioned replication environment, Shareplex is only able to compare/repair the rows/columns that form part of replication. If an attempt is made to compare rows/columns that are not part of replication (by using where clause), Shareplex may simply declare them as In Sync. The logic behind this is that Shareplex is only concerned about rows/columns that form part of replication when running compare. Any attempt to determine the state of sync on the basis of non-replicating rows/columns should not make any sense anyway since those rows are not supposed to exist on target.
Another thing to note is that if the where clause includes columns other than the ones participating in horizontal replications column condition, then compare will correctly prescribe the status of sync.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité