使用 MTK 迁移 Oracle 11g 数据库 至 MogDB 3.0 运维指南
一、环境概述
本次是进行Oracle到MogDB测试迁移，具体生产迁移，还需考虑更多步骤细节，请查看MogDB官方文档。
本次迁移，选择采用MTK工具进行迁移，MTK版本 v2.7.2。
MogDB迁移配置文件mtk.json里配置的源端Oracle用户必须能访问
DBA_*/ALL_*视图和查询迁移表权限，该用户必须拥有以下权限。
connect
select any dictionary
select any table
select_catalog_role
MTK 从 2.3.0 以后访问
DBA_*视图,不在查询ALL_*视图.
二、目标端配置
MogDB目标端，为防止目标端迁移时产生大量归档日志，迁移前建议关闭目标端数据库归档。
– 可通过如下方式查询MogDB是否开启归档
[omm@opensource-db ~]$ cat /db/mogdb/data/postgresql.conf |grep archive_mode#archive_mode = off # allows archiving to be done或者[omm@opensource-db ~]$ gsql -d postgres -p 26000 -rgsql ((MogDB 3.0.3 build 23ba838d) compiled at 2022-10-22 09:50:41 commit 0 last mr )Non-SSL connection (SSL connection is recommended when requiring high-security)Type "help" for help.MogDB=# show archive_mode;archive_mode--------------off(1 row)-- 若archive_mode=on 表示开启了数据库归档
2.1 安装Oracle客户端
-- 本次选择使用rpm包来安装Oracle客户端-- 目标端下载如下四个 oracle-client rpm包[root@opensource-db soft]# ls -lrt oracle-instantclient11.2-*.rpm-rw-r--r-- 1 omm omm 828333 Dec 2 14:31 oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm-rw-r--r-- 1 omm omm 59865008 Dec 2 14:36 oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm-rw-r--r-- 1 omm omm 610222 Dec 2 14:37 oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm-rw-r--r-- 1 root root 1564169 Dec 2 17:39 oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm-- root 用户安装rpm包[root@opensource-db soft]# rpm -ivh oracle*.rpm-- rpm 包 安装目录在 /usr/lib/oracle 目录下-- 配置环境变量-- omm 用户[omm@opensource-db ~]$ cat /home/omm/.bash_profile<<EOFexport LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:/db/mogdb/app/libexport TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/adminEOFsource /home/omm/.bash_profile-- 此时执行sqlplus会报错[omm@opensource-db ~]$ sqlplus-bash: sqlplus: command not found# 问题原因，因为安装sqlplus客户端后，会链接生成/bin/sqlplus64[omm@opensource-db ~]$ sqlplus64SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 2 14:51:34 2022Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter user-name:[omm@opensource-db ~]$ which sqlplus64/bin/sqlplus64[omm@opensource-db ~]$ ls -lrt /bin/sqlplus64lrwxrwxrwx 1 root root 41 Dec 2 14:40 /bin/sqlplus64 -> /usr/lib/oracle/11.2/client64/bin/sqlplus-- 解决办法，使用root用户执行如下操作[root@opensource-db ~]# ln -s /usr/lib/oracle/11.2/client64/bin/sqlplus /bin/sqlplus[root@opensource-db ~]# su - ommLast login: Fri Dec 2 14:50:48 CST 2022 on pts/2[omm@opensource-db ~]$ sqlplusSQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 2 14:52:50 2022Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter user-name:-- 此时可通过sqlplus使用tnsnames.ora字符串连接远程源端Oracle数据库。-- 关于linux安装客户端并配置tnsnames.ora信息可参照我墨天轮文章 https:///572611[Linux 服务器安装Oracle instance client 客户端 rpm 包并远程连接数据库故障与解决办法【亲测有效】]
2.2 下载解压MTK
-- 本次选择使用MTK最新版本2.7.2,选择[]$ wget https://cdn-mogdb.enmotech.com/mtk/v2.7.2/mtk_2.7.2_linux_amd64.tar.gz--2022-12-02 13:29:19-- https://cdn-mogdb.enmotech.com/mtk/v2.7.2/mtk_2.7.2_linux_amd64.tar.gzResolving cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)... 122.193.130.103Connecting to cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)|122.193.130.103|:443... connected.HTTP request sent, awaiting response... 200 OKLength: 16425899 (16M) [regular file]Saving to: ‘mtk_2.7.2_linux_amd64.tar.gz’100%[=====================================================================================================================================================================================================================================>] 16,425,899 58.1MB/s in 0.3s2022-12-02 13:29:20 (58.1 MB/s) - ‘mtk_2.7.2_linux_amd64.tar.gz’ saved [16425899/16425899][]$ lltotal 16044-rw------- 1 omm omm 16425899 Nov 29 13:19 mtk_2.7.2_linux_amd64.tar.gz[]$ tar -zxvf mtk_2.7.2_linux_amd64.tar.gzmtk_2.7.2_linux_amd64/CHANGELOG.mdmtk_2.7.2_linux_amd64/README.mdmtk_2.7.2_linux_amd64/example/db22mogdb.jsonmtk_2.7.2_linux_amd64/example/db22mogdb.yamlmtk_2.7.2_linux_amd64/example/db22mysql.jsonmtk_2.7.2_linux_amd64/example/db22mysql.yamlmtk_2.7.2_linux_amd64/example/informix2mogdb.jsonmtk_2.7.2_linux_amd64/example/informix2mogdb.yamlmtk_2.7.2_linux_amd64/example/mysql2mogdb.jsonmtk_2.7.2_linux_amd64/example/mysql2mogdb.yamlmtk_2.7.2_linux_amd64/example/oracle2mogdb.jsonmtk_2.7.2_linux_amd64/example/oracle2mogdb.yamlmtk_2.7.2_linux_amd64/example/pg2mogdb.jsonmtk_2.7.2_linux_amd64/example/pg2mogdb.yamlmtk_2.7.2_linux_amd64/example/sqlserver2mogdb.jsonmtk_2.7.2_linux_amd64/example/sqlserver2mogdb.yamlmtk_2.7.2_linux_amd64/mtk[]$ cd mtk_2.7.2_linux_amd64-- 填写邮箱申请license[]$ ./mtk license genLicense File Not Found (default license.json)The License code is invalid, start applying? Email: xxxx@xxxx.com -- 填写邮箱信息>> please enter a valid email addressError: the email is invalidUsage:mtk license gen [flags]Flags:-e, --email string Specify the user email-s, --server string Specify the license server.-h, --help help for genGlobal Flags:--batchSize int Specify the batch size to be used for bulk/copy insert.Valid values are 1-50000, default batch size is 1000for MySQL,Oracle,openGauss,PostgreSQL.--bufferSize int Specify the Buffer size in MB, to be used inserting or querying.Valid value is from 1 to 1024, default Buffer size is 8 MBfor postgres,openGauss,mysql.--caseSensitive int Object case parameters in SQL statements.1 - lower case2 - upper case3 - Keep it the same as the source database.--channelCacheNum int Specify channelCacheNum.Valid values are 1-50000, default batch size is 10000-c, --config string Set mtk config file. Support json,yaml. [env MTK_CONFIG] (default "mtk.json")--cpBufferSize int Specify the Copy Buffer size in MB, to be used in the Copy Command.Valid value is from 1 to 1024, default Copy Buffer Size is 8 MBfor PostgreSQL,openGauss.-d, --debug Set the debug mode.Not necessary for the normal usage. [env MTK_DEBUG]--disableCollStatistics disable Collect table statistics.--disableFKCons Disable table foreign key sync--disableIgnoreCase Disable ignoring case queries--disableSelectPart Disable the select by partition--disableTableDataComp disable table select count compare.--enableSyncCompTabPro Enable Synchronize table compressed properties--fetchSize int Specify fetch size in terms of number of rows should be fetched in result set at a time.Valid values are 1-50000, default fetch size is 1000for Oracle. (default 1000)--file export to file--fileType string Indicates the type of a file when data is to be exported to a file.support csv,sql--noTerminalReport The terminal does not print an overview of the migration report-p, --parallel int Specify the parallelism.the degree of parallelism is now only useful when migrating table data and parallelism when creating an index. (default 1)--path string Indicates the directory of a file to which data is to be exported.Default value is config.target.parameter.path. If not configured, the system default value ./dataCommand Value > Config Value > MTK Default Value--preRun preRun check.-r, --reportFile string Set mtk report file or dir. If it is a file, use the file directory.Default value is ./reportreport directory format [./report/reportYYYYMMDDHHMISS] ./report/report20210101121314--schemas string the Migrate schema,Separated by commas.(schema1,schema2,db1)--seqLastNumAddNum int The last value of the sequence is increased--tableSkip stringArray Define table split. Can be specified multiple times.format schema.tableName--tableSkip MTK.TABLE01--tableSkip MTK.TABLE02--tableSplit stringArray Define table split. Can be specified multiple times.format schema.tableName:where:where:where--tableSplit 'MTK.TABLE01: "ID">100 AND ID<=200: ID>200 AND ID<=300:ID>300'--tableSplit "MTK.TABLE02: \"ID\">100 AND ID<=200: ID>200 AND ID<=300:ID>300 AND COL1='1'"--tables string the Migrate tables,Separated by commas.(tab1,schema1.tab1)
2.3 MTK应用license
-- 根据邮箱里收到的license文件上传到MogDB数据库服务器MTK安装目录下，应用license[omm@opensource-db mtk_2.7.2_linux_amd64]$ lltotal 46480-rw------- 1 omm omm 60343 Nov 29 12:56 CHANGELOG.mddrwx------ 2 omm omm 4096 Dec 2 13:29 example-rw-r--r-- 1 omm omm 3304 Dec 2 13:51 license.json-rwx------ 1 omm omm 47517936 Nov 29 12:54 mtk-rw------- 1 omm omm 2052 Nov 28 11:00 README.md[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk license genUsing license file: /home/omm/mtk_2.7.2_linux_amd64/license.jsonName : xxxx@xxxx.comExpiry: 2023-01-01 13:48:45.572292597 +0800 CSTVersion: 2.7.2The License code is valid, no need to apply-- 查看MTK版本信息[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk -vUsing license file: /home/omm/mtk_2.7.2_linux_amd64/license.jsonName : xxxx@xxx.comExpiry: 2023-01-01 13:48:45.572292597 +0800 CSTVersion: 2.7.2MMMMMMMM MMMMMMMMTTTTTTTTTTTTTTTTTTTTTTTKKKKKKKKK KKKKKKKM:::::::M M:::::::MT:::::::::::::::::::::TK:::::::K K:::::KM::::::::M M::::::::MT:::::::::::::::::::::TK:::::::K K:::::KM:::::::::M M:::::::::MT:::::TT:::::::TT:::::TK:::::::K K::::::KM::::::::::M M::::::::::MTTTTTT T:::::T TTTTTTKK::::::K K:::::KKKM:::::::::::M M:::::::::::M T:::::T K:::::K K:::::KM:::::::M::::M M::::M:::::::M T:::::T K::::::K:::::KM::::::M M::::M M::::M M::::::M T:::::T K:::::::::::KM::::::M M::::M::::M M::::::M T:::::T K:::::::::::KM::::::M M:::::::M M::::::M T:::::T K::::::K:::::KM::::::M M:::::M M::::::M T:::::T K:::::K K:::::KM::::::M MMMMM M::::::M T:::::T KK::::::K K:::::KKKM::::::M M::::::M TT:::::::TT K:::::::K K::::::KM::::::M M::::::M T:::::::::T K:::::::K K:::::KM::::::M M::::::M T:::::::::T K:::::::K K:::::KMMMMMMMM MMMMMMMM TTTTTTTTTTT KKKKKKKKK KKKKKKKRelease version: v2.7.2Git Commit hash: 2f0398f2Git Commit Date: 2022-11-29T04:54:39ZGit Tag : v2.7.2Build timestamp: 20221129045645======================================================-- 查看MTK版本时可能遇到的问题及解决办法[omm@opensource-db mtk_2.7.2_linux_amd64]$ cd mtk_2.7.2_linux_amd64[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk -version./mtk: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by ./mtk)解决办法：链接：https://blog.csdn.net/l714417743/article/details/110208415wget http://ftp.gnu.org/gnu/glibc/glibc-2.17.tar.gztar -xvf glibc-2.17.tar.gzcd glibc-2.17mkdir build; cd build../configure --prefix=/usr --disable-profile --enable-add-ons --with-headers=/usr/include --with-binutils=/usr/binmake -j 8make install[omm@opensource-db mtk_2.7.2_linux_amd64]# ldd --versionldd (GNU libc) 2.17Copyright (C) 2012 Free Software Foundation, Inc.This is free software; see the source for copying conditions. There is NOwarranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.Written by Roland McGrath and Ulrich Drepper.[root@local-2f-abiz-dev-test-db ~]# strings /lib64/libc.so.6 |grep GLIBC_GLIBC_2.2.5GLIBC_2.2.6GLIBC_2.3GLIBC_2.3.2GLIBC_2.3.3GLIBC_2.3.4GLIBC_2.4GLIBC_2.5GLIBC_2.6GLIBC_2.7GLIBC_2.8GLIBC_2.9GLIBC_2.10GLIBC_2.11GLIBC_2.12GLIBC_2.13GLIBC_2.14GLIBC_2.15GLIBC_2.16GLIBC_2.17GLIBC_PRIVATE
2.4 目标端创建数据库及用户
[omm@opensource-db ~]$ gsql -d postgres -p 26000 -rgsql ((MogDB 3.0.3 build 23ba838d) compiled at 2022-10-22 09:50:41 commit 0 last mr )Non-SSL connection (SSL connection is recommended when requiring high-security)Type "help" for help.-- 创建数据库表空间MogDB=# CREATE TABLESPACE tbs_xxxx location '/db/mogdb/tablespace/tbs_xxxx';CREATE TABLESPACE-- 本次选择为数据库指定默认表空间MogDB=# create database dbxxxx WITH TABLESPACE = tbs_xxxx;CREATE DATABASEMogDB=# create user moguser with password "mogdb_123";NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.CREATE ROLEMogDB=# GRANT CREATE ON TABLESPACE tbs_xxxx TO moguser;GRANTMogDB=# grant all on schema public to moguser;GRANTMogDB=# alter user moguser sysadmin;ALTER ROLEMogDB=# grant create on database dbxxxx to moguser;GRANT
2.5 初始化项目
[omm@opensource-db ~]$ cd /home/omm/mtk_2.7.2_linux_amd64[omm@opensource-db ~]$ ./mtk init-project -s oracle -t mogdb -n ora2mg[omm@opensource-db mtk_2.7.2_linux_amd64]$ tree -f ora2mg/ora2mg├── ora2mg/config│ └── ora2mg/config/mtk.json├── ora2mg/data├── ora2mg/report└── ora2mg/schema4 directories, 1 file
2.6 编辑并检查配置文件
2.6.1 编辑配置文件
[omm@opensource-db mtk_2.7.2_linux_amd64]$ vim ora2mg/config/mtk.json-- 编辑后的文件如下{"source": {"type": "oracle","connect": {"version": "","host": "xxx.xxx.xxx.xxx","user": "system","port": 1521,"password": "oracle","dbName": "dbxxxx","dsn": "","charset": "ZHS16GBK","clientCharset": ""},"parameter": {"charAppendEmptyString": false}},"target": {"type": "mogdb","connect": {"version": "3.0.3","host": "192.168.73.21","user": "moguser","port": 26000,"password": "mogdb_123","dbName": "db_xxx","dsn": "","charset": "UTF8","datCompatibility": "A","clientCharset": ""},"parameter": {"parallelInsert": 1,"dropSchema": false,"dropExistingObject": false,"truncTable": false,"colKeyWords": {"STREAM": 1,"TID": 1},"objKeyWords": {"STREAM": 1,"TID": 1},"caseSensitive": 0,"quoteMark": false,"path": "ora2mogdb/data","schemaPath": "ora2mogdb/schema","dataPath": "ora2mogdb/data","errDataPath": "","fileType": "csv","fileSize": "10240MiB","csvHeader": false,"csvNullValue": "","csvFieldDelimiter": ",","csvOptionallyEnclosed": "\"","excludeSysTable": [],"remapSchema": {"XXXX": "XXXX","XXXX": "XXXX","XXXX": "XXXX","XXXX": "XXXX","XXXX": "XXXX"},"remapTable": {},"remapTablespace": {},"enableSyncTabTbsPro": false,"enableSyncCompTabPro": false,"timeFormat": "HH:MI:SS","dateFormat": "YYYY-MM-DD","dateTimeFormat": "YYYY-MM-DD HH24:MI:SS","timeStampFormat": "YYYY-MM-DD HH24:MI:SSXFFFFFF","timeStampZoneFormat": "YYYY-MM-DD HH24:MI:SSXFFFFFF TZR","noSupportPartTabToNormalTab": true,"ignoreDB2PartInclusive": false,"igNotSupportIntervalPart": false,"igErrorData": false,"enableBatchCommit": false,"ignoreTabPartition": false,"autoAddMaxvaluePart": false,"autoAddMySQLAutoIncr": false,"autoAddMySQLAutoIncrTabList": ["TABLE_1","SCHEMA1.TABLE_1"],"ignoreNotSupportDefault": false,"replaceZeroDate": "","virtualColToNormalCol": false,"virtualColConv": {"LEFT(HOST,POSSTR(HOST,':')-1)": "SPLIT_PART(HOST,':',1)","TRUNC_TIMESTAMP(SNAPTIME,'HH')+ (MINUTE(SNAPTIME)/10*10 +10) MINUTES": "date_trunc('hour',snaptime) + (date_part('minute',snaptime) / 10 +1)::int * interval '10 min'"},"convertPackageMethod": "package","convertOracleIntegerToNumeric": false,"enableOgBlobClob": false,"enableConvertSrid": false,"defaultSrid": "4326","seqLastNumAddNum": 0,"skipColumnType": {"COL_TYPE_1": 1,"COL_TYPE_2": 2},"skipColumnName": {"SCHEMA1.TAB_01.COL1": 1,"SCHEMA1.TAB_01.COL2": 2},"templateSeqName": "{{.TabName}}_{{.ColName}}_SEQ","charAppendEmptyString": false,"tableOptions": {},"indexOptions": {}}},"object": {"tables": [],"schemas": ["ABIZ_READ","CRUCIS","ABIZDBA","ABIZ","ABIZBUY"],"excludeTable": {"SCHEMA1": ["TABLE_SKIP1","TABLE_DUTY_LOG*","^TABLE_DUTY_LOG*","^TABLE_DUTY_LOG.*$"],"SCHEMA2": ["TABLE_SKIP1"]},"tableSplit": {"SCHEMA1": {"TAB_1": ["ID < 10000","ID < 90000 AND ID >=10000","ID >= 90000"]},"SCHEMA2": {"TAB_1": ["ID < 10000","ID < 90000 AND ID >=10000","ID >= 90000"]}}},"limit": {"parallel": 4,"fetchSize": 1000,"batchSize": 1000,"bufferSize": 8,"cpBufferSize": 8,"oracleSelectParallel": 2,"channelCacheNum": 100000,"limit": 0},"dataOnly": false,"schemaOnly": false,"disableTableDataComp": false,"disableCollStatistics": false,"reportFile": "ora2mogdb/report","debug": false,"disableIgnoreCase": false,"disableSelectPart": false,"disableFKCons": false,"disableSyncIdxAfterData": false}
2.6.2 检查配置文件
[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk check-config -c ora2mg/config/mtk.json --preRunuse config : ora2mogdb/config/mtk.jsonThere is no error in the configuration file# 出现如上信息提示配置文件配置正确# 注意，如果只迁移schema，在配置object时，不能将table和schema同时写，否则检查时会报如下错误：[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk check-config -c ora2mogdb/config/mtk.json --preRunuse config : ora2mogdb/config/mtk.jsonError : schema and tables cannot exist togetherschema and tables cannot exist together
2.6.3 MTK迁移配置文件含义
部分MTK迁移配置文件名称及含义描述如下。
三、执行迁移
迁移可以选择只迁移schema、迁移整个库，或者迁移数据库某些表对象。
3.1 执行迁移
-- 整库迁移[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk -c ora2mg/config/mtk.json-- 只迁移schema[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk -c ora2mg/config/mtk.json --schemaOnly-- 迁移数据[omm@opensource-db mtk_2.7.2_linux_amd64]$ ./mtk -c ora2mg/config/mtk.json --file --dataOnly-- 还可以根据需要对部分对象进行迁移-- 可参加官方文档：https://docs.mogdb.io/zh/mtk/v2.0/mtk-usage (分步迁移)
3.2 执行过程
-- 执行迁移时，部分执行过程如下time="2022-12-06 10:25:01.384503" level=info msg="CollTableStatistics XXXX.BUY_XXXX140926" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1599948444963704832time="2022-12-06 10:25:01.384619" level=info msg="CollTableStatistics XXXX.BUY_XXXX141008" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1599948444963704832time="2022-12-06 10:25:01.384329" level=info msg="CollTableStatistics XXXX.TOAD_XXXX" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1599948444963704832time="2022-12-06 10:25:01.384121" level=info msg="CollTableStatistics XXXX.XXXX_TMP" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1599948444963704832time="2022-12-06 10:25:01.384343" level=info msg="CollTableStatistics XXXX.BUY_XXXX" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1599948444963704832time="2022-12-06 10:25:01.384987" level=info msg="Processing CollStatistics finish" taskID=1599948444963704832 function=doTask line=431 file="mtk/pkg/mtk/mtk.go"time="2022-12-06 10:25:01.38506" level=info msg="Finish Begin" line=280 file="mtk/pkg/mtk/mtk.go" taskID=1599948444963704832 function=Stoptime="2022-12-06 10:25:01.541302" level=info msg="Finish end" line=286 file="mtk/pkg/mtk/mtk.go" taskID=1599948444963704832 function=Stop
3.3 执行结果
-- 迁移结束后，会生成如下一些执行结果*********************************Database Migration Toolkit Report*********************************--------------Report Summary--------------+-------------------------------+--------------------+|Source Database Type | oracle ||Source Database Version | 11.2.0.4.0 ||Source Database Charset | ZHS16GBK ||Source Database DatCompat | ||Target Database Type | file ||Target Database Version | 3.0.3 ||Target Database Charset | ZHS16GBK ||Target Database DatCompat | A ||StartTime | 2022-12-06 10:06:49 ||EndTime | 2022-12-06 10:25:01 ||Time | 18 m 11 s ||Status | finish ||MTK Version | v2.7.2_2f0398f2 |+-------------------------------+--------------------+-----------------------Table Data Summary-----------------------+----------------------------------------+----------------------------------------+-------------------+-------------------+------+--------+----------+----------+--------+----------+| SrcName | TgtName | StartTime | EndTime | Time| Status | Select | Insert |Ignore | Size |+----------------------------------------+----------------------------------------+-------------------+-------------------+------+--------+----------+----------+--------+----------+|XXXX.XXXX |XXXX.XXXX |2022-12-06 10:07:11|2022-12-06 10:07:11|2 ms |succeed | 0| 0| 0| 0||XXXX.XXXX |XXXX.XXXX |2022-12-06 10:12:07|2022-12-06 10:12:07|3 ms |succeed | 0| 0| 0| 0||XXXX.XXXX |XXXX.XXXX |2022-12-06 10:07:23|2022-12-06 10:07:23|3 ms |succeed | 0| 0| 0| 0||XXXX.XXXX |XXXX.XXXX |2022-12-06 10:07:12|2022-12-06 10:07:12|3 ms |succeed | 0| 0| 0| 0||XXXX.XXXX |XXXX.XXXX |2022-12-06 10:07:13|2022-12-06 10:07:13|3 ms |succeed | 0| 0| 0| 0||XXXX.XXXX |XXXX.XXXX |2022-12-06 10:07:11|2022-12-06 10:07:11|3 ms |succeed | 0| 0| 0| 0|
-----------------------ObjectName Type Summary-----------------------+------------------+-------------------+-------------------+--------+-----------+-------------+-------------+-------------+--------------------|-------------+| Type | StartTime | EndTime | Status | Total Num | Success Num | Warring Num | Failed Num |Failed(Invalid) Num | Time |+------------------+-------------------+-------------------+--------+-----------+-------------+-------------+-------------+--------------------|-------------+|Schema |2022-12-06 10:06:49|2022-12-06 10:06:49|finish |5 |5 |0 |0 |0 |5 ms ｜|Sequence |2022-12-06 10:06:49|2022-12-06 10:06:50|finish |457 |457 |0 |0 |0 |252 ms ｜|ObjectType |2022-12-06 10:06:50|2022-12-06 10:06:51|finish |5 |5 |0 |0 |0 |1 s 126 ms ｜|Queue |2022-12-06 10:06:51|2022-12-06 10:06:51|finish |0 |0 |0 |0 |0 |8 ms ｜|Table |2022-12-06 10:06:51|2022-12-06 10:06:55|finish |639 |624 |15 |0 |0 |4 s 13 ms ｜|TableData |2022-12-06 10:06:55|2022-12-06 10:24:51|finish |639 |630 |9 |0 |0 |17 m 56 s 397 ms｜|Index |2022-12-06 10:24:51|2022-12-06 10:24:51|finish |1011 |1011 |0 |0 |0 |296 ms ｜|Constraint |2022-12-06 10:24:51|2022-12-06 10:24:52|finish |434 |434 |0 |0 |0 |215 ms ｜|DBLink |2022-12-06 10:24:52|2022-12-06 10:24:52|finish |12 |0 |0 |12 |0 |10 ms ｜|Synonym |2022-12-06 10:24:52|2022-12-06 10:24:52|finish |61 |61 |0 |0 |0 |31 ms ｜|View |2022-12-06 10:24:52|2022-12-06 10:24:53|finish |21 |19 |2 |0 |0 |1 s 219 ms ｜|MaterializedView |2022-12-06 10:24:53|2022-12-06 10:24:53|finish |31 |31 |0 |0 |0 |464 ms ｜|Function |2022-12-06 10:24:53|2022-12-06 10:24:54|finish |51 |43 |7 |1 |0 |1 s 10 ms ｜|Procedure |2022-12-06 10:24:54|2022-12-06 10:24:58|finish |34 |24 |10 |0 |0 |3 s 871 ms ｜|Package |2022-12-06 10:24:58|2022-12-06 10:24:58|finish |0 |0 |0 |0 |0 |11 ms ｜|Trigger |2022-12-06 10:24:58|2022-12-06 10:25:01|finish |440 |440 |0 |0 |0 |2 s 445 ms ｜|AlterSequence |2022-12-06 10:25:01|2022-12-06 10:25:01|finish |457 |457 |0 |0 |0 |104 ms ｜|CollStatistics |2022-12-06 10:25:01|2022-12-06 10:25:01|finish |639 |630 |9 |0 |0 |137 ms ｜+------------------+-------------------+-------------------+--------+-----------+-------------+-------------+-------------+--------------------|-------------+[2022-12-06 10:25:06.446002] INFO reportDir : ora2mg/report/report_20221206102506 function=PrintReport line=364 file=mtk/cmd/mtk/cmd/mtk.go[2022-12-06 10:25:06.704871] INFO the text report : ora2mg/report/report_20221206102506.txt function=HTMLReportToFIle line=134 file=mtk/pkg/report/report.go[2022-12-06 10:25:07.794547] INFO the warring report : ora2mg/report/report_20221206102506.warring function=HTMLReportToFIle line=141 file=mtk/pkg/report/report.go[2022-12-06 10:25:07.813135] INFO the error report : ora2mg/report/report_20221206102506.err function=HTMLReportToFIle line=148 file=mtk/pkg/report/report.go[2022-12-06 10:25:07.827778] INFO the excel report : ora2mg/report/report_20221206102506.xlsx function=HTMLReportToFIle line=155 file=mtk/pkg/report/report.go-- report 各文件及目录含义ora2mg/report/report_20221206102506 html 报告ora2mg/report/report_20221206102506.txt 文本报告ora2mg/report/report_20221206102506.warring 只包含警告信息的文本报告ora2mg/report/report_20221206102506.err 只包含错误信息的文本报告ora2mg/report/report_20221206102506.xlsx 包含导出过程的xlsx文件信息报告ora2mg/report/report_20221206100649.log 导出过程日志记录
3.4 查看报告
将report 目录report_xxx目录打包下载到本地电脑，然后解压后打开index.html文件，可查看导出的相关报告信息。
还可以根据需要采用如下方式导出指定报告信息：
-- 导出整库迁移报告./mtk -c ora2mg/config/mtk.json --file-- 导出仅含schema的信息报告./mtk -c ora2mg/config/mtk.json --file --schemaOnly-- 导出仅含数据的信息报告./mtk -c ora2mg/config/mtk.json --file --dataOnly
四、验证测试
数据迁移仅仅是第一步，在迁移过程中也出现了一些问题，比如部分表未迁移成功，如何跨字符集迁移，迁移后的SQL语句执行结果及效率，这方面还需要花大量时间去解决。
本次测试使用MTK，第一感觉这个迁移工具做的真的挺不错，对源端无侵入性，无需源端部署相关软件。
欢迎大家关注我视频公众号和微信公众号
原文作者：尚雷的驿站；如有侵权，请联系管理员删除。
下一篇：
记一次Oracle DG备库实例宕分析
请登录后发表评论
登录
全部评论
最新文章
- 记一次 Oracle 19c RAC 因为硬件时钟异常导致 CRS 无法正常启动故障处理记录
- AI万能胶：从挂钩到黏合，一切都靠“智”造
- 跟着博主学习 Halo 数据库带你高薪带你飞
- 【故障处理系列】elasticsearch 索引未正常分片导致集群状态异常如何分析处理
- Elasticsearch max_result_window 含义及参数调整
- Oracle ACE夜话--和首席-总监一起跟大家谈一谈分布式数据库
- openGauss 6.0.0 一主二备集群安装及使用zcbus实现Oracle到openGauss的数据全量和增量同步
- ES检测kibana端口是否宕并自动拉起进程
- clickhouse备份恢复学习分享
- 臭宝，满足您的需求，上大招，今天再分享一个我编写且非常好用处理Elasticsearch集群异常状态的脚本
