How to Use Online Refresh for Initial Load or Full Re-initialization

Question

How can I use Online Refresh for initial load or full re-initialization?

Environment

HVR 5

Answer

This procedure assumes that the replication jobs are fully initialized and capture time has been positioned before the start of the oldest open long-running transaction on the source. The full load can be done for all tables in the channel or just for selected tables.

We recommend the following procedure:

1. Open the Refresh dialog.

2. Select the source and target location(s).

3. Select the tables that need to be refreshed.

4. Select the level of parallelism for the tables.

5. Select the Online Refresh option and set Skip Previous Integrate. This is because we assume two integrate locations.

6. Select the Schedule box and choose a sensible name for the refresh task.

7. Click Schedule.

8. Suspend the integrate jobs. You can leave the capture jobs running.

9. (Optionally) Go to the Scheduler, select the refresh job that has just been created, and choose New Attribute.

10. Create a retry_max attribute and set this to the desired value. 0 means no retry.

11. Right-click the refresh job and click Start to run the job.