Help Center/ Data Replication Service/ Best Practices/ Real-Time Synchronization/ From On-Premises Oracle to DDM/ Creating a DRS Synchronization Task
Updated on 2024-07-15 GMT+08:00
View PDF
Share

Creating a DRS Synchronization Task

This section describes how to create a DRS task and synchronize data from an on-premises Oracle database to Huawei Cloud DDM.

Pre-Check

Before creating a task, check whether synchronization conditions are met.

In this example, data is synchronized to DDM. For more details, see Precautions.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click the service list icon on the left and choose Databases > Data Replication Service.
  4. In the upper right corner, click Create Synchronization Task.
  5. Configure synchronization task parameters.

    1. Specify a synchronization task name.

    2. Enter the synchronization task information and select the destination database.

      Select the DDM instance created in Creating a DDM Instance as the destination database.

  6. Click Create Now.

    The synchronization instance is being created. It takes about 5 to 10 minutes.

  7. Configure source and destination database information.

    1. Configure the source database information and click Test Connection. If a successful test message is returned, the database is connected.

    2. Configure the destination database information and click Test Connection. If a successful test message is returned, the database is connected.

  8. Click Next.
  9. On the Set Synchronization Task page, select the synchronization objects.

    • Set Flow Control to No.
    • Set Synchronization Object to Tables.

      Select the databases and tables of the source database to be synchronized. In this bset practice, table3 in test_info is selected and synchronized to table3 in db_test.

  10. Click Next. On the Check Task page, check the synchronization task.

    • If any check fails, review the cause and rectify the fault. After the fault is rectified, click Check Again.
    • If all check items are successful, click Next.

  11. Click Submit.

    Return to the Data Synchronization Management page and check the synchronization task status.

    It takes several minutes to complete.

    If the status changes to Full synchronization, the synchronization task has been started.

    • For synchronization from Oracle to DDM, full synchronization and full+incremental synchronization modes are supported.
    • If you create a full synchronization task, the task automatically stops after the full data is synchronized to the destination.
    • If you create a full+incremental synchronization task, a full synchronization is executed first. After the full synchronization is complete, an incremental synchronization starts.
    • During the incremental synchronization, data is continuously synchronized, so the task will not automatically stop.