mv2oci is a tool which helps to migrate on-premise data to the Oracle Cloud Infrastructure based on Oracle Data Pump and works as a data load tool. The local Data Pump export is transferred and imported to/on the target cloud server automatically. There is no use of Oracle Cloud Object Storage, the dump files are transferred with rsync or scp to the target database node. This is the different behavior to mv2adb – see my blogpost here – which uses the Object Storage. As an option, the data can be transferred via Database Link (mv2oci Parameter –netlink).
All you need to know about mv2oci is written in the My Oracle Support Note (OCI) MV2OCI: move data to Oracle Cloud Database in “one-click” (Doc ID 2514026.1). The newest version of the rpm package can be downloaded there. The package has to be installed on the source server.
Prerequisites
- SQL*Net connection between the two databases
- A Java executable – in my case I have installed jre (yum install jre)
- Verify if the firewall to the VCN Subnet is open for Port 1521 – Port 22 is open as per default
- Password of database user SYSTEM
The Use Case
Let’s move the database schema SOE from my on-premise Oracle Linux Server into the cloud step-by-step. An Oracle Cloud Infrastructure database instance is already up and running, the target tablespace is created. The data centers are connect by VPN.
Database Information
| Source | Target | |
| CDB Name | CDB118 | CDB118 |
| PDB Name | pdb11801 | pdboci |
| Hostname | heckenweg | srv-cdb118 |
| IP Address | 192.168.1.184 | 172.16.0.8 |
| PDB Service Name | pdb11801.kestenholz.net | pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com |
1. Package Installation
Download and transfer the package to the on-premise server, for example in directory /tmp. As user root, install the package.
# rpm -ihv mv2oci-2.0.2-3.el7.x86_64.rpm warning: mv2oci-2.0.2-3.el7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 939112d6: NOKEY Verifying... ################################# [100%] Preparing... ################################# [100%] Updating / installing... 1:mv2oci-2.0.2-3 ################################# [100%] mv2oci-2.0.2.3 binary has been installed on /opt/mv2oci succesfully!
Verify that the SSH private key which is used for the connection to the Oracle Cloud Infrastructure server is available and the connection is working. Here is the OCI SSH key available in the $HOME/.ssh.
$ ssh -i $HOME/.ssh/id_rsa_oci_29012020 opc@172.16.0.8 Last login: Fri Oct 30 05:39:27 2020 from 192.168.1.235 [opc@srv-cdb118 ~]$
2. Encrypt the SYSTEM passwords for both databases – mv2oci encpass
# ./mv2oci.bin encpass Please enter the password : Please re-enter the password : 79F510449D6D43B028EB2E5FCC7CC71A336F363F123456789ABCDEFGHIJKLMNO
3. Configuration File
A template of the configuration file is located in /opt/mv2oci/oci. I used the following parameters – other parameters like ICHOME for Instance Client configuration are well described.
Source DB Parameters
| Parameter | Value |
| DB_CONSTRING | //heckenweg/pdb11801.kestenholz.net |
| SYSTEM_DB_PASSWORD | Encrypted SYSTEM password |
| SCHEMAS | SOE |
| DUMP_FILES | /tmp/exp_soe_18102020_01.dmp, /tmp/exp_soe_18102020_02.dmp |
| OHOME | /u01/app/oracle/product/19.0.0/dbhome_1 |
Expdp/Impdp Parameters
| Parameter | Value |
| Dump Name | exp_soe_18102020.dmp |
| DUMP_PATH | /tmp |
| PARALLEL | 2 – creates two Dumpfiles called exp_soe_18102020_01.dmp and exp_soe_18102020_02.dmp |
OCI Parameters
| Parameter | Value |
| OC_HOST | 172.16.0.8 |
| OC_SSHKEY | /home/oracle/.ssh/id_rsa_oci_29012020 |
| OC_DB_CONSTRING | //172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com |
| OC_DB_PASSWORD | Encrypted SYSTEM password |
| OC_DUMP_LOC | /tmp |
4. Export Data – mv2oci expdp
# ./mv2oci.bin expdp --conf conf/CDB118.mv2oci.cfg INFO: 2020-10-30 06:32:51: Please check the logfile '/opt/mv2oci/out/log/mv2oci_314519.log' for more details │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ mv2oci - Move data to Oracle Cloud Infrastructure (OCI) Version: 2.0.2-3 Copyright (c) 1982-2019 Oracle and/or its affiliates. -------------------------------------------------------- Author: Ruggero Citton <ruggero.citton@oracle.com> RAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ INFO: 2020-10-30 06:32:51: Reading configuration file 'conf/CDB118.mv2oci.cfg' INFO: 2020-10-30 06:32:51: Using Oracle Home '/u01/app/oracle/product/19.0.0/dbhome_1/' INFO: 2020-10-30 06:32:51: Getting source DB version INFO: 2020-10-30 06:32:52: Checking schemas on source database '//heckenweg/pdb11801.kestenholz.net' INFO: 2020-10-30 06:32:53: Creating expdp directory 'MV2OCI_DP_DIR' for path '/tmp' INFO: 2020-10-30 06:32:54: Getting latest SCN INFO: 2020-10-30 06:32:55: Expdp parallelism set by parameter '2' INFO: 2020-10-30 06:32:55: Executing Expdp as jobname 'MV2OCI_JOB' INFO: 2020-10-30 06:32:55: Expdp log location available at the end of the process is '/opt/mv2oci/out/log/mv2oci_expdp_314519.log' FLASHBACK automatically enabled to preserve database integrity. Starting "SYSTEM"."MV2OCI_JOB": system/********@//heckenweg/pdb11801.kestenholz.net SILENT=BANNER JOB_NAME=MV2OCI_JOB SCHEMAS=SOE VERSION=19.0.0 DIRECTORY=MV2OCI_DP_DIR DUMPFILE=exp_soe_18102020_%u.dmp PARALLEL=2 REUSE_DUMPFILES=y LOGFILE=mv2oci_expdp_314519.log FILESIZE=4G FLASHBACK_SCN=6980091 Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT . . exported "SOE"."ORDERS" 129.1 MB 1429790 rows . . exported "SOE"."ORDER_ITEMS" 380.1 MB 7138088 rows . . exported "SOE"."CUSTOMERS" 108.1 MB 1000000 rows . . exported "SOE"."ADDRESSES" 110.0 MB 1500000 rows . . exported "SOE"."CARD_DETAILS" 63.87 MB 1500000 rows . . exported "SOE"."LOGON" 51.24 MB 2382984 rows . . exported "SOE"."PRODUCT_DESCRIPTIONS" 220.8 KB 1000 rows . . exported "SOE"."PRODUCT_INFORMATION" 188.6 KB 1000 rows . . exported "SOE"."WAREHOUSES" 35.42 KB 1000 rows . . exported "SOE"."ORDERENTRY_METADATA" 5.609 KB 4 rows . . exported "SOE"."INVENTORIES" 15.27 MB 901957 rows Master table "SYSTEM"."MV2OCI_JOB" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.MV2OCI_JOB is: /tmp/exp_soe_18102020_01.dmp /tmp/exp_soe_18102020_02.dmp Job "SYSTEM"."MV2OCI_JOB" successfully completed at 00:00 INFO: 2020-10-30 06:33:20: Following expdp dump has been created: DUMP_FILES=/tmp/exp_soe_18102020_01.dmp,/tmp/exp_soe_18102020_02.dmp SUCCESS: 2020-10-30 06:33:20: Expdp executed successfully
Dump files created in /tmp.
# ls -la /tmp/*.dmp -rw-r-----. 1 oracle oinstall 569135104 Oct 30 06:33 /tmp/exp_soe_18102020_01.dmp -rw-r-----. 1 oracle oinstall 331845632 Oct 30 06:33 /tmp/exp_soe_18102020_02.dmp
5. Transfer Data – mv2oci putdump
# ./mv2oci.bin putdump --conf conf/CDB118.mv2oci.cfg INFO: 2020-10-30 06:42:41: Please check the logfile '/opt/mv2oci/out/log/mv2oci_319424.log' for more details │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ mv2oci - Move data to Oracle Cloud Infrastructure (OCI) Version: 2.0.2-3 Copyright (c) 1982-2019 Oracle and/or its affiliates. -------------------------------------------------------- Author: Ruggero Citton <ruggero.citton@oracle.com> RAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ INFO: 2020-10-30 06:42:41: Reading configuration file 'conf/CDB118.mv2oci.cfg' INFO: 2020-10-30 06:42:41: Checking OCHost '172.16.0.8' connectivity INFO: 2020-10-30 06:42:42: Determining if using rsync or scp to transfer dump files INFO: 2020-10-30 06:42:42: Using 'rsync' to transfer dump files INFO: 2020-10-30 06:42:42: Making required dump dir '/tmp' on remote '172.16.0.8' INFO: 2020-10-30 06:42:42: Uploading dump files over '172.16.0.8' using 'rsync' INFO: 2020-10-30 06:42:42: Copying /tmp/exp_soe_18102020_01.dmp.... INFO: 2020-10-30 06:42:42: Copying /tmp/exp_soe_18102020_02.dmp.... SUCCESS: 2020-10-30 06:43:06: Dump file ' /tmp/exp_soe_18102020_02.dmp' uploaded successfully SUCCESS: 2020-10-30 06:43:24: Dump file '/tmp/exp_soe_18102020_01.dmp' uploaded successfully INFO: 2020-10-30 06:43:24: Setting required permission for dump dir '/tmp' on remote '172.16.0.8' SUCCESS: 2020-10-30 06:43:28: Dump files uploaded over '172.16.0.8' successfully
Files are available now on target server.
$ ls -la /tmp/*.dmp -rw-rw-rw- 1 oracle oinstall 569135104 Oct 30 05:43 /tmp/exp_soe_18102020_01.dmp -rw-rw-rw- 1 oracle oinstall 331845632 Oct 30 05:43 /tmp/exp_soe_18102020_02.dmp
6. Import Data
Tablespace SOEDATA exists on target server, otherwise you can use to the EXTRA_IMPDP parameters in the mv2oci configuration file to do a remapping etc.
# ./mv2oci.bin impdp --conf conf/CDB118.mv2oci.cfg INFO: 2020-10-30 06:49:33: Please check the logfile '/opt/mv2oci/out/log/mv2oci_322277.log' for more details │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ mv2oci - Move data to Oracle Cloud Infrastructure (OCI) Version: 2.0.2-3 Copyright (c) 1982-2019 Oracle and/or its affiliates. -------------------------------------------------------- Author: Ruggero Citton <ruggero.citton@oracle.com> RAC Pack, Cloud Innovation and Solution Engineering Team │▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│ INFO: 2020-10-30 06:49:33: Reading configuration file 'conf/CDB118.mv2oci.cfg' INFO: 2020-10-30 06:49:33: Using Oracle Home '/u01/app/oracle/product/19.0.0/dbhome_1/' INFO: 2020-10-30 06:49:33: Expdp parallelism set by parameter '2' INFO: 2020-10-30 06:49:33: Creating impdp directory 'MV2OCI_DP_DIR' for path '/tmp' on '172.16.0.8' INFO: 2020-10-30 06:49:34: Executing import datapump as jobname 'MV2OCI_JOB' INFO: 2020-10-30 06:49:34: Impdp log location available at the end of the process is '/opt/mv2oci/out/log/mv2oci_impdp_322277.log' Master table "SYSTEM"."MV2OCI_JOB" successfully loaded/unloaded Starting "SYSTEM"."MV2OCI_JOB": system/********@//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com SILENT=BANNER JOB_NAME=MV2OCI_JOB DIRECTORY=MV2OCI_DP_DIR DUMPFILE=exp_soe_18102020_01.dmp,exp_soe_18102020_02.dmp LOGFILE=mv2oci_impdp_322277.log PARALLEL=2 Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "SOE"."ORDERS" 129.1 MB 1429790 rows . . imported "SOE"."CUSTOMERS" 108.1 MB 1000000 rows . . imported "SOE"."ADDRESSES" 110.0 MB 1500000 rows . . imported "SOE"."ORDER_ITEMS" 380.1 MB 7138088 rows . . imported "SOE"."CARD_DETAILS" 63.87 MB 1500000 rows . . imported "SOE"."LOGON" 51.24 MB 2382984 rows . . imported "SOE"."PRODUCT_DESCRIPTIONS" 220.8 KB 1000 rows . . imported "SOE"."PRODUCT_INFORMATION" 188.6 KB 1000 rows . . imported "SOE"."WAREHOUSES" 35.42 KB 1000 rows . . imported "SOE"."ORDERENTRY_METADATA" 5.609 KB 4 rows . . imported "SOE"."INVENTORIES" 15.27 MB 901957 rows Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER ORA-39082: Object type PACKAGE BODY:"SOE"."ORDERENTRY" created with compilation warnings Job "SYSTEM"."MV2OCI_JOB" completed with 1 error(s) at 00:00 ERROR: 2020-10-30 06:51:14: Executing impdp on remote '//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com'
Analysis of the error in the SQL*Developer – there is a missing execution permission on package DBMS_LOCK.
This is an easy thing:
SQL> GRANT EXECUTE ON dbms_lock TO SOE; Grant succeeded.
7. Reporting – mv2oci report
The report compares the objects on source and target database.
# ./mv2oci.bin report --conf conf/CDB118.mv2oci.cfg
INFO: 2020-10-30 07:00:13: Please check the logfile '/opt/mv2oci/out/log/mv2oci_327866.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2oci - Move data to Oracle Cloud Infrastructure (OCI)
Version: 2.0.2-3
Copyright (c) 1982-2019 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2020-10-30 07:00:13: Reading configuration file 'conf/CDB118.mv2oci.cfg'
INFO: 2020-10-30 07:00:14: using Oracle Home '/u01/app/oracle/product/19.0.0/dbhome_1/'
INFO: 2020-10-30 07:00:14: Getting Obj report for '//heckenweg/pdb11801.kestenholz.net'
0
Database Objects REPORT for //heckenweg/pdb11801.kestenholz.net
SOE |INDEX | 27
SOE |PACKAGE | 1
SOE |TABLE | 11
SOE |VIEW | 2
SOE |SEQUENCE | 5
SOE |PACKAGE BODY| 1
| |----------
sum | | 47
INFO: 2020-10-30 07:00:15: Getting Segments report for '//heckenweg/pdb11801.kestenholz.net'
0
Database Segments REPORT for //heckenweg/pdb11801.kestenholz.net
SOE |PRD_DESC_PK |INDEX | .125
SOE |WHS_LOCATION_IX |INDEX | .0625
SOE |ORD_CUSTOMER_IX |INDEX | 27.1875
SOE |INVENTORIES |TABLE | 176
SOE |ORD_WAREHOUSE_IX |INDEX | 30.1875
SOE |INVENTORY_PK |INDEX | 18
SOE |CARD_DETAILS |TABLE | 80
SOE |ORDERS |TABLE | 160
SOE |CUSTOMERS_PK |INDEX | 18.625
SOE |PROD_SUPPLIER_IX |INDEX | .125
SOE |PRODUCT_INFORMATION |TABLE | .25
SOE |ORDER_ITEMS_PK |INDEX | 146.5
SOE |ORDER_PK |INDEX | 25.9375
SOE |ORD_ORDER_DATE_IX |INDEX | 31.875
SOE |INV_WAREHOUSE_IX |INDEX | 16.6875
SOE |ORDERENTRY_METADATA |TABLE | .0625
SOE |CARD_DETAILS_PK |INDEX | 27.1875
SOE |ORD_SALES_REP_IX |INDEX | 25.5625
SOE |PROD_CATEGORY_IX |INDEX | .0625
SOE |CUST_ACCOUNT_MANAGER_IX |INDEX | 18.625
SOE |CUSTOMERS |TABLE | 136
SOE |ADDRESSES |TABLE | 136
SOE |ORDER_ITEMS |TABLE | 464
SOE |PRODUCT_INFORMATION_PK |INDEX | .0625
SOE |ADDRESS_CUST_IX |INDEX | 28.4375
SOE |ITEM_PRODUCT_IX |INDEX | 120.5625
SOE |LOGON |TABLE | 64
SOE |PRODUCT_DESCRIPTIONS |TABLE | .3125
SOE |ADDRESS_PK |INDEX | 27.125
SOE |WAREHOUSES_PK |INDEX | .0625
SOE |PROD_NAME_IX |INDEX | .125
SOE |CARDDETAILS_CUST_IX |INDEX | 28.4375
SOE |WAREHOUSES |TABLE | .0625
SOE |ITEM_ORDER_IX |INDEX | 130.875
SOE |INV_PRODUCT_IX |INDEX | 16.75
SOE |CUST_DOB_IX |INDEX | 23.1875
SOE |CUST_EMAIL_IX |INDEX | 41.25
SOE |CUST_FUNC_LOWER_NAME_IX |INDEX | 29.0625
| | |----------
sum | | | 2049.375
INFO: 2020-10-30 07:00:16: Getting Obj report for '//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com'
0
Database Objects REPORT for //172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.or
SOE |INDEX | 27
SOE |PACKAGE | 1
SOE |SEQUENCE | 5
SOE |TABLE | 11
SOE |VIEW | 2
SOE |PACKAGE BODY| 1
| |----------
sum | | 47
INFO: 2020-10-30 07:00:17: Getting Segments report for '//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com'
0
Database Segments REPORT for //172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.o
SOE |WHS_LOCATION_IX |INDEX | .0625
SOE |PRD_DESC_PK |INDEX | .0625
SOE |ORD_CUSTOMER_IX |INDEX | 26
SOE |INVENTORIES |TABLE | 176
SOE |ORD_WAREHOUSE_IX |INDEX | 29
SOE |INVENTORY_PK |INDEX | 18
SOE |ORDERS |TABLE | 160
SOE |CARD_DETAILS |TABLE | 80
SOE |PROD_SUPPLIER_IX |INDEX | .0625
SOE |CUSTOMERS_PK |INDEX | 17
SOE |PRODUCT_INFORMATION |TABLE | .25
SOE |ORDER_ITEMS_PK |INDEX | 144
SOE |ORDER_PK |INDEX | 25
SOE |ORD_ORDER_DATE_IX |INDEX | 31
SOE |INV_WAREHOUSE_IX |INDEX | 15
SOE |ORDERENTRY_METADATA |TABLE | .0625
SOE |PROD_CATEGORY_IX |INDEX | .0625
SOE |ORD_SALES_REP_IX |INDEX | 24
SOE |CUST_ACCOUNT_MANAGER_IX |INDEX | 17
SOE |CARD_DETAILS_PK |INDEX | 26
SOE |ADDRESSES |TABLE | 136
SOE |CUSTOMERS |TABLE | 136
SOE |ORDER_ITEMS |TABLE | 464
SOE |ADDRESS_CUST_IX |INDEX | 27
SOE |ITEM_PRODUCT_IX |INDEX | 120
SOE |PRODUCT_INFORMATION_PK |INDEX | .0625
SOE |PRODUCT_DESCRIPTIONS |TABLE | .3125
SOE |LOGON |TABLE | 64
SOE |WAREHOUSES_PK |INDEX | .0625
SOE |ADDRESS_PK |INDEX | 26
SOE |PROD_NAME_IX |INDEX | .125
SOE |CARDDETAILS_CUST_IX |INDEX | 27
SOE |WAREHOUSES |TABLE | .0625
SOE |ITEM_ORDER_IX |INDEX | 136
SOE |CUST_DOB_IX |INDEX | 22
SOE |CUST_EMAIL_IX |INDEX | 40
SOE |INV_PRODUCT_IX |INDEX | 15
SOE |CUST_FUNC_LOWER_NAME_IX |INDEX | 28
| | |----------
sum | | | 2030.1875
8. All in One – mvoci auto
We did the steps one-by-one, by using the parameter auto, the steps above are done automatically (except reporting).
# ./mv2oci.bin auto --conf conf/CDB118.mv2oci.cfg
9. Logfiles
Logfiles tom the mv2oci actions are located in:
| mv2oci | /opt/mv2oci/out/log |
| Data Pump | Directory in parameter DUMP_PATH |
Summary
mv2oci is another great tool to support the movement to Oracle Cloud Infrastructure. Easy to configure, easy to use. #ilike