Before You Begin
(1) The version of the source self-built Oracle database is 10g, 11g, 12c, 18c, or 19c.
(2) ARCHIVELOG (archive mode) has been enabled on the source self-built Oracle database. A proper archive log retention period is set and the archive log can be accessed.
(3) Supplemental Logging, supplemental_log_data_pk, and supplemental_log_data_ui have been enabled on the source self-built Oracle database.
(4) The storage space of the target database must be greater than that used by the source database.
Limitations
Tables without primary keys only support full data migration, but not incremental data migration or auditing repair.
Oracle system libraries such as system and sys cannot be migrated.
Table structure, full data, and incremental data of the source database can be migrated.
If the source database has a null string of varchar2 type (Oracle will treat it as null) and the corresponding field on the target database has non-null constraints, the migration task will fail.
In a scenario where large text fields are updated separately, the task will fail.
Permission Requirements of Source Server
Migration Mode | Required Permissions |
Full | SELECT ANY TABLE, SELECT ANY DICTIONARY |
Incremental | SELECT ANY TABLE, SELECT ANY DICTIONARY, LOGMINING, FLASHBACK ANY TABLE, SELECT ANY TRANSACTION, EXECUTE_CATALOG_ROLE, EXECUTE ON DBMS_LOGMNR_D, EXECUTE ON DBMS_LOGMNR, EXECUTE ON DBMS_FLASHBACK, SELECT ON SYS.COL$, SELECT ON SYS.USER$, SELECT ON SYS.OBJ$ |
Auditing Repair | SELECT ANY TABLE, SELECT ANY DICTIONARY |
Configuration on Source Server
Data source type: Set this parameter to Oracle. Oracle databases within the specified version range can be migrated.
Server IP: Specifies the IP address of the source database to be migrated.
Port number: Specifies the port of the source database to be migrated.
User name: Specifies a user name used to connect to the source database to be migrated.
Password: Specifies the password of the user used to connect to the source database to be migrated.
Service name: Specifies the service name of the Oracle database.
CDB service name: Specifies the service name of the Oracle CDB. If the Oracle database is 12C or later versions, this field is required to obtain the desired database system information during migration.
Migration username: Specifies the actual Oracle schema to be migrated. It is usually the same as the username.