OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Migration Service

V4.2.3Enterprise Edition

  • OMS Documentation
  • OMS Introduction
    • What is OMS?
    • Terms
    • OMS HA
    • Architecture
      • Overview
      • Hierarchical functional system
      • Basic components
    • OMS Oracle full data migration design and impact
    • Limitations
  • Quick Start
    • Data migration process
    • Data synchronization process
  • Deploy OMS
    • Deployment types
    • System and network requirements
    • Memory and disk requirements
    • Environment preparations
    • Single-node deployment
    • Deploy OMS on multiple nodes in a single region
    • Deploy OMS on multiple nodes in multiple regions
    • Integrate the OIDC protocol to OMS to implement SSO
    • Scale out OMS
    • Check the deployment
    • Deploy a time-series database (Optional)
  • OMS console
    • Log on to the OMS console
    • Overview
    • User center
      • Configure user information
      • Change your logon password
      • Log off
  • Data migration
    • Migrate data from an Oracle database to an Oracle tenant of OceanBase Database
    • Migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database
    • Migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database
    • Migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database
    • Overview
    • Migrate data from an Oracle database to a MySQL tenant of OceanBase Database
    • Active-active disaster recovery between OceanBase databases
    • Migrate data from a TiDB database to a MySQL tenant of OceanBase Database
    • Migrate data from a MySQL tenant of OceanBase Database to a MySQL database
    • Migrate data within OceanBase Database
    • Migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database
    • Migrate data from an Oracle tenant of OceanBase Database to an Oracle database
    • Migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database
    • Migrate data from a MySQL database to a MySQL tenant of OceanBase Database
    • Migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database
    • Supported DDL operations and limits for synchronization
      • DDL synchronization from a MySQL database to a MySQL tenant of OceanBase Database
        • Overview of DDL synchronization from a MySQL database to a MySQL tenant of OceanBase Database
        • CREATE TABLE
          • Create a table
          • Create a column
          • Create an index or a constraint
          • Create partitions
        • Data type conversion
        • ALTER TABLE
          • Modify a table
          • Operations on columns
          • Operations on constraints and indexes
          • Operations on partitions
        • TRUNCATE TABLE
        • RENAME TABLE
        • DROP TABLE
        • CREATE INDEX
        • DROP INDEX
        • DDL incompatibilities between a MySQL database and a MySQL tenant of OceanBase Database
          • Overview
          • Incompatibilities of the CREATE TABLE statement
            • Incompatibilities of CREATE TABLE
            • Column types that are supported to create indexes or constraints
          • Incompatibilities of the ALTER TABLE statement
            • Incompatibilities of ALTER TABLE
            • Change the type of a constrained column
            • Change the type of an unconstrained column
            • Change the length of a constrained column
            • Change the length of an unconstrained column
            • Delete a constrained column
          • Incompatibilities of DROP INDEX operations
      • Synchronize DDL operations from a MySQL tenant of OceanBase Database to a MySQL database
      • DDL operations for synchronizing data from an Oracle database to an Oracle tenant of OceanBase Database
        • Overview
        • CREATE TABLE
          • Overview
          • Create a relational table
            • Create a relational table
            • Define columns of a relational table
          • Virtual columns
          • Regular columns
          • Create partitions
            • Overview
            • Partitioning
            • Subpartitioning
            • Composite partitioning
            • User-defined partitioning
            • Subpartition templates
          • Constraints
            • Overview
            • Inline constraints
            • Out-of-line constraints
        • CREATE INDEX
          • Overview
          • Normal indexes
        • ALTER TABLE
          • Modify tables
          • Modify, drop, and add table attributes
          • Column attribute management
            • Modify, drop, and add column attributes
            • Rename a column
            • Add columns and column attributes
            • Modify column attributes
            • Drop columns
          • Modify, drop, and add constraints
          • Partition management
            • Modify, drop, and add partitions
            • Drop partitions
            • Drop subpartitions
            • Add partitions and subpartitions
            • Modify partitions
            • Truncate partitions
        • DROP TABLE
        • COMMENT
        • RENAME OBJECT
        • TRUNCATE TABLE
        • DROP INDEX
        • DDL incompatibilities between an Oracle database and an Oracle tenant of OceanBase Database
          • Overview
          • Incompatibilities of CREATE TABLE
          • Incompatibilities in table modification operations
            • Incompatibilities of ALTER TABLE
            • Change the type of a constrained column
            • Change the type of an unconstrained column
            • Change the length of a constrained column
            • Change the length of an unconstrained column
      • Synchronize DDL operations from an Oracle tenant of OceanBase Database to an Oracle database
      • Synchronize DDL operations from a DB2 LUW database to an Oracle tenant of OceanBase Database
      • Synchronize DDL operations from an Oracle tenant of OceanBase Database to a DB2 LUW database
      • Synchronize DDL operations from a DB2 LUW database to a MySQL tenant of OceanBase Database
      • Synchronize DDL operations from a MySQL tenant of OceanBase Database to a DB2 LUW database
      • DDL synchronization between MySQL tenants of OceanBase Database
      • DDL synchronization between Oracle tenants of OceanBase Database
    • Manage data migration projects
      • Start and pause a data migration project
      • Use tags to manage data migration projects
      • Download and import settings of migration objects
      • View and modify migration objects
      • Rename a data migration project
      • Release and delete a data migration project
      • View details of a data migration project
      • Perform batch operations on data migration projects
  • Data synchronization
    • Synchronize data from an IDB logical table to a physical table in a MySQL tenant of OceanBase Database
    • Synchronize data from OceanBase Database to a RocketMQ instance
    • Synchronize data from an ODP logical table to a DataHub instance
    • Synchronize data from OceanBase Database to a DataHub instance
    • Overview
    • Synchronize data from OceanBase Database to a Kafka instance
    • Synchronize data from an Oracle database to a DataHub instance
    • Synchronize data from an IDB logical table to a DataHub instance
    • Synchronize data from a MySQL database to a DataHub instance
    • Synchronize data from an ODP logical table to a physical table in a MySQL tenant of OceanBase Database
    • Manage data synchronization projects
      • View details of a data synchronization project
      • Download and import the settings of synchronization objects
      • View and modify synchronization objects
      • Release and delete a data synchronization project
      • Start and pause a data synchronization project
      • Perform batch operations on data synchronization projects
      • Change the name of a data synchronization project
      • Use tags to manage data synchronization projects
  • Create and manage data sources
    • Create a database user
    • Enable binlogs for the MySQL database
    • Minimum privileges required when an Oracle database serves as the source
    • User privileges
    • Create data sources
      • Create a RocketMQ data source
      • Create an Oracle data source
      • Create a DB2 LUW data source
      • Create a TiDB data source
      • Create a PostgreSQL data source
      • Create a Kafka data source
      • Create a DataHub data source
      • Create a MySQL data source
      • Create an OceanBase data source
        • Create an ODP data source
        • Create an IDB data source
        • Create a public cloud OceanBase data source
        • Create a physical OceanBase data source
    • Manage data sources
      • Copy a data source
      • Delete a data source
      • Edit a data source
      • View data source information
  • OPS & Monitoring
    • Go to the overview page
    • O&M overview
    • Components
      • Full-Import
        • Rerun and resume a Full-Import component
        • Pause a Full-Import component
        • Delete a Full-Import component
        • View details of a Full-Import component
        • Update the configurations of a Full-Import component
      • Full-Verification
        • View details of a Full-Verification component
        • Delete a Full-Verification component
        • Rerun and resume a Full-Verification component
        • Update the configurations of a Full-Verification component
        • Pause a Full-Verification component
      • Incr-Sync
        • Update the configurations of an Incr-Sync component
        • View details of an Incr-Sync component
        • Migrate an Incr-Sync component
        • Delete an Incr-Sync component
        • Start and pause an Incr-Sync component
        • Batch O&M
      • Store
        • Create a store
        • Start and pause a store
        • Update the configurations of a store
        • Delete a store
        • View details of a store
    • Server
      • Update the quota
      • View server logs
      • View server information
    • Parameter Template
      • Overview
      • Component parameters
        • Full-Import parameters
        • Store parameters
        • Full-Verification parameters
        • Supervisor parameters
        • Incr-Sync parameters
        • CM parameters
      • Component Template
        • Delete a component template
        • Copy and export a component template
        • View and edit component templates
        • Create a component template
      • Project Template
        • Create a project template
        • Copy and export a project template
        • View and edit project templates
        • Delete a project template
    • O&M Task
      • Retry a task or subtask
      • Skip a task or subtask
      • View O&M tasks
  • System management
    • Operation audit
    • Associate with OCP
    • System parameters
      • Modify HA configurations
      • oblogproxy parameters
      • Modify system parameters
    • Permission Management
      • Manage departments
      • Manage users
      • Overview
    • Alert center
      • Manage alert settings
      • View system alerts
      • View project alerts
  • Troubleshooting Guide
    • OMS logs
    • Set throttling
    • Store performance diagnostics
    • Manage OMS services
    • Component tuning
      • Oracle store tuning
      • Incr-Sync/Full-Import tuning
    • Component O&M
      • CLI-based O&M for the Connector component
      • O&M operations for the Supervisor component
      • O&M operations for the Store component
  • Reference Guide
    • OMS error codes
    • SQL statements for querying table objects
    • Create a trigger
    • Change the log level for a PostgreSQL instance
    • Features
      • Change the topic
      • Hidden column mechanisms
      • Column filtering
      • Rename a migration or synchronization object
      • DML filtering
      • Configure matching rules for migration objects
      • Data formats
      • Use SQL conditions to filter data
      • DDL synchronization
      • Instructions on schema migration
      • Set an incremental synchronization timestamp
      • Create and update a heartbeat table
      • Wildcard patterns supported for matching rules
    • API Reference
      • StopProject
      • Overview
      • ListProjects
      • CreateOceanBaseODPDataSource
      • DescribeProjectStepMetric
      • ListProjectFullVerifyResult
      • DeleteProject
      • ResumeProject
      • DescribeProject
      • CreateMysqlDataSource
      • DeleteDataSource
      • CreateOceanBaseDataSource
      • CreateLabel
      • ListProjectModifyRecords
      • ListAllLabels
      • CreateProjectModifyRecords
      • CancelProjectModifyRecord
      • DescribeProjectSteps
      • ListDataSource
      • StartProjectsByLabel
      • ReleaseProject
      • RetryProjectModifyRecords
      • StartProject
      • DescribeProjectProgress
      • StopProjectsByLabel
      • DescribeProjectComponents
      • CreateProject
      • StopProjectModifyRecords
      • SubmitPreCheck
      • GetPreCheckResult
    • Alert Reference
      • oms_host_down_migrate_resource
      • oms_sync_status_inconsistent
      • oms_host_threshold
      • oms_migration_delay
      • oms_host_down
      • oms_sync_delay
      • oms_migration_failed
      • oms_sync_failed
  • Upgrade Guide
    • Overview
    • Upgrade OMS in single-node deployment mode
    • Upgrade OMS in multi-node deployment mode
    • FAQ
  • FAQ
    • Data migration
      • Incremental synchronization
        • How do I migrate an Oracle database object whose name exceeds 30 bytes in length?
        • How do I update whitelists and blacklists?
        • What are the application scope and limits of ETL?
        • How do I skip DDL statements?
      • Full migration
        • How do I query the ID of a checker?
        • How do I query log files of the Checker component of OMS?
        • What do I do if garbled characters cannot be written into OceanBase Database V3.1.2?
        • What can I do when the full migration failed due to LOB fields?
        • What do I do if the destination table does not exist?
        • How do I query the verification result files of the Checker component of OMS?
      • User privileges
        • What privileges do I need to grant to a user during data migration to or from an Oracle database?
    • Project diagnostics
      • What do I do when a store does not have data of the timestamp requested by the downstream?
      • What do I do when OceanBase Store failed to access an OceanBase cluster through RPC?
      • How do I troubleshoot common problems with Oracle Store?
      • How do I use LogMiner to pull data from an Oracle database?
      • How do I perform performance tuning for Oracle Store?
      • What do I do when Oracle Store reports an error at the isUpdatePK stack?
    • OPS & monitoring
      • What are the alert rules?
    • General O&M
      • Deploy InfluxDB for OMS
      • Increase the disk space of the OMS host
      • How do I modify the resource quotas of an OMS container?
      • How do I troubleshoot the OMS server down issue?
    • Data synchronization
      • FAQ about synchronization to a message queue
        • What are the strategies for ensuring the message order in incremental data synchronization to Kafka
    • Installation and deployment
      • How do I upgrade Store?
  • Release Note
    • V3.3
      • OMS V3.3.1
      • OMS V3.3.0
    • V4.2
      • OMS V4.2.0
      • OMS V4.2.1
      • OMS V4.2.2
    • V4.0
      • OMS V4.0.2
      • OMS V4.0.1
    • V3.2
      • OMS V3.2.1
      • OMS V3.2.2
    • V3.1
      • OMS V3.1.0
    • V3.4
      • OMS V3.4.0
    • V2.1
      • OMS V2.1.0
      • OMS V2.1.2
    • V4.1
      • OMS V4.1.0

Download PDF

OMS Documentation What is OMS? Terms OMS HA Overview Hierarchical functional system Basic components OMS Oracle full data migration design and impact Limitations Data migration process Data synchronization process Deployment types System and network requirements Memory and disk requirements Environment preparations Single-node deployment Deploy OMS on multiple nodes in a single region Deploy OMS on multiple nodes in multiple regions Integrate the OIDC protocol to OMS to implement SSO Scale out OMS Check the deployment Deploy a time-series database (Optional) Log on to the OMS console Overview Configure user information Change your logon password Log off Migrate data from an Oracle database to an Oracle tenant of OceanBase Database Migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database Migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database Migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database Overview Migrate data from an Oracle database to a MySQL tenant of OceanBase Database Active-active disaster recovery between OceanBase databases Migrate data from a TiDB database to a MySQL tenant of OceanBase Database Migrate data from a MySQL tenant of OceanBase Database to a MySQL database Migrate data within OceanBase Database Migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database Migrate data from an Oracle tenant of OceanBase Database to an Oracle database Migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database Migrate data from a MySQL database to a MySQL tenant of OceanBase Database Migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database Synchronize DDL operations from a MySQL tenant of OceanBase Database to a MySQL database Synchronize DDL operations from an Oracle tenant of OceanBase Database to an Oracle database Synchronize DDL operations from a DB2 LUW database to an Oracle tenant of OceanBase Database Synchronize DDL operations from an Oracle tenant of OceanBase Database to a DB2 LUW database Synchronize DDL operations from a DB2 LUW database to a MySQL tenant of OceanBase Database Synchronize DDL operations from a MySQL tenant of OceanBase Database to a DB2 LUW database DDL synchronization between MySQL tenants of OceanBase Database DDL synchronization between Oracle tenants of OceanBase Database Start and pause a data migration project Use tags to manage data migration projects Download and import settings of migration objects View and modify migration objects Rename a data migration project Release and delete a data migration project View details of a data migration project Perform batch operations on data migration projects Synchronize data from an IDB logical table to a physical table in a MySQL tenant of OceanBase Database Synchronize data from OceanBase Database to a RocketMQ instance Synchronize data from an ODP logical table to a DataHub instance Synchronize data from OceanBase Database to a DataHub instance Overview Synchronize data from OceanBase Database to a Kafka instance Synchronize data from an Oracle database to a DataHub instance Synchronize data from an IDB logical table to a DataHub instance Synchronize data from a MySQL database to a DataHub instance Synchronize data from an ODP logical table to a physical table in a MySQL tenant of OceanBase Database View details of a data synchronization project Download and import the settings of synchronization objects View and modify synchronization objects Release and delete a data synchronization project Start and pause a data synchronization project Perform batch operations on data synchronization projects Change the name of a data synchronization project Use tags to manage data synchronization projects Create a database user Enable binlogs for the MySQL database Minimum privileges required when an Oracle database serves as the source User privileges Create a RocketMQ data source Create an Oracle data source Create a DB2 LUW data source Create a TiDB data source Create a PostgreSQL data source Create a Kafka data source Create a DataHub data source Create a MySQL data source Copy a data source Delete a data source Edit a data source View data source information Go to the overview page O&M overview Update the quota View server logs View server information Overview Retry a task or subtask Skip a task or subtask
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogWhite PaperLive DemosTraining & CertificationTicket
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Migration Service
  3. V4.2.3
iconOceanBase Migration Service
V 4.2.3Enterprise Edition
Databases
  • OceanBase Database
  • OceanBase Cloud
  • OceanBase Tugraph
  • Interactive Tutorials
  • OceanBase Best Practices
Tools
  • OceanBase Cloud Platform
  • OceanBase Migration Service
  • OceanBase Developer Center
  • OceanBase Migration Assessment
  • OceanBase Admin Tool
  • OceanBase Loader and Dumper
  • OceanBase Deployer
  • Kubernetes operator for OceanBase
  • OceanBase Diagnostic Tool
  • OceanBase Binlog Service
Connectors and Middleware
  • OceanBase Database Proxy
  • Embedded SQL in C for OceanBase
  • OceanBase Call Interface
  • OceanBase Connector/C
  • OceanBase Connector/J
  • OceanBase Connector/ODBC
  • OceanBase Connector/NET
Enterprise Edition
  • V 4.3.2
  • V 4.3.1
  • V 4.3.0
  • V 4.2.5
  • V 4.2.4
  • V 4.2.3
  • V 4.0.2
  • V 3.4.0
Community Edition
  • V 4.2.13
  • V 4.2.12
  • V 4.2.11
  • V 4.2.10
  • V 4.2.9
  • V 4.2.8
  • V 4.2.7
  • V 4.2.6
  • V 4.2.5
  • V 4.2.4
  • V 4.2.3
  • V 4.2.1
  • V 4.2.0
  • V 4.0.0
  • V 3.3.1

Update the configurations of an Incr-Sync component

Last Updated:2026-04-14 07:36:27  Updated
Share
What is on this page
Limits
Scenarios
Procedure

folded

Share

OceanBase Migration Service (OMS) allows you to view and update the configurations of a specified Incr-Sync component. When you update the configurations, the current configurations of the Incr-Sync component are automatically displayed. You can view or modify the configurations of the Incr-Sync component.

Limits

  • OMS allows you to update the configurations of an Incr-Sync component in the Running, Stopped, or Abnormal state.

  • After you update the configurations of an Incr-Sync component, the system will restart the Incr-Sync component for the update to take effect. Proceed with caution.

    When a data migration or synchronization project fails, check the configurations of the project first, such as the basic information and user privileges of the source and destination databases.

Scenarios

You can update Incr-Sync configurations in the following scenarios:

  • A data migration or synchronization project fails due to incorrect configuration information.

  • A data migration or synchronization project needs to be optimized.

Procedure

  1. Log on to the OMS console.

  2. In the left-side navigation pane, choose OPS & Monitoring > Component.

  3. On the Component page, click the Incr-Sync tab.

  4. On the Incr-Sync page, you can search for an Incr-Sync component by component name, server IP address, or project name.

    You can filter Incr-Sync components by region and update the configurations of the Incr-Sync components in the target region.

  5. Click Update in the Actions column of the target Incr-Sync component.

  6. In the Update Configuration dialog box, add a parameter or update the configurations. For more information, see Component parameters.

    To add an Incr-Sync parameter, perform the following operations:

    1. In the Update Configurations dialog box, move the pointer over the blank area next to the condition, coordinator, sink, or source parameter and click the Add icon.

    2. Specify Key Name and click the check icon.

    3. In the Update Configurations dialog box, find the new key name. Its default value is NULL.

    4. Move the pointer over the new parameter and click the Edit icon that appears. Modify the parameter value and click the check icon.

    To update the configurations of an Incr-Sync component, perform the following operations:

    1. In the Update Configuration dialog box, move the pointer over the parameter to be modified and click the Edit icon that appears.

    2. Modify the value in the text box and then click the confirm icon.

      The green tick specifies to update the value and the red cross specifies to cancel the modification.

  7. In the Update Configurations dialog box, click OK.

Previous topic

Migrate an Incr-Sync component
Last

Next topic

Batch O&M
Next
What is on this page
Limits
Scenarios
Procedure