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.
|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.
|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.
|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
|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.
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
Copyright © 2021, 2023, Oracle and/or its affiliates.