This topic describes how to view and modify the migration objects of a data migration task in OceanBase Migration Service (OMS).
Background information
If the limitations are met, you can add or remove migration objects during migration. The changes made during the running of the task will be recorded. When an object addition task is completed, it is integrated with the associated original migration task. When the task integration is completed, the original migration task runs normally and the object addition task is automatically stopped.
Limitations
You can modify the migration objects of a data migration task only if you have selected the Specify Objects option for the task.
For a data migration task in the Not Started, Running, or Stopped state, you can add or remove its migration objects.
Notice
For a data migration task in the Stopped state, you cannot add migration objects if the full migration or incremental synchronization step is in the Stopped state.
For a data migration task in the Failed state, you cannot add migration objects.
For a data migration task in the Modifying or Integrating state, you cannot modify its migration objects again.
If the full migration or incremental synchronization step of a data migration task is in the Stopped or Failed state, you cannot add migration objects.
For a data migration task is in the reverse increment step, you cannot add migration objects.
View migration objects
Log in to the OMS console.
In the left-side navigation pane, click Data Migration.
On the Data Migration page, click the name of the target data migration task to go to its details page.
Click View Objects in the upper-right corner to view information on the Migration Objects and Object Modifications tabs.
The Migration Objects tab displays the migration objects of the current task. You can click Modify Object and then select Add Object or Remove Objects.
The Object Modifications tab displays the IDs, types, status, and time of all object modifications.
Add migration objects
On the details page of the target task, click View Objects in the upper-right corner.
In the View Objects dialog box, choose Modify Object > Add Object.
In the Add Object dialog box, select migration objects in the left-side Source Object(s) section and click > to add them to the right-side list. You can select tables and views of one or more databases as the migration objects.
After you select the migration objects to add, you can perform operations such as renaming objects, setting row-based filtering, and viewing column information.
Notice
By default, the newly added migration objects inherit all configurations of the original data migration task. If you abort the object addition operation, you must manually delete the objects that have been added to the target database.
If you have specified a schema name or database name for the source, you can add only the migration objects under the specified schema name or database name.
Then, click Next.
The system automatically performs a precheck on the added migration objects. After the added migration objects pass all check items, click Save.
Confirm the information and click OK in the dialog box that appears.
For a stopped or failed data migration task, you can cancel the operation and modify the migration objects again. The added migration objects will be migrated to the target database only after the data migration task returns to normal.
If you add migration objects for a running data migration task, after you click Save, the system immediately starts migrating the added migration objects to the target database.
When the object addition operation begins, records are generated. To view details of the records, choose View Objects > Object Modifications. The status of object addition records can be Pending, Canceled, Modifying, Running, Aborted, Integrating, Succeeded, or Failed. The operations that you can perform on an object addition record and the status of the original task depend on the status of the object addition record.
Note
If the original data migration task is in the Not Started state, a modification record in the Succeeded state will be generated for an object addition operation. If the original data migration task is in the Stopped state, a modification record in the Pending state will be generated for an object addition operation.
The status of an object addition record changes only when the original data migration task is in the Running state, and the status of the original task changes along with the status of the object addition record. The following table describes more information.
Status of an object addition record Supported operation Status of the original task Pending View details and cancel the addition. Running Canceled N/A Running Modifying N/A Modifying Running View details and abort the addition. Modifying Aborted View details. Running Integrating View details. Integrating Succeeded View details. Running Failed View details and retry.
You can also click View Cause to go to the details page of the task and view the cause of the failure.Modifying or Integrating
Remove migration objects
On the details page of the target task, click View Objects in the upper-right corner.
In the View Objects dialog box, choose Modify Object > Remove Objects.
In the Remove Objects dialog box, move the pointer over a migration object that you want to remove in the Target Object(s) section on the right and click Remove.
In the Remove Objects dialog box, click Remove.
In the confirmation dialog box that appears, confirm the migration object to remove and click OK.
If the task is in the Stopped, Failed, or Running state, after you click OK, the migration object is immediately removed from the target database.
Notice
A removed migration object cannot be recovered. Proceed with caution.
The final result of the object removal operation is either succeeded or failed for all migration objects.
When the object removal operation begins, records are generated. To view details of the records, choose View Objects > Object Modifications. The status of object removal records can be Pending, Canceled, Modifying, Succeeded, or Failed. The operations that you can perform on an object removal record and the status of the original task depend on the status of the object removal record.
Status of an object removal record Supported operation Status of the original task Pending View details and cancel the removal. Running Canceled N/A Running Modifying N/A Modifying Succeeded View details. Running Failed View details and retry.
You can also click View Cause to go to the details page of the task and view the cause of the failure.Modifying