What are the two methods that could be used during the migration of your existing Oracle database to autonomous database?


Page 2


Page 3

  • Enter your source database parameters.

    • DB_CONSTRING: Source database connect string. For example, //ip address/DB122H1 or //host name/DB122H1.
    • SYSTEM_DB_PASSWORD: Source database system password (sys password) that is encrypted with the mv2adb encpass command.
    • SCHEMAS: Comma separated schemas to export and import.
    • FULL: Enter Y for a full Oracle Data Pump Export (expdp).
    • EXCLUDE: Schemas to be excluded from the export. Use a comma separated list.
    • REMAP: Defines how the source tablespace is mapped on the target autonomous database (ADB). The format is SOURCE_tablespace:ADB_tablespace. Use a comma separated list.
    • DUMP_NAME: ExpDP dump file name.
    • DUMP_PATH: Path where the expdp dump will be created.
    • DUMP_FILES: Comma separated list of dump files. This parameter is used only by "listdump, getdump, putdump, deldump, and impdp functions. When using impdp, the path is not important, only the filename is used.
    • OHOME: # RDBMS Oracle Home.
    • ICHOME: # Instant Client Oracle Home. If the source database is 11g or 12c, then this parameter is required. If the source database is 18c or above, then the impdp supports the object store.

    #------------------------------------------# # DB Parameters # #------------------------------------------# DB_CONSTRING=//host name/DB122H1 SYSTEM_DB_PASSWORD=mv2adb_encrypted_password SCHEMAS=SCHEMA_1,SCHEMA_2,SCHEMA_3,SCHEMA_4 REMAP=TBS_1:DATA,TBS_1:DATA,TBS_3:DATA,TBS_4:DATA DUMP_NAME=expdp.dmp DUMP_PATH=/tmp DUMP_FILES=/tmp/expdp_01.dmp,/tmp/expdp_02.dmp OHOME=/u01/app/oracle/product/12.2.0.1/dbhome_1 ICHOME=/home/RC-SHARED/Software-Tools/Software/instantclient_18_3

  • Enter the Oracle Data Pump export (Expdp), import (Impdp), and compression parameters.

    • ENC_PASSWORD: The Expdp and Impdp encrypted password. Use the password encrypted by mv2adb encpass.

    • ENC_TYPE: The Expdp and Impdp encryption type {AES128 | AES192 | AES256}. The default is AES128.

    • COMPRESSION: The Expdp compression type {ALL | DATA_ONLY | METADATA_ONLY | NONE}. The default is NONE.

    ENC_PASSWORD=mv2adb_encrypted_password ENC_TYPE=AES256 COMPRESSION=ALL

  • Enter the autonomous database properties.

    • ADB_NAME: Database name.

    • ADB Database admin password.

    • ADB_CORES: (Optional) skip auto check.

    • ADB_TARGET: (Optional) use with the advisor command {ADW|ATP|ATPD}.

    • ADB_CFILE: Name of the credential zip file.

    # ADB Properties # #------------------------------------------# ADB_NAME=myatp ADB_PASSWORD=mv2adb_encrypted_password ADB_CFILE=/opt/mv2adb/source/ATP_wallet.zip

  • Enter the Oracle Cloud Infrastructure Object Storage properties.

    For the OCI_HOST, use swift, not object store. For the OCI_PASSWORD, use the encrpted authentication tokens password.

    • OCI_HOST: Swift URI format endpoint, mandatory if OCIC=false or is not defined.

    • OCI_NAMESPACE: Mandatory if OCIC=false or is not defined.

    • OCI_BUCKET: Name of the bucket.

    • OCI_ID: Oracle Database Backup Cloud Service account.

    • OCI_PASSWORD: Oracle Cloud Infrastructure auth token password. Use the password encrypted by mv2adb encpass.

    • PROXY_HOST, PROXY_PORT, PROXY_ID, and PROXY_PASSWORD: (Optional) If you use a proxy, then enter your proxy details. Use the password encrypted by mv2adb encpass.

    # Object Store Properties # #------------------------------------------# OCI_HOST=https://swiftobjectstorage.us-phoenix-1.oraclecloud.com OCI_NAMESPACE=NAMESPACE_NAME OCI_BUCKET=BUCKET_NAME OCI_ID= OCI_PASSWORD=mv2adb_encrypted_password PROXY_HOST= PROXY_PORT= PROXY_ID= PROXY_PASSWORD=

  • Enter the Oracle Cloud Infrastructure client properties.

    • OCIC: (Optional). If true, then oci-client is used.

    • OCIC_SIZE: Split file size in Mb (Default: 128)

    • OCIC_PARALLEL: Parallel upload count (Default: 3)

    • OCIC_COMPART_ID: Oracle Cloud Infrastructure Object Storage Compartment (required with the commands list bucket and create bucket using the oci-cli command line.

    • OCI_ID: Oracle Database Backup Cloud Service account.

    #------------------------------------------# # OCI-Client Properties # #------------------------------------------# OCIC=true OCIC_SIZE=10 OCIC_PARALLEL=10 OCIC_COMPART_ID=ocid1.compartment.oc1..aaaaaaaaymakantllqnlcf5l73trwrdnl5wfc5ccxzbed7tuoyc4nnjj37yq


  • Page 4