What’s New for Oracle Cloud Infrastructure Database Migration
As soon as new and changed features become available, Oracle Cloud Infrastructure Database Migration is upgraded in the data centers where Oracle Cloud services are hosted. You don’t need to request an upgrade to be able to use the new features—they come to you automatically.
Here’s an overview of new features and enhancements added recently to improve your Database Migration experience.
April 2024
| Feature | Description |
|---|---|
|
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. |
December 2023
| Feature | Description |
|---|---|
|
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. |
October 2023
| Feature | Description |
|---|---|
| GoldenGate Service Integration for replication |
In the previous model, you had to deploy a GoldenGate Marketplace image by performing the following steps:
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. |
August 2023
| Feature | Description |
|---|---|
| New Overview Page |
Database Migration now has an Overview landing page containing a short description of the product and a video link. It also includes:
|
| Database Connection Testing |
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. |
| Network Security Groups (NSG) support for Database Connections with Private Endpoints |
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. |
| Support migration without SSH to DB Host |
The SSH access is optional for non-ADB database connections. The new capability leverages Oracle's built-in procedure that connects to OSS over HTTPS to transfer the dumps.
|
| Bulk include/exclude of migration objects |
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. |
| Validation & Migration Errors, Cause, and Resolution |
Provides a user-friendly explanation of the errors, a clear cause, and a possible resolution. |
| Replicat performance (replication settings) |
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. |
| DB Block size (Initial load) |
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. |
March 2022
| Feature | Description |
|---|---|
| Interactive integration of Cloud Pre-migration Advisor tool (CPAT) results |
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. |
| Dynamic display of excluded objects |
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 Oracle Database on Amazon Web Services RDS as a source database |
Support for migrating an Oracle Database from Amazon Web Services (AWS) RDS to Oracle Autonomous Database using offline migration, including:
See Migrating Databases from Amazon Web Services RDS to Oracle Autonomous Database, and the new options in Creating Registered Databases and Creating Migrations |
| Auto-create tablespaces on the target database |
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 |
October 2021
| Feature | Description |
|---|---|
| Non-autonomous databases as targets |
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. |
| Graphical integration of CPAT results |
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. |
| Include or exclude database objects from migration |
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. |
| Error message display and Data Pump log download |
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. |
| Consolidation of migration states |
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. |
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Cloud What's New for Database Migration Service
F16362-09
April 2024
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customer access to and use of Oracle support services will be pursuant to the terms and conditions specified in their Oracle order for the applicable services.