Migrate to Oracle Cloud Database within “1-Click”

Introduction:

Oracle provide a tool called MV2OCI(Move to Oracle Cloud Database) and it is a new tool is permitting the load data and migration from “on premises” to Oracle Cloud Database leveraging on Oracle Data Pump and within one command. Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Database node.

 

This tool available as Rpm “mv2oci-2.0.2-7.el7.x86_64.rpm”. When you install the tool you will get the executable file.

 

 

MV2OCI features & operations

Move to Oracle Cloud Database is supporting multiple operations to manage the load/migration data life-cycle from “on premises” to Oracle Cloud Database. MV2OCI is leveraging on Oracle Data Pump(expdp, impdp).

 

MV2OCI operations are:

• Auto Datapump operation:
  • auto
• Remote Clone operation:
  • clone
• ExpDP Operations:
  • expdp
• ImpDP Operations:
  • impdp
• Oracle dump files Operations:
  • deldump
  • getdump
  • listdump
  • putdump
• Database Schema operation:
  • report
  • recomp
• Encrypt password Operations:
  • encpas

 

MV2OCI tool can do the above-mentioned operations. Let us take one operation ex(auto) and will see that options and usage.

 

 

Syntax of this tool for Auto operation:

 

“Auto” operation is “one command operation” to perform the entire load data process (using Datapump) into Oracle Cloud Database:

1. expdp from source (schemas based)
2. upload datapump dump files over Oracle Cloud Database node (if “–netlink” is not in use)
3. impdp into Oracle Cloud Database

mv2oci auto {–conf <conf file path> [–netlink] [–goldengate] [–nosudo]} |
{–dbcs <Source DB connect string>
–ohome <Local ORACLE_HOME> | –ichome <Local Oracle Instant Client Home>
–schemas <Database schemas to export> | –full y [–exclude <Database schemas to exclude>] {–dumpname <expdp dump file name> –dumppath <expdp dump file path> }
|
{–netlink}
–ochost <ip cloud db node>
–ocsshkey <ssh private key>
–ocdbcs <Oracle Cloud Target Database Connect String>
[–ocdumploc <remote path where store dumpfile>] [–remap <comma separated tablespace remap SOURCE_TBS:TARGET_TBS] [–parallel <parallel degree>] [–extra_expdp <extra expdp parameters>] [–extra_impdp <extra impdp parameters>] [–jobname <expdp/impdp job name>] [–filesize <expdp filesize in Gb>] [–encryption [–enctype AES128 | AES192 | AES256]]] [–report] [–ctype rsync|scp] [–cparallel <max parallel copy process>] [–proxyHost <host> [–proxyPort <port>]] [–goldengate] [–nosudo] }

Sample Usage of Auto operation:

./mv2oci.bin auto –dbcs //<host name/ip address>/DB122H1 \
–ohome /u01/app/oracle/product/12.2.0.1/dbhome_1 \
–schemas SCHEMA_1,SCHEMA_2,SCHEMA_3,SCHEMA_4 \
–dumpname expdp.dmp –dumppath /tmp \
–ochost <OC host name/ip address> \
–ocsshkey /root/.ssh/OCI_rsa \
–ocdbcs //<OC host name/ip address>/<OC DB Name> \
–parallel 2 \
–remap SOURCE_TBS1:TARGET_TBS1,SOURCE_TBS2:TARGET_TBS2,SOURCE_TBS3:TARGET_TBS3,SOURCE_TBS3:TARGET_TBS3 \
–encryption –enctype AES256

 

Note: You can skip the datapump dump create/upload to the target Oracle Cloud host using ‘–netlink’ option. Using ‘–netlink’ the data are going directly to OCDB (Oracle Cloud Database) trough a Database Link created automatically by MV2OCI.

 

I believe this post give some slight information about mv2oci for more detail please refer the oracle note:2514026.1

 

Thanks for reading.