原作者：李宏达
一、准备环境
1. 源库创建（Oracle）
- 创建Oracle 11.2.0.4
docker pull registry.cn-hangzhou.aliyuncs.com/lhrbest/oracle_11g_ee_lhr_11.2.0.4:1.0
docker run -itd --name oracle -h oracle --privileged=true -p 1521:1521 -p 222:22 -p 1158:1158 lhrbest/oracle_11g_ee_lhr_11.2.0.4:1.0 init
MTK程序迁移Oracle需要安装Oracle客户端
- 安装Oracle客户端
wget https://download.oracle.com/otn_software/linux/instantclient/211000/oracle-instantclient-basic-21.1.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/211000/oracle-instantclient-sqlplus-21.1.0.0.0-1.x86_64.rpm
rpm -ivh oracle-instantclient-basic-21.1.0.0.0-1.x86_64.rpm oracle-instantclient-sqlplus-21.1.0.0.0-1.x86_64.rpm
export LD_LIBRARY_PATH=/usr/lib/oracle/21/client64/lib
2. 目标库创建（MogDB）
- 参考MogDB/openGauss 手动部署(非OM工具)单机，主备，主备级联架构
二、迁移
1. 上传程序，编写配置文件
迁移为Oracle下的scott用户
- 编写配置文件
[root@mogdb-kernel-0005 mtk]# cat mtk_config.json
{
"source": {
"type": "oracle",
"connect": {
"version": "",
"host": "172.16.0.176",
"user": "system",
"port": 1521,
"password": "system",
"dbName": "LHR11G",
"dsn": ""
},
"parameter": {
"debugTest": false
}
},
"target": {
"type": "openGauss",
"connect": {
"version": "",
"host": "172.16.0.106",
"user": "mogdb",
"port": 26000,
"password": "Enmo@123",
"dbName": "mtk",
"dsn": ""
},
"parameter": {
"dropExistingObject": true,
"truncTable": true,
"ignoreTableDDLCompErr": true,
"parallelInsert": 1
}
},
"limit": {
"parallel": 2
},
"object": {
"schemas": [
"SCOTT"
]
},
"dataOnly": false ,
"schemaOnly": false,
"reportFile": "./report_Oracle2OpenGauss_all.html"
}
2 迁移
- 执行迁移命令
[root@mogdb-kernel-0005 mtk]# ./mtk -c mtk_config.json --reportFile mtk_report.html --logfile mtk_report.log --debug
'''''
-----------------------
ObjectName Type Summary
-----------------------
+--------------+---------------------+---------------------+------------+--------+-------------+------------+
| Type | StartTime | EndTime | Time | Status | Success Num | Failed Num |
+--------------+---------------------+---------------------+------------+--------+-------------+------------+
| Schema | 2021-06-15 12:00:46 | 2021-06-15 12:00:46 | 18 ms | finish | 1 | 0 |
| ObjectType | 2021-06-15 12:00:46 | 2021-06-15 12:00:47 | 450 ms | finish | 0 | 0 |
| Domain | 2021-06-15 12:00:47 | 2021-06-15 12:00:47 | 0 ms | finish | 0 | 0 |
| CustomType | 2021-06-15 12:00:47 | 2021-06-15 12:00:47 | 0 ms | finish | 0 | 0 |
| Sequence | 2021-06-15 12:00:47 | 2021-06-15 12:00:47 | 5 ms | finish | 0 | 0 |
| Queue | 2021-06-15 12:00:47 | 2021-06-15 12:00:47 | 0 ms | finish | 0 | 0 |
| Table | 2021-06-15 12:00:47 | 2021-06-15 12:00:47 | 335 ms | finish | 4 | 0 |
| TableDDLCom | 2021-06-15 12:00:47 | 2021-06-15 12:00:47 | 0 ms | finish | 0 | 0 |
| TableData | 2021-06-15 12:00:47 | 2021-06-15 12:00:49 | 2 s 45 ms | finish | 4 | 0 |
| Constraint | 2021-06-15 12:00:49 | 2021-06-15 12:00:49 | 445 ms | finish | 3 | 0 |
| Index | 2021-06-15 12:00:49 | 2021-06-15 12:00:51 | 1 s 894 ms | finish | 0 | 0 |
| Trigger | 2021-06-15 12:00:51 | 2021-06-15 12:00:51 | 0 ms | finish | 0 | 0 |
| View | 2021-06-15 12:00:51 | 2021-06-15 12:00:51 | 86 ms | finish | 0 | 0 |
| TableDataCom | 2021-06-15 12:00:51 | 2021-06-15 12:00:52 | 39 ms | finish | 4 | 0 |
+--------------+---------------------+---------------------+------------+--------+-------------+------------+
------------------
Table Data Summary
------------------
+----------------+----------------+---------------------+---------------------+-----------+---------+-------------+-------------+-------------+------+
| SrcName | TgtName | StartTime | EndTime | Time | Status | Select Rows | Insert Rows | Ignore Rows | Size |
+----------------+----------------+---------------------+---------------------+-----------+---------+-------------+-------------+-------------+------+
| SCOTT.EMP | SCOTT.EMP | 2021-06-15 12:00:47 | 2021-06-15 12:00:48 | 1 s 18 ms | succeed | 14 | 14 | 0 | 773 |
| SCOTT.SALGRADE | SCOTT.SALGRADE | 2021-06-15 12:00:47 | 2021-06-15 12:00:48 | 1 s 29 ms | succeed | 5 | 5 | 0 | 44 |
| SCOTT.DEPT | SCOTT.DEPT | 2021-06-15 12:00:48 | 2021-06-15 12:00:49 | 1 s 17 ms | succeed | 4 | 4 | 0 | 68 |
| SCOTT.BONUS | SCOTT.BONUS | 2021-06-15 12:00:48 | 2021-06-15 12:00:49 | 1 s 16 ms | succeed | 0 | 0 | 0 | 0 |
+----------------+----------------+---------------------+---------------------+-----------+---------+-------------+-------------+-------------+------+
-----------------------------
Table Data Comparison Summary
-----------------------------
+----------------+----------------+---------------------+-------+---------+------------+------------+-------+
| SrcName | TgtName | StartTime | Time | Status | SourceRows | TargetRows | Error |
+----------------+----------------+---------------------+-------+---------+------------+------------+-------+
| SCOTT.EMP | SCOTT.EMP | 2021-06-15 12:00:51 | 1 ms | succeed | 14 | 14 | |
| SCOTT.SALGRADE | SCOTT.SALGRADE | 2021-06-15 12:00:51 | 39 ms | succeed | 5 | 5 | |
| SCOTT.DEPT | SCOTT.DEPT | 2021-06-15 12:00:51 | 1 ms | succeed | 4 | 4 | |
| SCOTT.BONUS | SCOTT.BONUS | 2021-06-15 12:00:51 | 1 ms | succeed | 0 | 0 | |
+----------------+----------------+---------------------+-------+---------+------------+------------+-------+
- 日志截图
- 主界面
- 对象
- 表数据
- 主界面
