Support for Save as Stack feature for online Oracle migrations

The Oracle Cloud Infrastructure Database Migration service provides you an option to save the migrations as a stack. See the Creating Oracle migrations topic for more information.

See the Preparing for Application Switchover topic for more information.

Support for viewing and editing parameter files for online Oracle migrations

Support for advanced parameters for migrating your Oracle databases into OCI

Support for migrating MySQL databases to the OCI MySQL Heatwave service

Database Migration introduces a brand new REST API version with a set of APIs to manage connections and migrations for Oracle and MySQL databases. For more information see, Oracle Cloud Infrastructure Database Migration and Database Migration API.

Database Migration Events for OCI Monitoring

You now have the capability to setup rules to get notifications or perform other actions through streaming or functions service based on lifecycle state transition events for Database Migration Service Connections, Migrations, Jobs resources, or through more granular custom events such as Phase state transitions. See Database Migration Events for OCI Monitoring.

Pre-configured notifications

Customers can now create rules to get notifications based on the Database Migration Service events and metrics. This feature allows you to set up alerts quickly and conveniently and be notified of any changes in your Migrations. This includes overall Migration, Connection or Job state changes with optional conditions to achieve further granularity. See Viewing Migration Details.

Addition of a new policy template

Database Migration service has added a new policy template in the OCI Identity Policy Builder (Create Policy) section. This will help a tenant administrator to provision all the necessary policies (including the ones for the other dependent OCI services) in one go and allow the users to setup and use migrations. See Required Policies and Creating a Policy.

Support FSS as a transfer medium for Datapump export/import

Database Migration service now supports File storage service. You can now use a shared File Storage Service mount as the transfer medium between the source and the target databases.

See Creating Migrations.

This is now deployed internally by the Database Migration service.

Now you just need to select an option if you want to opt for an online migration during the migration creation.

See Creating Migrations

See OCI Database Migration

You can test the connectivity of a database connection and fix any configuration issues before running the migration. You can diagnose connectivity issues such as:

Oracle Cloud Infrastructure Database Migration service runs a network connectivity check followed by JDBC connection or socket connectivity using the database connection data that you provide.

See Testing Connectivity of a Database Connection

You can now add up to 5 NSGs to a database connection. The advantage of NSGs over Security Lists is that rules can be limited to individual resources within a subnet, whereas Security Lists will apply to all resources within a subnet.

See Viewing Connections

See Creating Migrations

During migrations, you can now exclude/ include objects in bulk. You can copy and paste text with the list of objects in a comma-separated structure.

See Selecting Objects for Migration

Provides a user-friendly explanation of the errors, a clear cause, and a possible resolution.

See Monitoring Job Status

The new performance profile simplifies the replicat performance selection. Use HIGH when you have no concurrent workload on target. Use LOW when there’s a concurrent workload on target.

See Configuring Replication Advanced Options

You now have the option to select between database block sizes to auto-create tablespace in the target database during migration in the application rather than manually perform this activity. The options are: 8K and 16K.

See Configuring Initial Load Advanced Options

Database Migration provides you with an interactive validation report with its integration with the Cloud Pre-migration Advisor Tool (CPAT), which consists of a browsable display of CPAT results with suggested actions to address issues reported by CPAT, such as excluding problematic objects.

See Cloud Pre-migration Advisor Tool Report

Database Migration provides a report of all excluded objects based on static exclusion rules as well as dynamic exclusion settings made by the user.

See the new options in Viewing Migration Details

Support for migrating an Oracle Database from Amazon Web Services (AWS) RDS to Oracle Autonomous Database using offline migration, including:

• Select an Oracle RDS source in registered database configuration
• Select an Amazon S3 as a data transfer medium
• Download CPAT reports and log files in the same way as other Oracle sources

See Migrating Databases from Amazon Web Services RDS to Oracle Autonomous Database, and the new options in Creating Registered Databases and Creating Migrations

Database Migration automatically discovers the source database tablespaces associated with user schemas that are being migrated, and automatically creates them in the target database before the Data Pump import phase.

See the new options in Configuring Optional Initial Load Advanced Options

You can now migrate to non-autonomous databases in OCI such as DBCS, Exadata Cloud Service, or Oracle Database on OCI Marketplace. The databases must be hosted on the OCI cloud. On-premise, 3rd party cloud, or Exadata Cloud at Customer databases are not supported as targets.

See Target Database Requirements

The Cloud Pre-migration Advisor Tool (CPAT) is now used to analyze source data for incompatibilities with the target database. You can review a report containing detailed issue descriptions and suggested remedies.

See Configuring Validation Options

You can now select database schemas, objects, or types to be included or excluded from your migration. Sets of objects or schemas can be defined through regular expressions.

See Selecting Objects for Migration

Errors during validation and migration jobs are now displayed in detail as part of the job phase. You can also download the Data Pump log for export and import operations for further details.

See Monitoring Job Status

The state of your migration is now displayed through a consolidated list of state names that indicate the resource's life cycle as well as functional migration states.

See Viewing Migration Details