1. Click on Enterprise from the main menu bar, select Migration and Consolidation then Database Migration Workbench, this loads the Database Migration screen. Select Data Pump under Migration Method.

   Click Create Migration Activity.

2. Enter a migration name under Name Activity. Under Migrate select Full Database.
   1. Select Source Database, click on the bar and select a database or search for a database.

      Click on the Source Database to be migrated.

   2. Select Destination Database, click on the bar and select a database, search for a database or create a new PDB.

      Note:

      When selecting any non ADB migration you have an option to create a new PDB in the drop down menu. A dialog appears for you to enter required information for a new PDB.

      Click on the Destination Database that will receive the migration.

   Review the summary of both Source and Destination databases, then click Continue.
3. Upload Migration Tools: (Optional) Enterprise Manager automatically downloads the latest version of the tools, however if they are not available from the Software Library for your operating system you will need to upload them, click on Upload Migration Tools. For more information see Upload Migration Tools.
   • Select Upload Instant Client to upload Instance Client files to the Software Library. This is only needed for ADB migrations only.
   • Select Cloud Pre-migration Advisor Tool (CPAT) to upload the CPAT files to the Software Library. For Oracle Enterprise Manager 13 Release 5 Update 3 (13.5.0.3) and below CPAT is not available, use Schema Advisor for Autonomous Database migrations.

   Select whether to upload the ZIP files from a local or agent machine, click on Upload and Continue.

4. The Add Details page shows a summary of the information entered:
   • Source: Ensure the information is correct, select the Agent Host Credentials and Database Credentials (Preferred or Named).

     Note:

     Oracle Enterprise Manager's Migration Workbench now supports authentication using Database Kerberos Credentials and Database Kerberos Keytab Credentials with Data Pump migrations. Microsoft Active Directory users can be exclusively mapped to a database account and authenticated with a Kerberos password or a Keytab file without password and human interaction. If these are configured they will appear from the credential drop down menu.
   • Destination: Ensure the information is correct and select the Database Credentials and Monitoring Agent Host Credentials (Preferred or Named). If required you can specify the Service Name.

     Enter the Wallet Password for TDE enabled databases.

   • Action:

     Note:

     Do not use SYSDBA as the named credentials for Data Pump Export and Import. SYSDBA should only be used at the request of Oracle technical support.
     • Select Recompile Invalid Objects After Migration to recompile all invalid objects within schema once a migration successfully completes.
     • Under Source Data Pump Directory

       For On Premise to ADB: Enter and confirm the Encryption Password, enter the Cloud Storage URL, Bucket Name and Credentials.

       For On Premise to non ADB: Enter and confirm the Encryption Password. Cloud Storage URL and Bucket Name are not needed as the dump is passed from host to host.

     • Under Database OCI Auth Credential the default cloud credential will be shown and preselected, you can select a different credential from the list if required. This field is for ADB migrations only.
     • Enter and confirm the Encryption Password if required.
   Click Next.
5. In the Customize page, set the export and import options as needed:
   • Export Options:
     • EXCLUDE: Tables that are to be excluded and not migrated.
     • ENCRYPTION: Password to encrypt/decrypt datapump dump files.
     • ENCRYPTION ALGORITHM: Specifies which cryptographic algorithm should be used for encryption (AES128, AES192, AES256).
     • CONTENT: Select whether to export DATA, METADATA, or both. It is recommended to first perform a METADATA only migration as a test before performing a DATA migration.
     • PARALLEL: Specifies the maximum number of processes of active execution operating on behalf of the export job.
   • Import Options:
     • TABLE EXISTS ACTION: Action to be taken if the table exists at the destination database (skip or replace).
     • DATA_OPTIONS: This parameter designates how certain types of data should be handled during import operations.
     • PARALLEL: Specifies the maximum number of processes of active execution operating on behalf of the import job.
     • REMAP SCHEMA: Loads all objects from the source schema into a target schema.
     • REMAP TABLESPACE: Remaps all objects selected for import with persistent data in the source tablespace to be created in the target tablespace.
     • TRANSFORM: Enables you to alter object creation DDL for objects being imported.
   • Upload Options: Select whether a Monitoring Agent from the Source Database or a Different Agent will be used. If you select Different Agent enter the Agent, Host Credential and Stage Directory where it is located.
   • Select Compare Performance After Migration to configure and allow performance and comparison analytics after migration using SQL Performance Analyzer (SPA).

     Note:

     When running SPA make sure to export your schema as it is needed to stage the tuning set. Failure to do so will generate an error while performing validations.

     SPA is not available for Metadata only Data pump migrations.

   • Custom Scripts: Enter any custom Pre or Post scripts you may require for the migration. These scripts must be uploaded to the Software Library beforehand.
     • Script Location: Location of the Pre/Post scripts within the Software Library.
     • Pre-Migration Script: Default is No, select the script you wish to run.
     • Post-Migration Script: Default is No, select the script you wish to run.
     • Post-Migration SQL Script: Default is No, select the script you wish to run.
   Click Review.
6. The Review & Submit page, allows you to review all information before proceeding to migrate and can run tests to ensure a proper migration. We recommend you run the Cloud Pre-Migration Advisor Tool (CPAT) by clicking Check Migration Readiness under Source. This will open a new window where CPAT will run and analyze your databases for any migration blockers. When complete, the CPAT report will show:
   • Failed: Errors that will cause a fatal error resulting in an unsuccessful migration. Fix these issues before continuing with the migration.
   • Action Required: Issues that will most likely cause an unsuccessful migration. Fix these issues before continuing with the migration.
   • Review Required: The migration may succeed or partly succeed, however not everything may work or be exactly like at the source database causing post migration cleanup work. It is recommended to also fix these issues before migrating
   • Review Suggested: Migration will succeed and applications will likely see no functional difference but Database Administrators need to evaluate each for unforeseen issues.
   • Passed: CPAT is analysis indicates that migration will be successful with no difference in behavior.

   Click Validate to validate the inputs to your migration activity. A pop up, where the pre-check runs will appear.

   Once all issues presented by Analyze Source and Validation are resolved, click Submit to migrate.

7. A pop up will require you to confirm that you have done the source analysis and when to start the migration Immediately or Later (requires a date and time when the migration will start).

   Click Submit.

1. Click on Enterprise from the main menu bar, select Migration and Consolidation then Database Migration Workbench, this loads the Database Migration screen. Select Data Pump under Migration Method.

   Click Create Migration Activity.

2. Enter a migration name under Name Activity. Under Migrate select Full Database.
   1. Select Source Database, click on the bar and select a database or search for a database.

      Click on the Source Database to be migrated.

   2. Select Destination Database, click on the bar and select a database or search for a database.

      Note:

      When selecting any non ADB migration you have an option to create a new PDB in the drop down menu. A dialog appears for you to enter required information for a new PDB.

      Click on the Destination Database that will receive the migration or enter the name for the new PDB to be created.

   Review the summary of both Source and Destination databases, then click Continue.
3. Upload Migration Tools: (Optional) Enterprise Manager automatically downloads the latest version of the tools, however if they are not available from the Software Library for your operating system you will need to upload them, click on Upload Migration Tools. For more information see Upload Migration Tools.
   • Select Upload Instant Client to upload Instance Client files to the Software Library. This is only needed for ADB migrations only.
   • Select Cloud Pre-migration Advisor Tool (CPAT) to upload the CPAT files to the Software Library. For Oracle Enterprise Manager 13 Release 5 Update 3 (13.5.0.3) and below CPAT is not available, use Schema Advisor.

   Select whether to upload the ZIP files from a local or agent machine, click on Upload and Continue.

4. The Add Details page shows a summary of the information entered:
   • Source: Ensure the information is correct, select the Agent Host Credentials and Database Credentials (Preferred or Named). When selecting Named credentials select the credential from the drop down menu.

     Note:

     Oracle Enterprise Manager's Migration Workbench now supports authentication using Database Kerberos Credentials and Database Kerberos Keytab Credentials with Data Pump migrations. Microsoft Active Directory users can be exclusively mapped to a database account and authenticated with a Kerberos password or a Keytab file without password and human interaction. If these are configured they will appear from the credential drop down menu.
   • Destination: Ensure the information is correct and select the Database Credentials and Monitoring Agent Host Credentials (Preferred or Named). When selecting Named credentials select the credential from the drop down menu. If required you can specify the Service Name, a default is loaded if not.

     Enter the Wallet Password for TDE enabled databases.

   • Action:

     Note:

     Do not use SYSDBA as the named credentials for Data Pump Export and Import. SYSDBA should only be used at the request of Oracle technical support.
     • Select Recompile Invalid Objects After Migration to allow Migration Workbench to recompile all invalid objects within schema once a migration successfully completes. This option is unchecked by default
     • Under Source Data Pump Directory

       For On Premise to Autonomous Database: Enter and confirm the Encryption Password, enter the Cloud Storage URL, Bucket Name and Credentials.

       For On Premise to non Autonomous Database: Enter and confirm the Encryption Password. Cloud Storage URL and Bucket Name are not needed, the process does not stage the dump files to cloud storage.

     • Under Database OCI Auth Credential the default cloud credential will be shown and preselected, you can select a different credential from the list if required. This field is for ADB migrations only.
     • Enter and confirm the Encryption Password if required.
   Click Next.
5. In the Customize page, set the following:

   Note:

   • In schema based migrations, a combo box will appear above Export Options, select the schema to be migrated. The process will honor the sequence in which the schema are input in case there is a schema dependency.
   • Select the Question mark next to the Export or Import option for more details.
   • Export Options:
     • EXCLUDE: Select which tables are to be excluded and not migrated.
     • ENCRYPTION: Password to encrypt/decrypt datapump dump files.
     • ENCRYPTION ALGORITHM: Specifies which cryptographic algorithm should be used to perform the encryption (AES128, AES192, AES256)
     • CONTENT: Enables you to determine whether the migration should export DATA only, METADATA only or both. It is recommended to first perform a METADATA only migration as a test before performing a DATA migration.
     • PARALLEL: Specifies the maximum number of processes of active execution operating on behalf of the export job.
   • Import Options:
     • TABLE EXISTS ACTION: Action to be taken if the table exists at the destination database (skip or replace).
     • DATA_OPTIONS: This parameter designates how certain types of data should be handled during import operations.
     • PARALLEL: Specifies the maximum number of processes of active execution operating on behalf of the import job.
     • REMAP SCHEMA: Loads all objects from the source schema into a target schema.
     • REMAP TABLESPACE: Remaps all objects selected for import with persistent data in the source tablespace to be created in the target tablespace.
     • TRANSFORM: Enables you to alter object creation DDL for objects being imported.
   • Upload Options: Select with the radio buttons whether a Monitoring Agent from the Source Database or a Different Agent will be used. If you select Different Agent enter the Agent, Host Credential and Stage Directory where it is located.
   • Select Compare Performance After Migration to configure and allow performance and comparison analytics after migration using SQL Performance Analyzer (SPA).

     Note:

     When running SPA make sure to export your SQL Tuning set schema from where the SQL Workload is captured. It is needed to properly stage the tuning set. Failure to do so will generate an error while performing validations.

     SPA is not available for Metadata only Data pump migrations.

   • Custom Scripts: Enter any custom Pre or Post scripts you may require for the migration. These scripts must be uploaded to the Software Library beforehand.
     • Script Location: Location of the Pre/Post scripts within the Software Library.
     • Pre-Migration Script: Default is No, select the script you wish to run.
     • Post-Migration Script: Default is No, select the script you wish to run.
     • Post-Migration SQL Script: Default is No, select the script you wish to run.
   Click Review.
6. The Review & Submit page, allows you to review all information before proceeding to migrate and can run tests to ensure a proper migration. We recommend you run the Cloud Pre-Migration Advisor Tool (CPAT) by clicking Check Migration Readiness under Source. This will open a new window where CPAT will run and analyze your databases for any migration blockers. When complete the CPAT report will show:
   • Failed: Errors that will cause a fatal error resulting in an unsuccessful migration. Fix these issues before continuing with the migration.
   • Action Required: Issues that will most likely cause an unsuccessful migration. Fix these issues before continuing with the migration.
   • Review Required: The migration may succeed or partly succeed, however not everything may work or be exactly like at the source database causing post migration cleanup work. It is recommended to also fix these issues before migrating
   • Informational: Migration will succeed and applications will likely see no functional difference but Database Administrators need to evaluate each for unforseen issues.
   • Passed: CPAT is analysis indicates that migration will be successful with no difference in behavior.

   Note:

   Cloud Pre-Migration Advisor Tool (CPAT) is available on Oracle Enterprise Manager 13 Release 5 Update 4 (13.5.0.4) and onward. If you are using an earlier version Schema Advisor needs to be used instead.

   Validate your migration inputs, click the Validate button. A pop up, where the pre-check runs will appear.

   Once all issues presented by Check Migration Readiness and Validation are resolved, click Submit to migrate.

7. A pop up will require you to confirm that you have done the Check Migration Readiness and when to start the migration Immediately or Later (requires a date and time when the migration will start).

   Click Submit.

Creating the Initial Backup

1. Click on Enterprise from the main menu bar, select Migration and Consolidation then Database Migration Workbench, this loads the Database Migration screen. Select Transportable Tablespace under Migration Method.

   Click Create Migration Activity.

2. Enter a migration name under Name Activity. Under Migrate select Full Database.
   1. Select Source Database, click on the bar and select a database or search for a database.

      Click on the Source Database to be migrated.

   2. Select Destination Database, click on the bar and select a database or search for a database.

      Note:

      When selecting any non CDB migration you have an option to create a new PDB in the drop down menu. A dialog appears for you to enter required information for a new PDB.

      Click on the Destination Database that will receive the migration.

   Once selected, you will see a summary of both Source and Destination databases. Click Continue.
3. The Add Details page shows a summary of the information entered:
   • Source: Ensure the information is correct, select the Agent host credentials and database credentials (Preferred or Named).

     Starting with Oracle Enterprise Manager 13.5 Release Update 12 (13.5.0.12) PDB administrator can be used as a named credential for a new PDB.

     For Transportable Tablespace migration use SYSDBA for the database credential, and use the Oracle Home Owner for the host credential.

     Enter the Wallet Password for TDE enabled databases.

   • Destination: Ensure the information is correct, select the Agent host credentials and database credentials (Preferred or Named).

     For Transportable Tablespace migration use SYSDBA for the database credential, and use the Oracle Home Owner for the host credential.

     Enter the Wallet Password for TDE enabled databases.

   • Action:
     • Select Compare Performance After Migration to run SQL Tuning Set (STS) after migration.
     • Enter the Source Working Directory, use the default or a directory of your choice.
     • Enter the Destination Working Directory, use the default or a directory of your choice.
     • Enter the Destination Storage Directory, supported storage is Filesystem and Oracle Automatic Storage Management (ASM).
     • Enter and confirm the Encryption Password for the metadata dumps.
   Click Next.
4. In the Customize page, set the following:
   • Migration Details:
     1. Select the Tablespaces to be Migrated or select All Tablespaces to migrate the entire set.
     2. Under Migration Phase select Create Backup.
   • Compare Performance After Migration: Select whether to use a new SQL Tuning Set (STS) or use an existing and set for how many days STS will run.
   • Custom Scripts: Enter any custom Pre or Post scripts you may require for the migration. These scripts must be uploaded to the Software Library beforehand.
     • Script Location: Location of the Pre/Post scripts within the Software Library.
     • Pre-Migration Script: Default is No, select the script you wish to run.
     • Post-Migration Script: Default is No, select the script you wish to run.
     • Post-Migration SQL Script: Default is No, select the script you wish to run.
   Click Review.
5. The Review & Submit page, allows you to review all information before proceeding to migrate, can run validation tests, and presents a report to ensure a proper migration.

   Starting with Oracle Enterprise Manager 13.5 Release Update 12 (13.5.0.12) you can perform a pre-migration analysis before starting a TTS migration. To analyze your migration activity inputs and view the report, click the Check Migration Readiness button.

   The Pre-Migration Report shows the following information:

   • The Summary section shows the Status for the analysis and Recommendation. For further details you can click on Database Detail and Analyzed Tablespaces.
   • The Results Breakdown by Severity shows a bar graph with the number of issues found grouped by severity. These are presented left to right from most serious to non-issue, these are:
     • Failed: The source and destination databases selected are not compatible or suitable for migration and need to be changed or the particular validation could not be completed due to internal errors.
     • Action Required: Validation failed, review and take action to resolve the issue. The migration will fail if the issue is not corrected before submission.
     • Review Required: Warning message, review and if necessary take action to correct. Migration may be impacted.
     • Review Suggested: Informational message, read and review.
     • Passed: Validation succeeded, you can proceed with the migration.
   • The lower section shows the Result Detail, to view in detail issues from a specific severity field click on the arrow to expand each field. To view the specific details for an issue, click the arrow to expand the issue details.

   Once all issues presented by the Pre-migration Report are resolved, click Submit to migrate.

6. A pop up will require you to confirm when to start the migration Immediately or Later (requires a date and time when the migration will start).

   Click Submit.

Complete a Multiphase Transportable Tablespace Migration

After submitting a Create Backup migration you can perform an incremental backup or complete the multiphase migration.

1. Once the backup completes, click on Enterprise from the main menu bar, select Migration and Consolidation then Database Migration Workbench, this loads the Database Migration screen.
2. In the Migration Activity page, look for a red exclamation icon and Status as Awaiting User Action. Go to the action menu to the left of the Migration Activity with pending action and select Complete Migration. A pop up will require you to confirm whether to:
   • Update Backup: Takes an incremental backup.

     Note:

     If the database has undergone significant updates since the initial backup, it is recommended you choose this option. This will take an incremental backup of the database without incurring in downtime.
   • Complete Migration: Performs final backup and complete migration. In this step, an incremental backup is taken as well as an export/import of metadata into the destination database. It is recommended that the finals step be triggered during a scheduled maintenance window since a Complete Migration sets the tablespace in Read Only mode.

     Note:

     Complete Migration sets the tablespace in Read Only mode during the export and import of data.
3. In the Migration Activities page, expand the left hand arrow to view the additional incremental backups performed and their status.
   • Incremental backups will be labeled as: Incremental Database Migration WD MM DD YYYY HH:MM:SS UTC.
   • Complete Migrations will be labeled as: Final Database Migration WD MM DD YYYY HH:MM:SS UTC
4. Repeat steps 2 and 3 for further incremental Update Backups and to Complete Migration.

Perform a full migration operation using Data Pump

/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
    "action": "MIGRATE",
    "type": "DATAPUMP"
    "proxy":{  --> Required if you have a proxy connection setup
        "host":"<proxy-host>",
        "port":"<proxy-port>"
    },

    "source":[{
        "databaseInfo":{
                "targetName":"<db-pdb-target-name>",
                "targetType":"<db-pdb-target-type>",
                "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
                "hostCredName":"<host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
             },

        "export":{
            "args":{
                    "LOGTIME":"ALL",
                    "METRICS":"YES",
                    "COMPRESSION":"ALL",
                    "COMPRESSION_ALGORITHM":"MEDIUM",
                    "KEEP_MASTER":"YES",
                    "PARALLEL":"1",
                    "directory":"<dump directory name>",
                    "EXCLUDE":"index,cluster,indextype,materialized_view,materialized_view_log,materialized_zonemap,db_link",
                    "ENCRYPTION":"ALL",
                    "ENCRYPTION_PASSWORD":"<Encryption Password>",
                    "ENCRYPTION_ALGORITHM":"AES128"
            }
        }
    }],

    "storage":{
        "type":"OBJECTSTORE"
        "useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to upload objects to OCI Object store
        "objectstore":{ 
            "credName":".."
            "baseUrl":"..",          
            "bucketName":".."
        },
  },

    "destination":[{
		"useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to connect to ADB
        "databaseInfo":{
             "targetName":"<adb-target-name>",
             "targetType":"<adb-target-type>",
             "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
             "hostCredName":"<adb monitoring host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
             "tdeWalletPassword": "<password>", --> TDE wallet password is required when a new PDB is created at the
      destination
        },

        import": {
        "args": {
          "TABLE_EXISTS_ACTION": "SKIP",
          "PARALLEL": "6",
          "TRANSFORM": "SEGMENT_ATTRIBUTES:N,DWCS_CVT_IOTS:Y,CONSTRAINT_USE_DEFAULT_INDEX:Y",
          "REMAP_TABLESPACE" : "<source_tablespace:target_tablespace> [, <source_tablespace:target_tablespace>, ...]"
          "NOLOGFILE": "YES",
          "DIRECTORY": "DATA_PUMP_DIR"
        },
        "dbOciAuthCred": "<cloud-cred-name:cloud-cred-owner>"
      },
      "tnsName": "<adb-service-name>",
      "recomplieInvalidObjects": <true|false>, -->After migration recompiles all invalid objects within the migrated schemas
     }],
   "analyzePerformance": -->optional
    {
        "useSPA": true/false,
        "createSTS": true/false,
        “usePreferredSTS”:  true/false -->optional
        “stsName”: “stsname01” -->optional
        “stsOwner”: “stsOwnedSchema” -->optional
        "stsOwner": "EXPUSER" -->optional
        "baselineDurationDays": 7 -->optional, set duration for SPA to analyze
    }
}

{
    "statusCode": 200,
    "status": "SUCCESS",
    "message": "....",
    "submissionName": ".....",
    "submissionBy": "SYSMAN",
    "submissionId": "<Unique Submission ID>",
    "executionId": "<Unique Execution ID>",
    "uiActivityUrl": "/em/faces/core-jobs-procedureExecutionTracking?executionGUID=<Submission ID>",
    "restActivityUrl": "/em/websvcs/restful/db/migration/activities/<Submission ID>"
}

Perform a complete Migration Operation using Data Pump

/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
    "action": "MIGRATE",
    "options": "SPA",
    "type": "SCHEMA"
    "proxy":{  --> Required if you have a proxy connection setup
        "host":"<proxy-host>",
        "port":"<proxy-port>"
    },

    "source":[{
        "databaseInfo":{
                "targetName":"<db-pdb-target-name>",
                "targetType":"<db-pdb-target-type>",
                "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
                "hostCredName":"<host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
        },

        "export":{
            "args":{
                    "LOGTIME":"ALL",
                    "METRICS":"YES",
                    "COMPRESSION":"ALL",
                    "COMPRESSION_ALGORITHM":"MEDIUM",
                    "KEEP_MASTER":"YES",
                    "PARALLEL":"1",
                    "directory":"<dump directory name>",
                    "EXCLUDE":"index,cluster,indextype,materialized_view,materialized_view_log,materialized_zonemap,db_link",
                    "ENCRYPTION":"ALL",
                    "ENCRYPTION_PASSWORD":"<Encryption Password>",
                    "ENCRYPTION_ALGORITHM":"AES128"
            }
        }
    }],

    "storage":{
        "type":"OBJECTSTORE"
        "useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to upload objects to OCI Object store
        "objectstore":{ 
            "credName":".."
            "baseUrl":"..",          
            "bucketName":".."
        },
  },

    "destination":[{
		"useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to connect to ADB
        "databaseInfo":{
             "targetName":"<adb-target-name>",
             "targetType":"<adb-target-type>",
             "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
             "hostCredName":"<adb monitoring host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
             "tdeWalletPassword": "<password>", --> TDE wallet password is required when a new PDB is created at the
      destination
        },

        import": {
        "args": {
          "TABLE_EXISTS_ACTION": "SKIP",
          "PARALLEL": "6",
          "TRANSFORM": "SEGMENT_ATTRIBUTES:N,DWCS_CVT_IOTS:Y,CONSTRAINT_USE_DEFAULT_INDEX:Y",
          "REMAP_TABLESPACE" : "<source_tablespace:target_tablespace> [, <source_tablespace:target_tablespace>, ...]"
          "NOLOGFILE": "YES",
          "DIRECTORY": "DATA_PUMP_DIR"
        },
        "dbOciAuthCred": "<cloud-cred-name:cloud-cred-owner>"
      },
      "tnsName": "<adb-service-name>",
      "recomplieInvalidObjects": <true|false>, -->After migration recompiles all invalid objects within the migrated schemas
     }],
   "analyzePerformance": -->optional
    {
        "useSPA": true/false,
        "createSTS": true/false,
        “usePreferredSTS”:  true/false -->optional
        “stsName”: “stsname01” -->optional
        “stsOwner”: “stsOwnedSchema” -->optional
        "stsOwner": "EXPUSER" -->optional
        "baselineDurationDays": 7 -->optional, set duration for SPA to analyze
    }
}

{
    "statusCode": 200,
    "status": "SUCCESS",
    "message": "....",
    "submissionName": ".....",
    "submissionBy": "SYSMAN",
    "submissionId": "<Unique Submission ID>",
    "executionId": "<Unique Execution ID>",
    "uiActivityUrl": "/em/faces/core-jobs-procedureExecutionTracking?executionGUID=<Submission ID>",
    "restActivityUrl": "/em/websvcs/restful/db/migration/activities/<Submission ID>"
}

Validate a Transportable Tablespace Migration

https://hostname:port/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
    "action": "VALIDATE",
    "type": "ONLINE_TTS",

    "source":[{
        "databaseInfo":{
            "targetName":"source target name",
            "targetType":"oracle_database",
            "dbCredName" : "namedcred:owner",
            "hostCredName" : "sourcehostcred:owner"
            "tdeWalletPassword": "<password>"
        },
       "stageDir":"directory location in source host",
       "tableSpaceList":"<comma separated or empty>"
    }],
    "encryptionPassword": "<encryption password>",
    "destination":[{
        "databaseInfo":{
             "targetName" : "destination target name",
             "targetType" : "oracle_database",
             "dbCredName" : "namedcred:owner",
             "hostCredName" : "destinationhostcred:owner",
             "tdeWalletPassword": "<password>"
             "newPdbInfo":{
                 "name":"new pdb name",
                 "adminUser":"new pdb admin username",
                 "adminPassword":"new padb admin username password"
              }
        },
        "stageDir":"directory location in destination host"
    }],
    "storage":{
        "type":"FILESYSTEM or ASM",
        "storageDir":"directory location in destination host",
        "asmCredName":"asmCred:owner"
    },
    "analyzePerformance":{
        "useSPA": false
    }  
    "customScripts": {                       
        "preMigrationScriptUrn": "<SWLIB URN>,
        "postMigrationScriptUrn": "<SWLIB URN>",
        "postMigrationSqlScriptUrn": "<SWLIB URN>"               
    }
}

{
"statusCode": 200,
"status": "SUCCESS",
"message": "Successfully submitted Validate Database Migration procedure.","submissionName": "Validate Database Migration Mon Jul 26 2021 09:22:00 UTC",
"submissionBy": "SYSMAN",
"submissionId": "C80442152B282C78E05342104B64A611",
"executionId": "C80442152B2B2C78E05342104B64A611",
"uiActivityUrl": "/em/faces/core-jobs-procedureExecutionTracking?executionGUID=C80442152B2B2C78E05342104B64A611",
"restActivityUrl": "/em/websvcs/restful/db/migration/activities/C80442152B2B2C78E05342104B64A611"
}

Transportable Tablespace Validation Results

To review results of a Transportable Tablespace Migration Validation run the following command:

https://hostname:port/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
"action": "VALIDATION_RESULTS",
"executionId": "<executionId>"
}

"status": "SUCCESS",
"description": " Database is not standby(which is valid),Database is valid container database,Database is in archive mode (which is valid),Database has primary role (which is valid)",
"name": "Destination database status validation"
},
{
"id": "DESTINATION_WORKING_DIRECTORY_VALIDATION",
"status": "SUCCESS",
"description": " Working directory is validated successfully",
"name": "Destination working directory validation"
},
{
"id": "DESTINATION_DISK_SPACE_VALIDATION",
"status": "SUCCESS",
"description": " \n \tINFORMATION : /scratch/ has enough space. Required space is 7020 MB , available space is 199805 MB.",
"name": "Destination target disk space validation"
},
{
"id": "DESTINATION_TARGET_PRIVILEGES_VALIDATION",
"status": "SUCCESS",
"description": " User has VIEW_TARGET privilege,User has CONNECT_TARGET privilege,User has CONFIGURE_TARGET privilege,User has GET_CREDENTIAL privilege for oracle_database,User has PERFORM_OPERATION privilege,User has GET_CREDENTIAL privilege for host,User has ORACLE_HOME_OWNER privilege",
"name": "Destination target privilege validation"
},
{
"id": "SOURCE_DATABASE_ENCRYPTION_VALIDATION",
"status": "SUCCESS",
"description": " Database is not encrypted (which is valid)",
"name": "Source database encryption validation"
},
{
"id": "DESTINATION_DATABASE_ENCRYPTION_VALIDATION",
"status": "SUCCESS",
"description": " Database is not encrypted (which is valid)",
"name": "Destination database encryption validation"
},
{
"id": "COMPATIBILITY_VALIDATION",
"status": "SUCCESS",
"description": " Source & Destination database are compatible",
"name": "Compatibility validation"
},
{
"id": "PDB_VALIDATION",
"status": "SUCCESS",
"description": " PDB name is valid",
"name": "PDB validation"
},
{
"id": "DESTINATION_SPA_VALIDATION",
"status": "SUCCESS",
"description": " Database user has all the required privileges(s) for analysing performance using SPA",
"name": "Destination database SPA validation"
},
{
"id": "STORAGE_VALIDATION",
"status": "SUCCESS",
"description": " Storage validation successfull",
"name": "Storage validation"
}
],
"totalValidation": 20,
"successValidation": 20,
"validationPerformed": 20,
"skippedValidation": 0,
"failedValidation": 0,
"ignorableValidation": 0,
"warningValidation": 0,
"status": "COMPLETED"
}

Perform a Transportable Tablespace Migration

Starting with Enterprise Manager 13 Release 5 Update 5 (13.5.0.5) you can now perform tablespace migrations using Migration Workbench.

https://hostname:port/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{    
    "action": "MIGRATE",
    "type": "ONLINE_TTS",
    "source":[{
        "databaseInfo":{
            "targetName":"<source target name>",
            "targetType":"<oracle_database>",
            "dbCredName" : "<namedcred>:<owner>",
            "hostCredName" : "<sourcehostcred>:<owner>"
            "tdeWalletPassword": "<password>"
        },
       "stageDir":"<directory location in source host>",
       "tableSpaceList":"<comma separated or empty>"
    }],
    "encryptionPassword": "<password>",
    "destination":[{
        "databaseInfo":{
             "targetName" : "<destination target name>",
             "targetType" : "oracle_database",
             "dbCredName" : "<namedcred>:<owner>",
             "hostCredName" : "<destinationhostcred>:<owner>",
             "tdeWalletPassword": "<password>"
             "newPdbInfo":{
                 "name":"new_pdb_name",
                 "adminUser":"new_pdb_admin_username",
                 "adminPassword":"<new pdb admin password>"
              }
        },
        "stageDir":"<directory location in destination host>"
    }],
    "storage":{
        "type":"<FILESYSTEM or ASM>",
        "storageDir":"<directory location in destination host>",
        "asmCredName":"asmCred:owner"
    },
    "analyzePerformance":{

            "useSPA": false
    }  
    "customScripts": {                       
        "preMigrationScriptUrn": "<SWLIB URN>,
        "postMigrationScriptUrn": "<SWLIB URN>",
        "postMigrationSqlScriptUrn": "<SWLIB URN>"               
    }
}

{
  "statusCode": 200,
  "status": "SUCCESS",
  "message": "Successfully submitted Database Migration procedure.",
  "submissionName": "Database Migration Fri Jul 09 2021 07:42:07 UTC",
  "submissionBy": "TESTSUPERADMIN",
  "submissionId": "C6AC9AC151535A3C10F4B6433A0",
  "executionId": "C6AC9AC151565A3C10F4B6433A0",
  "uiActivityUrl": "/em/faces/core-jobs-procedureExecutionTracking?executionGUID=C6AC9AC15156053C10F4B6433A0",
  "restActivityUrl": "/em/websvcs/restful/db/migration/activities/C6AC9AC151565A3F4B6433A0"
}

TTS Incremental Backup

https://hostname:port/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
  "action": "INCREMENTAL_ROLLFORWARD",
  "executionId": "<Execution Id>"
}

{
    "statusCode": 200,
    "status": "SUCCESS",
    "message": "Successfully submitted Database Migration procedure.",
    "submissionName": "Incremental Database Migration Wed Oct 27 2021 10:59:33 UTC",
    "submissionBy": "SYSMAN",
    "submissionId": "CF5476B1A2B90BCEE05324124B641F00",
    "executionId": "CF5476B1A2BD0BCEE05324124B641F00",
    "restActivityUrl": "/em/websvcs/restful/db/migration/activities/CF5476B1A2BD0BCEE05324124B641F00",
    "uiActivityUrl": "/em/faces/core-jobs-procedureExecutionTracking?executionGUID=CF5476B1A2BD0BCEE05324124B641F00"
}

Complete a Transportable Tablespace Migration

After you have performed one or several incremental backups use this REST API code sample to finalize the migration. In this step, an incremental backup is taken as well as an export/import of metadata into the destination database. It is recommended that the finals step be triggered during a scheduled maintenance window since a Complete Migration sets the tablespace in Read Only mode.

https://hostname:port/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
"action": "FINAL_CUTOVER",
"executionId": "<Execution Id>"
}

{
    "statusCode": 200,
    "status": "SUCCESS",
    "message": "Successfully submitted Database Migration procedure.",
    "submissionName": "Final Database Migration Wed Oct 27 2021 11:10:04 UTC",
    "submissionBy": "SYSMAN",
    "submissionId": "CF5476B1A2DC0BCEE05324124B641F00",
    "executionId": "CF5476B1A2E00BCEE05324124B641F00",
    "restActivityUrl": "/em/websvcs/restful/db/migration/activities/CF5476B1A2E00BCEE05324124B641F00",
    "uiActivityUrl": "/em/faces/core-jobs-procedureExecutionTracking?executionGUID=CF5476B1A2E00BCEE05324124B641F00"
}

Transportable Tablespace Validation Results

To review results of a Transportable Tablespace Migration Validation run the following command:

https://hostname:port/em/websvcs/restful/db/migration

Content-Type: application/json
Authorization: Basic

{
"action": "VALIDATION_RESULTS",
"executionId": "<executionId>"
}

"status": "SUCCESS",
"description": " Database is not standby(which is valid),Database is valid container database,Database is in archive mode (which is valid),Database has primary role (which is valid)",
"name": "Destination database status validation"
},
{
"id": "DESTINATION_WORKING_DIRECTORY_VALIDATION",
"status": "SUCCESS",
"description": " Working directory is validated successfully",
"name": "Destination working directory validation"
},
{
"id": "DESTINATION_DISK_SPACE_VALIDATION",
"status": "SUCCESS",
"description": " \n \tINFORMATION : /scratch/ has enough space. Required space is 7020 MB , available space is 199805 MB.",
"name": "Destination target disk space validation"
},
{
"id": "DESTINATION_TARGET_PRIVILEGES_VALIDATION",
"status": "SUCCESS",
"description": " User has VIEW_TARGET privilege,User has CONNECT_TARGET privilege,User has CONFIGURE_TARGET privilege,User has GET_CREDENTIAL privilege for oracle_database,User has PERFORM_OPERATION privilege,User has GET_CREDENTIAL privilege for host,User has ORACLE_HOME_OWNER privilege",
"name": "Destination target privilege validation"
},
{
"id": "SOURCE_DATABASE_ENCRYPTION_VALIDATION",
"status": "SUCCESS",
"description": " Database is not encrypted (which is valid)",
"name": "Source database encryption validation"
},
{
"id": "DESTINATION_DATABASE_ENCRYPTION_VALIDATION",
"status": "SUCCESS",
"description": " Database is not encrypted (which is valid)",
"name": "Destination database encryption validation"
},
{
"id": "COMPATIBILITY_VALIDATION",
"status": "SUCCESS",
"description": " Source & Destination database are compatible",
"name": "Compatibility validation"
},
{
"id": "PDB_VALIDATION",
"status": "SUCCESS",
"description": " PDB name is valid",
"name": "PDB validation"
},
{
"id": "DESTINATION_SPA_VALIDATION",
"status": "SUCCESS",
"description": " Database user has all the required privileges(s) for analysing performance using SPA",
"name": "Destination database SPA validation"
},
{
"id": "STORAGE_VALIDATION",
"status": "SUCCESS",
"description": " Storage validation successfull",
"name": "Storage validation"
}
],
"totalValidation": 20,
"successValidation": 20,
"validationPerformed": 20,
"skippedValidation": 0,
"failedValidation": 0,
"ignorableValidation": 0,
"warningValidation": 0,
"status": "COMPLETED"
}

Full Database Data Pump Migration Using EM CLI

emcli migrate_db 
-file="/home/migrations/DB_Migration.JSON"

{
    "action": "MIGRATE",
    "options": "SPA",
    "type": "DATAPUMP"
    "proxy":{  --> Required if you have a proxy connection setup
        "host":"<proxy-host>",
        "port":"<proxy-port>"
    },

    "source":[{
        "databaseInfo":{
                "targetName":"<db-pdb-target-name>",
                "targetType":"<db-pdb-target-type>",
                "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
                "hostCredName":"<host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
        },

        "export":{
            "args":{
                    "LOGTIME":"ALL",
                    "METRICS":"YES",
                    "COMPRESSION":"ALL",
                    "COMPRESSION_ALGORITHM":"MEDIUM",
                    "KEEP_MASTER":"YES",
                    "PARALLEL":"1",
                    "directory":"<dump directory name>",
                    "EXCLUDE":"index,cluster,indextype,materialized_view,materialized_view_log,materialized_zonemap,db_link",
                    "ENCRYPTION":"ALL",
                    "ENCRYPTION_PASSWORD":"<Encryption Password>",
                    "ENCRYPTION_ALGORITHM":"AES128"
            }
        }
    }],

    "storage":{
        "type":"OBJECTSTORE"
        "useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to upload objects to OCI Object store
        "objectstore":{ 
            "credName":".."
            "baseUrl":"..",          
            "bucketName":".."
        },
  },
    "destination":[{
		"useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to connect to ADB
        "databaseInfo":{
             "targetName":"<adb-target-name>",
             "targetType":"<adb-target-type>",
             "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
             "hostCredName":"<adb monitoring host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
             "tdeWalletPassword": "<password>", --> TDE wallet password is required when a new PDB is created at the
      destination
        },

        import": {
        "args": {
          "TABLE_EXISTS_ACTION": "SKIP",
          "PARALLEL": "6",
          "TRANSFORM": "SEGMENT_ATTRIBUTES:N,DWCS_CVT_IOTS:Y,CONSTRAINT_USE_DEFAULT_INDEX:Y",
          "REMAP_TABLESPACE" : "<source_tablespace:target_tablespace> [, <source_tablespace:target_tablespace>, ...]"
          "NOLOGFILE": "YES",
          "DIRECTORY": "DATA_PUMP_DIR"
        },
        "dbOciAuthCred": "<cloud-cred-name:cloud-cred-owner>"
      },
      "tnsName": "<adb-service-name>",
      "recomplieInvalidObjects": <true|false>, -->After migration recompiles all invalid objects within the migrated schemas
    }],
	
   "analyzePerformance": --optional
    {
        "useSPA": true/false,
        "createSTS": true/false,
        "usePreferredSTS”:  true/false -->optional
        "stsName": "stsname01" -->optional
        "stsOwner": "stsOwnedSchema" -->optional
        "stsOwner": "EXPUSER" -->optional
        "baselineDurationDays": 7 -->optional, set duration for SPA to analyze
    }
}

For more information on migrate_db and the accepted parameters required for migration, see: migrate_db in Oracle Enterprise Manager Command Line Interface .

Migrate Using EM CLI

emcli migrate_db 
-file="/home/migrations/DB_Migration.JSON"

{
    "action": "MIGRATE",
    "options": "SPA",
    "type": "SCHEMA"
    "proxy":{  --> Required if you have a proxy connection setup
        "host":"<proxy-host>",
        "port":"<proxy-port>"
    },

    "source":[{
        "databaseInfo":{
                "targetName":"<db-pdb-target-name>",
                "targetType":"<db-pdb-target-type>",
                "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
                "hostCredName":"<host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
        },

        "export":{
            "args":{
                    "LOGTIME":"ALL",
                    "METRICS":"YES",
                    "COMPRESSION":"ALL",
                    "COMPRESSION_ALGORITHM":"MEDIUM",
                    "KEEP_MASTER":"YES",
                    "PARALLEL":"1",
                    "directory":"<dump directory name>",
                    "EXCLUDE":"index,cluster,indextype,materialized_view,materialized_view_log,materialized_zonemap,db_link",
                    "ENCRYPTION":"ALL",
                    "ENCRYPTION_PASSWORD":"<Encryption Password>",
                    "ENCRYPTION_ALGORITHM":"AES128"
            }
        }
    }],

    "storage":{
        "type":"OBJECTSTORE"
        "useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to upload objects to OCI Object store
        "objectstore":{ 
            "credName":".."
            "baseUrl":"..",          
            "bucketName":".."
        },
  },
    "destination":[{
		"useProxy": <boolean, true/false> --> If true, the proxy from main section will be used to connect to ADB
        "databaseInfo":{
             "targetName":"<adb-target-name>",
             "targetType":"<adb-target-type>",
             "dbCredName":"<db-cred-name:em-cred-owner>", --> If not provided, preferred credentials will be used
             "hostCredName":"<adb monitoring host-cred-name:em-cred-owner>" --> If not provided, preferred credentials will be used
             "tdeWalletPassword": "<password>", --> TDE wallet password is required when a new PDB is created at the
      destination
        },

        import": {
        "args": {
          "TABLE_EXISTS_ACTION": "SKIP",
          "PARALLEL": "6",
          "TRANSFORM": "SEGMENT_ATTRIBUTES:N,DWCS_CVT_IOTS:Y,CONSTRAINT_USE_DEFAULT_INDEX:Y",
          "REMAP_TABLESPACE" : "<source_tablespace:target_tablespace> [, <source_tablespace:target_tablespace>, ...]"
          "NOLOGFILE": "YES",
          "DIRECTORY": "DATA_PUMP_DIR"
        },
        "dbOciAuthCred": "<cloud-cred-name:cloud-cred-owner>"
      },
      "tnsName": "<adb-service-name>",
      "recomplieInvalidObjects": <true|false>, -->After migration recompiles all invalid objects within the migrated schemas
    }],
	
   "analyzePerformance": --optional
    {
        "useSPA": true/false,
        "createSTS": true/false,
        "usePreferredSTS”:  true/false -->optional
        "stsName": "stsname01" -->optional
        "stsOwner": "stsOwnedSchema" -->optional
        "stsOwner": "EXPUSER" -->optional
        "baselineDurationDays": 7 -->optional, set duration for SPA to analyze
    }
}

For more information on migrate_db and the accepted parameters required for migration, see: migrate_db in Oracle Enterprise Manager Command Line Interface .

Validate a Transportable Tablespace Migration

emcli migrate_db 
-file="/home/migrations/TTS_Migration.JSON"

{
    "action": "VALIDATE",
    "type": "ONLINE_TTS",

    "source":[{
        "databaseInfo":{
            "targetName":"<source target name>",
            "targetType":"<oracle_database>",
            "dbCredName" : "<namedcred:owner>",
            "hostCredName" : "<sourcehostcred:owner>"
            "tdeWalletPassword": "<password>"
        },
       "stageDir":"<directory location in source host>",
       "tableSpaceList":"<comma separated or empty>"
    }],
    "encryptionPassword": "<password>",
    "destination":[{
        "databaseInfo":{
             "targetName" : "<destination target name>",
             "targetType" : "<oracle_database>",
             "dbCredName" : "<namedcred:owner>",
             "hostCredName" : "<destinationhostcred:owner>",
             "tdeWalletPassword": "<password>"
             "newPdbInfo":{
                 "name":"<new pdb name>",
                 "adminUser":"<new pdb admin username>",
                 "adminPassword":"<new pdb admin username password>"
              }
        },
        "stageDir":"<directory location in destination host>"
    }],
    "storage":{
        "type":"<FILESYSTEM or ASM>",
        "storageDir":"<directory location in destination host>",
        "asmCredName":"asmCred:owner"
    },
    "analyzePerformance":{

            "useSPA": false
    }
    "customScripts": {                       
        "preMigrationScriptUrn": "<SWLIB URN>,
        "postMigrationScriptUrn": "<SWLIB URN>",
        "postMigrationSqlScriptUrn": "<SWLIB URN>"               
    }  
}

View Transportable Tablespace Validation Results

emcli migrate_db 
-file="/home/migrations/TTS_Verify.JSON"

{
"action": "VALIDATION_RESULTS",
"executionId": "<executionId>"
}

Incremental Backup for a Transportable Tablespace Migration with EM CLI

emcli migrate_db 
-file="/home/migrations/TTS_Migration.JSON"

{
  "action": "INCREMENTAL_ROLLFORWARD",
  "executionId": "<Execution Id>"
}

Finalize a Transportable Tablespace Migration with EM CLI

emcli migrate_db 
-file="/home/migrations/TTS_Migration.JSON"

{
"action": "FINAL_CUTOVER",
"executionId": "<Execution Id>"
}

Transportable Tablespace Only Migration

emcli migrate_db 
-file="/home/migrations/TTS_Migration.JSON"

{
    "action": "MIGRATE",
    "type": "ONLINE_TTS",

    "source":[{
        "databaseInfo":{
            "targetName":"<source target name>",
            "targetType":"<oracle_database>",
            "dbCredName" : "<namedcred:owner>",
            "hostCredName" : "<sourcehostcred:owner>"
            "tdeWalletPassword": "<password>"  
        },
       "stageDir":"<directory location in source host>",
       "tableSpaceList":"<tablespace list comma separated"
    }],
    "encryptionPassword": "<password>",
    "destination":[{
        "databaseInfo":{
             "targetName" : "<destination target name>",
             "targetType" : "<oracle_database>",
             "dbCredName" : "<namedcred:owner>",
             "hostCredName" : "<destinationhostcred:owner>",
             "tdeWalletPassword": "<password>"  
             "newPdbInfo":{
                 "name":"<new pdb name>",
                 "adminUser":"<new pdb admin username>",
                 "adminPassword":"<new pdb admin username password>"
              }
        },
        "stageDir":"<directory location in destination host>"
    }],
    "storage":{
        "type":"<FILESYSTEM or ASM>",
        "storageDir":"<directory location in destination host>",
        "asmCredName":"asmCred:owner"
    },
    "analyzePerformance":{

            "useSPA": false
    }
    "customScripts": {                       
        "preMigrationScriptUrn": "<SWLIB URN>,
        "postMigrationScriptUrn": "<SWLIB URN>",
        "postMigrationSqlScriptUrn": "<SWLIB URN>"               
    }  
}

View Transportable Tablespace Validation Results

emcli migrate_db 
-file="/home/migrations/TTS_Verify.JSON"

{
"action": "VALIDATION_RESULTS",
"executionId": "<executionId>"
}