*Originally published on 07/13/2023
Its is my pleasure to announce the new release of OCI Database Migration service aimed to improve the user experience.
OCI Database Migration is a fully-managed service that provides a high performing, self-service experience for migrating databases to Oracle Cloud Infrastructure (OCI). It provides logical online and offline migration for enterprise-level database migration with minimal downtime. OCI Database Migration is based on industry-leading Oracle Zero Downtime Migration engine utilizing Data Pump and GoldenGate.
The following are the new features that you can find in the service:
GoldenGate Service Integration for replication
In the previous workflow, the user manually deployed and managed a GoldenGate marketplace instance in their tenancy. Users had the responsibility to correctly size and create an OCI Marketplace instance and configure it to be used in OCI Database Migration. Now, users can save time and avoid the manual setup. The user can enable online migration using GoldenGate by simply selecting an option.
The benefits of this change:
- Speeds up the online migration setup process
- Intelligently scales GoldenGate deployments based on the migration size/load
- Optimizes resource utilization by reclaiming/recycling GoldenGate deployments when not required
- Presents customers with comprehensive cause/action information in an event of a failure
- Provides capability to interactively adjust GoldenGate parameters directly from the OCI Console
For those who specifically need to deploy a marketplace instance, the service will allow them to do so by entering their GoldenGate details as an advance option.
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:
-Incorrect IP address and/or port
-Incorrectly declaring a connection public or private
-Incorrect, expired, or locked database credentials
-Missing entries in security lists/NSGs to allow communication with DB IP/port
-Connection failures through Fastconnect, VPN, or any other network connectivity issues for your on-premises database
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.
New Overview Page
The service now has an Overview landing page containing a short description of the product and a youtube video link. It also contains a snippet for the health of the service, a dashboard with cards displaying information about migration numbers in the current compartment, and a section with documentation.
Network Security Groups (NSG) support for Database Connections with Private Endpoints.
Now up to 5 NSGs can be added to a database connection. The advantage of NSGs vs 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
This functionality makes SSH access 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 over.
-The SSH fields were moved to the advanced options, this method can still be used if this the user requires it.
-During migration creation, a new field for an SSL wallet with the required certificates was added.
Bulk include/exclude of migration objects
During migrations, the users have the option to include/ exclude objects, this was troublesome when they wanted to perform this activity for a big list of objects. Our users have requested the ability to exclude/ include objects massively. This functionality allows them to copy and paste text with the list of objects in a comma-separated structure.
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)
Users 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:
8 K
16K
For more details and links to updated documentation, see What’s New for OCI Database Migration.
Additional OCI Database Migration resources: