Change the Sync Point value for one or more mapped target tables if you want the Applier to start applying changes from a particular point in the source logs or if you need to mark tables for InitialSync resynchronization.
The Sync Point value determines the point up to which InitialSync synchronized the target tables with the source tables. When you run the replication, the Applier skips DML changes that have an SCN
, log coordinate,
or LSN value that is lower than the Sync Point value.
On the
Map Tables
tab, click
Configure Start Point
.
The
Configure Start Point
dialog box appears.
Under
Applier start point
, select a target connection in the
Connection
list.
Select the connection to the target database that contains the table or tables for which you want to change the Sync Point value.
Select one or more target tables for which to change the Sync Point value in one of the following ways:
To filter the tables by schema owner, enter a filter pattern in the
Schema Filter
field. You can use the question mark (?) and asterisk (*) wildcards. For case-sensitive filtering, enclose the filter value in double quotation marks.
To filter the tables by table name, enter a filter pattern in the
Table Filter
field. You can use the question mark (?) and asterisk (*) wildcards. For case-sensitive filtering, enclose the filter value in double quotation marks.
To select the tables individually, hold down the CTRL key and click each table row.
To select all of the mapped tables, either press CTRL + A or right-click any table row and click
Select All
.
To clear all selections, right-click any table row and click
Select None
. To clear all selections and select the tables that were not previously selected, right-click any table row and click
Select Inverse
.
If you need to resynchronize any target tables by using InitialSync, complete the following steps:
Select the target tables that you want to resynchronize and click the
Edit
icon button.
The
Edit Applier SCN
,
Edit Applier Index and Position
,
or
Edit Applier LSN
dialog box appears.
Click the
Resync
button.
The Data Replication Console displays
Resync
in the
Start from SCN
,
Start from Index and Position
,
or
Start from LSN
column for each selected table.
Data Replication sets the Sync Point values for these tables to -1 in the configuration. If you previously saved the configuration, the Data Replication Console prompts you to synchronize these tables when you save the configuration again.
If you want the Applier to start applying change data from the current SCN
, log coordinates,
or LSN
, select one or more target table rows. Then right-click the selection and click
Get SCN From Source
,
Get Index and Position from Source
,
or
Get LSN From Source
.
The current SCN
, log coordinates,
or LSN
values appear in the
Start from SCN
,
Start from Index and Position
,
or
Start from LSN
field for each selected table.
If you want the Applier to start applying change data from a particular SCN
, log coordinates,
or LSN value, complete the following steps:
Select one or more target table rows and click the
Edit
icon button.
The
Edit Applier SCN
,
Edit Applier Index and Position,
or
Edit Applier LSN
dialog box appears.
Enter a valid SCN
, log coordinates,
or LSN value that you want to use as the Sync Point.
For a MySQL binary log file, use the format
log_file_numeric_suffix
:
log_position
.
Click
Set
.
The specified SCN
, log coordinate,
or LSN value appears in the
Start from SCN
,
Start from Index and Position
,
or
Start from LSN
column for all of the selected tables.
For configurations that have multiple targets, repeat steps 2 through 6, as needed, for each target connection.
To undo changes that you made in steps 4, 5, or 6, click the