OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Migration Service

V4.2.5Enterprise Edition
  • OMS Documentation
  • OMS Introduction
    • What is OMS?
    • Terms
    • OMS HA
    • Principles of Store
    • Principles of Full-Import and Incr-Sync
    • Data verification principles
    • 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
    • Deploy OMS on a single node
    • Deploy OMS on multiple nodes in a single region
    • Deploy OMS on multiple nodes in multiple regions
    • Scale out
    • Check the deployment
    • Deploy a time-series database (Optional)
  • OMS console
    • Log in to the OMS console
    • Overview
    • User center
      • Configure user information
      • Change your login password
      • Log out
  • Data migration
    • Overview
    • Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database
    • Migrate data from a MySQL-compatible tenant of OceanBase Database to a MySQL database
    • Migrate data from an Oracle database to a MySQL-compatible tenant of OceanBase Database
    • Migrate data from an Oracle-compatible tenant of OceanBase Database to an Oracle database
    • Migrate data from an Oracle database to an Oracle-compatible tenant of OceanBase Database
    • Migrate data from a DB2 LUW database to an Oracle-compatible tenant of OceanBase Database
    • Migrate data from an Oracle-compatible tenant of OceanBase Database to a DB2 LUW database
    • Migrate data from a DB2 LUW database to a MySQL-compatible tenant of OceanBase Database
    • Migrate data from a MySQL-compatible tenant of OceanBase Database to a DB2 LUW database
    • Migrate data within OceanBase Database
    • Create an active-active disaster recovery task in OceanBase Database
    • Migrate data from a TiDB database to a MySQL-compatible tenant of OceanBase Database
    • Migrate data from a PostgreSQL database to a MySQL-compatible tenant of OceanBase Database
    • Migrate data from a PolarDB-X 1.0 database to a MySQL-compatible tenant of OceanBase Database
    • Migrate incremental data from an Oracle-compatible tenant of OceanBase Database to a MySQL database
    • Manage data migration tasks
      • View details of a data migration task
      • Rename a data migration task
      • View and modify migration objects
      • Use tags to Manage data migration tasks
      • Perform batch operations on data migration tasks
      • Download and import settings of migration objects
      • View and modify the parameter configurations of a data migration task
      • Start and pause a data migration task
      • End and delete a data migration task
    • Supported DDL operations and limits for synchronization
      • Synchronize DDL operations from a MySQL database to a MySQL-compatible tenant of OceanBase Database
        • Overview
        • 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-compatible 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-compatible tenant of OceanBase Database to a MySQL database
      • DDL operations for synchronizing data from an Oracle database to an Oracle-compatible tenant of OceanBase Database
        • Overview of DDL synchronization from Oracle to OceanBase Database Oracle compatible mode
        • 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 a partition
            • Drop subpartitions
            • Add partitions and subpartitions
            • Modify partitions
            • Truncate partitions
        • DROP TABLE
        • RENAME OBJECT
        • TRUNCATE TABLE
        • DROP INDEX
        • DDL incompatibilities between an Oracle database and an Oracle-compatible 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 the Oracle compatible mode of OceanBase Database to an Oracle database
      • Synchronize DDL operations from a DB2 LUW database to an Oracle-compatible tenant of OceanBase Database
      • Synchronize DDL operations from the Oracle compatible mode of OceanBase Database to a DB2 LUW database
      • Synchronize DDL operations from a DB2 LUW database to a MySQL-compatible tenant of OceanBase Database
      • Synchronize DDL operations from a MySQL-compatible tenant of OceanBase Database to a DB2 LUW database
      • DDL synchronization between MySQL-compatible tenants of OceanBase Database
      • DDL synchronization between Oracle-compatible tenants of OceanBase Database
  • Data synchronization
    • Overview
    • Synchronize data from OceanBase Database to a Kafka instance
    • Synchronize data from OceanBase Database to a RocketMQ instance
    • Synchronize data from OceanBase Database to a DataHub instance
    • Synchronize data from an ODP logical table to a physical table in a MySQL-compatible tenant of OceanBase Database
    • Synchronize data from an ODP logical table to a DataHub instance
    • Synchronize data from an IDB logical table to a MySQL-compatible tenant of OceanBase Database
    • 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 Oracle database to a DataHub instance
    • Manage data synchronization tasks
      • View details of a data synchronization task
      • Change the name of a data synchronization task
      • View and modify synchronization objects
      • Use tags to Manage data synchronization tasks
      • Perform batch operations on data synchronization tasks
      • Download and import the settings of synchronization objects
      • View and modify the parameter configurations of a data synchronization task
      • Start and pause a data synchronization task
      • End and delete a data synchronization task
  • Create and manage data sources
    • Create data sources
      • Create an OceanBase data source
        • Create a physical OceanBase data source
        • Create an ODP data source
        • Create an IDB data source
        • Create a public cloud OceanBase data source
        • Create a standalone OceanBase data source
      • Create a MySQL data source
      • Create an Oracle data source
      • Create a TiDB data source
      • Create a Kafka data source
      • Create a RocketMQ data source
      • Create a DataHub data source
      • Create a DB2 LUW data source
      • Create a PostgreSQL data source
      • Create a PolarDB-X 1.0 data source
    • Manage data sources
      • View data source information
      • Copy a data source
      • Edit a data source
      • Delete a data source
    • Create a database user
    • User privileges
    • Enable binlogs for the MySQL database
    • Minimum privileges required when an Oracle database serves as the source
  • OPS & Monitoring
    • O&M overview
    • Go to the overview page
    • Server
      • View server information
      • Update the quota
      • View server logs
    • Components
      • Store
        • Create a store
        • View details of a store
        • Update the configurations of a store
        • Start and pause a store
        • Delete a store
      • Incr-Sync
        • View details of an Incr-Sync component
        • Start and pause an Incr-Sync component
        • Migrate an Incr-Sync component
        • Update the configurations of an Incr-Sync component
        • Batch O&M
        • Delete an Incr-Sync component
      • Full-Import
        • View details of a Full-Import component
        • Pause a Full-Import component
        • Rerun and resume a Full-Import component
        • Update the configurations of a Full-Import component
        • Delete a Full-Import component
      • Full-Verification
        • View details of a Full-Verification component
        • Pause a Full-Verification component
        • Rerun and resume a Full-Verification component
        • Update the configurations of a Full-Verification component
        • Delete a Full-Verification component
    • O&M Task
      • View O&M tasks
      • Skip a task or subtask
      • Retry a task or subtask
    • Parameter Template
      • Overview
      • Task Template
        • Create a task template
        • View and edit task templates
        • Copy and export a task template
        • Delete a task template
      • Component Template
        • Create a component template
        • View and edit component templates
        • Copy and export a component template
        • Delete a component template
      • Component parameters
        • Store parameters
        • Incr-Sync parameters
        • Full-Import Parameters
        • Full-Verification parameters
        • CM parameters
        • Supervisor parameters
  • System management
    • Permission Management
      • Overview
      • Manage users
      • Manage departments
    • Alert center
      • View task alerts
      • View system alerts
      • Manage alert settings
    • Associate with OCP
    • System parameters
      • Modify system parameters
      • Modify HA configurations
      • oblogproxy parameters
    • Manage access keys
    • Operation audit
  • Troubleshooting Guide
    • Manage OMS services
    • OMS logs
    • Component O&M
      • O&M operations for the Supervisor component
      • CLI-based O&M for the Connector component
      • O&M operations for the Store component
    • Component tuning
      • Incr-Sync/Full-Import tuning
      • Oracle store tuning
    • Set throttling
    • Store performance diagnostics
  • Reference Guide
    • Features
      • Configure DDL/DML synchronization
      • Supported DDL operations for synchronization
      • Rename a migration or synchronization object
      • Use SQL conditions to filter data
      • Set an incremental synchronization timestamp
      • Configure matching rules
      • Wildcard patterns supported for matching rules
      • Hidden column mechanisms
      • Instructions on schema migration
      • Create and update a heartbeat table
      • Change the topic
      • Column filtering
      • Data formats
    • API Reference
      • Overview
      • CreateProject
      • StartProject
      • StopProject
      • ResumeProject
      • ReleaseProject
      • DeleteProject
      • ListProjects
      • DescribeProject
      • DescribeProjectSteps
      • DescribeProjectStepMetric
      • DescribeProjectProgress
      • DescribeProjectComponents
      • ListProjectFullVerifyResult
      • StartProjectsByLabel
      • StopProjectsByLabel
      • CreateMysqlDataSource
      • CreateOceanBaseDataSource
      • CreateOceanBaseODPDataSource
      • CreatePolarDBDataSource
      • ListDataSource
      • CreateLabel
      • ListAllLabels
      • DeleteDataSource
      • CreateProjectModifyRecords
      • ListProjectModifyRecords
      • StopProjectModifyRecords
      • RetryProjectModifyRecords
      • CancelProjectModifyRecord
      • SubmitPreCheck
      • GetPreCheckResult
      • UpdateProjectConfig
    • Alert Reference
      • oms_host_down
      • oms_host_down_migrate_resource
      • oms_host_threshold
      • oms_migration_failed
      • oms_migration_delay
      • oms_sync_failed
      • oms_sync_status_inconsistent
      • oms_sync_delay
    • SSO
      • Integrate the OIDC protocol to OMS to implement SSO
      • Integrate the SAML 2.0 protocol to OMS to implement SSO
    • OMS error codes
    • SQL statements for querying database objects
    • Create a trigger
    • Change the log level for a PostgreSQL instance
    • Online DDL tools
    • Supplemental logging in Oracle Database
  • Upgrade Guide
    • Overview
    • Upgrade OMS in single-node deployment mode
    • Upgrade OMS in multi-node deployment mode
    • FAQ
  • FAQ
    • General O&M
      • How do I modify the resource quotas of an OMS container?
      • How do I troubleshoot the OMS server down issue?
      • Deploy InfluxDB for OMS
      • Increase the disk space of the OMS host
    • Task diagnostics
      • How do I troubleshoot common problems with Oracle Store?
      • How do I perform performance tuning for Oracle Store?
      • What do I do when Oracle Store reports an error at the isUpdatePK stack?
      • 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 use LogMiner to pull data from an Oracle database?
    • OPS & monitoring
      • What are the alert rules?
    • Data synchronization
      • FAQ about synchronization to a message queue
        • What are the strategies for ensuring the message order in incremental data synchronization to Kafka
    • Data migration
      • User privileges
        • What privileges do I need to grant to a user during data migration to or from an Oracle database?
      • Full migration
        • How do I query the ID of a checker?
        • How do I query log files of the Checker component of OMS?
        • How do I query the verification result files of the Checker component of OMS?
        • What do I do if the destination table does not exist?
        • What can I do when the full migration failed due to LOB fields?
        • What do I do if garbled characters cannot be written into OceanBase Database V3.1.2?
      • Incremental synchronization
        • How do I skip DDL statements?
        • 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?
    • Installation and deployment
      • How do I upgrade Store?
  • Release Note
    • V4.2
      • OMS V4.2.5
      • OMS V4.2.4
      • OMS V4.2.3
      • OMS V4.2.2
      • OMS V4.2.1
      • OMS V4.2.0
    • V4.1
      • OMS V4.1.0
    • V4.0
      • OMS V4.0.2
      • OMS V4.0.1
    • V3.4
      • OMS V3.4.0
    • V3.3
      • OMS V3.3.1
      • OMS V3.3.0
    • V3.2
      • OMS V3.2.2
      • OMS V3.2.1
    • V3.1
      • OMS V3.1.0
    • V2.1
      • OMS V2.1.2
      • OMS V2.1.0

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Migration Service
  3. V4.2.5

OMS V4.2.5

Last Updated:2026-09-04 08:13:48

Version information
New features
SSO by using SAML 2.0
Support for standalone OceanBase Database
Upgraded deployment mode
Stability enhancements
Security enhancements
Ease-of-use improvements
Feature matrix
Data migration
Data synchronization
Supported database versions

Version information

  • Version: V4.2.5

  • Previous version: V4.2.4 BP1

  • Release date: March 24, 2025

  • Upgrade path:

    • OceanBase Migration Service (OMS) of a version earlier than V3.2.1 must be first upgraded to V3.2.1.

    • OMS V3.2.1 and later can be directly upgraded to V4.2.5.

      Note

      Due to underlying component integration, DataHub tasks cannot be displayed after OMS is upgraded from V3.2.1 to a later version. If you want to upgrade OMS from V3.2.1 to a later version with a DataHub task involved, contact OMS Technical Support.

New features

SSO by using SAML 2.0

Security Assertion Markup Language (SAML) 2.0 is a standard development protocol based on XML. It is widely applied for single sign-on (SSO) in federated identity authentication scenarios. By adapting to the SAML 2.0 protocol, OMS V4.2.5 supports automatic login to multiple application systems after you connect to a unified SSO platform through simple configuration. This reduces the account management costs.

Support for standalone OceanBase Database

OMS of earlier versions does not support standalone OceanBase Database. OMS V4.2.5 supports standalone OceanBase data sources. OMS directly connects to the OBServer node and starts OceanBase Change Data Capture (CDC) by using the RootServer list to implement schema migration, full migration, and incremental synchronization.

Upgraded deployment mode

In OMS of earlier versions, the management image and component image are packaged as a whole for deployment. In other words, the management image and component image are deployed on the same node. In this deployment mode, the migration tasks will be restarted upon each upgrade or configuration change, compromising the real-time performance of business. OMS V4.2.5 allows you to deploy and upgrade the management image and component image separately. You can flexibly customize an upgrade strategy as needed to ensure business stability.

Stability enhancements

  • The logic for stopping the Store component is optimized. Specifically, the main process is also ended when the Store component is stopped. This way, after you configure parameters, the parameter settings take effect upon a component restart.

  • The logic for integrating CDC versions is optimized. This avoids an excessively large installation package caused if too many CDC versions are integrated.

  • An alert message will be sent after a component is abnormal and the high availability (HA) module is triggered. You can promptly intervene to avoid unexpected production faults.

  • OMS V4.2.5 allows you to deploy cluster manager (CM) databases in multiple regions. Requests in different regions are routed to the nearby CM database. This avoids the issue of high latency resulted from cross-region access when a single CM database is deployed and shared.

Security enhancements

  • OMS V4.2.5 supports key rotation. This feature can significantly reduce risks of password cracking.

Ease-of-use improvements

  • The DB2 Store component can pull and parse the log file that is named connector.log and stored in the connector/ directory. You can view the logs on the GUI to facilitate troubleshooting.

  • The password strategies of OMS are aligned with those of OceanBase Cloud Platform (OCP) and OceanBase Developer Center (ODC) to ensure consistency across products in the ecosystem.

Feature matrix

Note

The OB_MySQL and OB_Oracle data sources in the following tables can be physical data sources and public cloud data sources.

Data migration

Data source
Schema migration
Full migration
Incremental DML
Incremental DDL
Full verification
Reverse increment
Table without a primary key
MySQL -> OB_MySQL Supported Supported Supported Supported Supported Supported Supported
Oracle-> OB_MySQL Supported Supported Supported Not supported Supported Supported Supported
TiDB -> OB_MySQL Supported Supported Supported Not supported Supported Supported Not supported
PostgreSQL -> OB_MySQL Supported Supported Supported Not supported Supported Supported Not supported
PolarDB-X -> OB_MySQL Not supported Supported Supported Not supported Supported Not supported Not supported
Oracle -> OB_Oracle Supported Supported Supported Supported Supported Supported Supported
DB2 LUW -> OB_Oracle Supported Supported Supported Supported Supported Supported Not supported
OB_Oracle -> OB_Oracle Supported Supported Supported Supported Supported Supported Supported
OB_MySQL -> OB_MySQL Supported Supported Supported Supported Supported Supported Supported (not supported in active-active disaster recovery scenarios)
OB_Oracle -> Oracle Supported Supported Supported Supported Supported Supported Supported
OB_Oracle -> MySQL Not supported Not supported Supported Not supported Not supported Not supported Not supported
OB_MySQL -> MySQL Supported Supported Supported Supported Supported Supported Not supported
OB_Oracle -> DB2 LUW Supported Supported Supported Supported Supported Supported Not supported
DB2 LUW -> OB_MySQL Supported Supported Supported Supported Supported Supported Not supported
OB_MySQL -> DB2 LUW Supported Supported Supported Supported Supported Supported Not supported

Data synchronization

Data source
Schema synchronization
Full synchronization
Incremental DML
Incremental DDL
Table without a primary key
OB_MySQL -> Kafka Supported Supported Supported Supported Not supported
OB_MySQL -> RocketMQ N/A Supported Supported Not supported Not supported
OB_MySQL -> DataHub (Tuple) Supported Supported Supported Not supported Not supported
OB_MySQL -> DataHub (Blob) Supported Supported Supported Supported Not supported
OB_Oracle -> Kafka Supported Supported Supported Supported Not supported
OB_Oracle-> RocketMQ N/A Supported Supported Not supported Not supported
OB_Oracle -> DataHub (Tuple) Supported Supported Supported Not supported Not supported
OB_Oracle -> DataHub (Blob) Supported Supported Supported Supported Not supported
Oracle -> DataHub (Blob) Supported Not supported Supported Not supported Not supported
Oracle -> DataHub (Tuple) Supported Not supported Supported Not supported Not supported
MySQL -> DataHub (Tuple) Supported Not supported Supported Not supported Not supported
MySQL -> DataHub (Blob) Supported Not supported Supported Not supported Not supported
ODP -> DataHub (Tuple) Supported Supported Supported Not supported Not supported
ODP -> DataHub (Blob) Supported Supported Supported Supported Not supported
IDB -> DataHub (Tuple) Supported Supported Supported Not supported Not supported
IDB -> DataHub (Blob) Supported Supported Supported Supported Not supported
ODP -> OB_MySQL N/A Supported Supported Supported Not supported
IDB -> OB_MySQL N/A Supported Supported Supported Not supported

Supported database versions

OceanBase Database versions that support data migration and data synchronization are described as follows:

  • OMS V4.2.5 can pull full and incremental data from and write data to OceanBase Database of a version earlier than V4.x.

  • OMS V4.2.5 can pull full data from and write data to OceanBase Database V4.x.

  • Only the following OceanBase Database versions support incremental synchronization by OMS V4.2.5. For other versions, you must perform a hot update of the Store component.

    • V4.1.x

    • V4.2.1.10, V4.2.2.1, V4.2.3.0, V4.2.4.0, V4.2.5.2, V4.3.0.1, V4.3.1.0, V4.3.2.1, V4.3.3.1, V4.3.4.1, and V4.3.5.0 (and earlier)

The following table lists the versions of other databases and OCP that support data migration and data synchronization.

Transmission feature
Version of other databases
OCP version
Data migration
  • MySQL: 5.5, 5.6, 5.7, and 8.0
  • MariaDB: 10.2 and 10.6.x
  • DB2 LUW: 9.7, 10.1, 10.5, 11.1, and 11.5
  • Oracle: 10g, 11g, 12c, 18c, and 19c (CDBs and PDBs supported in 12c and later)
  • PostgreSQL: 10.x, 11.x, 12.x, and 13.x
  • TiDB: 4.x, 5.4, 6.x, and 7.x
  • V2.x: V2.3.9, V2.4.5, and V2.5.0
  • V3.x
  • V4.x
Data synchronization
  • Kafka: 0.9, 1.0, 2.x, and 3.x
  • RocketMQ: 4.x and 5.x
  • MySQL: 5.5, 5.6, 5.7, and 8.0
  • Oracle: 10g, 11g, 12c, 18c, and 19c (CDBs and PDBs supported in 12c and later)
  • DataHub: N/A
  • V2.x: V2.3.9, V2.4.5, and V2.5.0
  • V3.x
  • V4.x

Previous topic

How do I upgrade Store?
Last

Next topic

OMS V4.2.4
Next
on this page
Version information
New features
SSO by using SAML 2.0
Support for standalone OceanBase Database
Upgraded deployment mode
Stability enhancements
Security enhancements
Ease-of-use improvements
Feature matrix
Data migration
Data synchronization
Supported database versions