How to start a Replicate task with Oracle source endpoint from a requested SCN

OritA — Thu, 02 Dec 2021 11:08:57 GMT

In general - when resuming a Replicate task it is possible to specify the position in the log from where to resume change processing. The source change position format differs according to your source endpoint. In case of a task replicating from Oracle source endpoint it is possible to specify from which SCN to start.

To find the current SCN value you should perform the following command:

SELECT current_scn FROM V$DATABASE;

Example: 1471212002

If you would like to stat a task from an SCN based on and end point of a previous task, to find the required SCN you should perform the following steps:

1. In the log of the task that includes the requested endpoint , locate for a log message that includes information about the final saved task state. The message should be similar to the message below:

[SORTER ]I: Final saved task state. Stream position 00000000.00244d50.00000001.0000.00.0000:8.16348.16,

2. The first two parts of the Stream position (8 bytes) is the SCN from the source, in this example 00000000.00244d50. Convert this value from hex to dec. In this case 0000000000244d50(hex) --> 2379088 (Dec)

3. Now resume the task:

Go to run --> 'advanced run options' under 'Tables are already loaded. Start processing changes from:'
choose ' Source change position (e.g. SCN or LSN):' and indicate the requested SCN number in dec (in above example 2379088 )

Environment

Replicate task with Oracle source endpoint

article How to start a Replicate task with Oracle source endpoint from a requested SCN in Official Support Articles

How to start a Replicate task with Oracle source endpoint from a requested SCN

Environment