Migrate to Oracle Autonomous Database Serverless
This section describes how to migrate your on-premises x86 server or Oracle Database Appliance workloads to Oracle Autonomous Database Serverless, and migrate your VMware applications to Oracle Cloud VMware Solution.
Architecture
Using Oracle Zero Downtime Migration, automate your database migration while experiencing minimal downtime when migrating your data from on-premises to the cloud.
Migrate your on-premises applications running on VMware to Oracle Cloud VMware Solution using VMware tools such as HCX and vMotion. Oracle Cloud VMware Solution gives you a fully automated implementation of a VMware software-defined data center (SDDC) within your OCI tenancy, running on OCI bare metal instances.
The following diagram illustrates this reference architecture.
x86-oda-migrate-autonomous-serverless-vmware.zip
This architecture supports the following components:
- Region
An Oracle Cloud Infrastructure region is a localized geographic area that contains one or more data centers, called availability domains. Regions are independent of other regions, and vast distances can separate them (across countries or even continents).
- Virtual cloud network (VCN) and subnet
A VCN is a customizable, software-defined network that you set up in an Oracle Cloud Infrastructure region. Like traditional data center networks, VCNs give you complete control over your network environment. A VCN can have multiple non-overlapping CIDR blocks that you can change after you create the VCN. You can segment a VCN into subnets, which can be scoped to a region or to an availability domain. Each subnet consists of a contiguous range of addresses that don't overlap with the other subnets in the VCN. You can change the size of a subnet after creation. A subnet can be public or private.
- Oracle Autonomous Database Serverless
Oracle Autonomous Database Serverless provides access to the latest autonomous database technology. With Autonomous Database you have a fully elastic database where Oracle autonomously operates all aspects of the database lifecycle from database placement to backup and updates.
- Oracle Cloud VMware Solution Software-Defined Data Center (SDDC)
Oracle and VMware have partnered to develop a VMware certified Software-Defined Data Center (SDDC) implementation for use within Oracle Cloud Infrastructure. This implementation, called the Oracle Cloud VMware Solution, uses Oracle Cloud Infrastructure to host a highly available VMware SDDC. It also allows seamless migration of all your on-premises VMware SDDC workloads to Oracle Cloud VMware Solution. Oracle Cloud VMware Solution contains the following VMware components:
- VMware vSphere ESXi
- VMware vSAN
- VMware vCenter
- VMware NSX-T
- VMware HCX (optional)
- Bare metal
An Oracle Cloud VMware Solution Software-Defined Data Center (SDDC) contains bare metal servers hosting Oracle Cloud VMware Solution. The bare metal server supports applications that require high core counts, large amounts of memory, and high bandwidth (such as Oracle Cloud VMware Solution). You can deploy Oracle Cloud VMware Solution on bare metal servers, and configure virtual machines with significant performance improvements compared to other public clouds and on-premises data centers.
- Service gateway
The service gateway provides access from a VCN to other services, such as Oracle Cloud Infrastructure Object Storage. The traffic from the VCN to the Oracle service travels over the Oracle network fabric and never traverses the internet.
- Dynamic routing gateway (DRG)
The DRG is a virtual router that provides a path for private network traffic between VCNs in the same region, between a VCN and a network outside the region, such as a VCN in another Oracle Cloud Infrastructure region, an on-premises network, or a network in another cloud provider.
- FastConnect
Oracle Cloud Infrastructure FastConnect provides an easy way to create a dedicated, private connection between your data center and Oracle Cloud Infrastructure. FastConnect provides higher-bandwidth options and a more reliable networking experience when compared with internet-based connections.
- Object storage
OCI Object Storage is used for temporary storage of database backups and exports during migration.
Before You Begin
Before you begin, check the versions of major components used in this setup, and review the product documentation for later reference.
Review Requirements
- Ensure the source database is running on an x86 server or Oracle Database Appliance Standard Edition, Enterprise Edition, version 19.18 or above.
- The target Oracle Autonomous Database Serverless database must be version 19.19.0.01 Extreme Enterprise Edition or above.
- Target databases that use up to 8 OCPUs may run Oracle Standard Edition. Databases that use more than 8 OCPUs must run Oracle Enterprise Edition Extreme Performance.
- Oracle Zero Downtime Migration must be version 21.4 or above.
- Intermediate storage must include OCI Object Storage and Oracle ZFS Storage Appliance (NAS).
Review Documentation
This solution playbook describes how to migrate your database workloads. Refer to the solution below to learn how to migrate your VMware workloads. The additional resources are helpful for context, details, and reference for your database migration.
Learn how to migrate the VMware components of your workload to Oracle Cloud VMware Solution.
Review Oracle Zero Downtime Migration resources:
- Oracle Zero Downtime Migration
- Oracle Zero Downtime Migration Video
- Install Oracle Zero Downtime Migration software
Review logical migration resources:
- "Setting Logical Migration Parameters" in Move to Oracle Cloud Using Zero Downtime Migration Guide
- Step-by-Step Guide - Logical Online Migration from On-Premises to Oracle Autonomous Database
Review Oracle Database resources:
About Required Products and Roles
This solution requires the following products:
- Oracle Cloud Infrastructure Identity and Access Management
- OCI Compute
- OCI Object Storage
- Oracle Zero Downtime Migration
- x86 server or Oracle Database Appliance
- Oracle Autonomous Database Serverless
These are the roles needed for each product.
Product Name: Role | Required to... |
---|---|
Oracle Cloud Infrastructure Identity
and Access Management: OCI_user |
|
OCI Compute: admin |
Create OCI Compute instance to run Oracle Zero Downtime Migration software |
OCI Object Storage: Storage Admin |
Create OCI Object Storage buckets to upload exported data |
Oracle Zero Downtime Migration: opc |
Create zdmuser to install and run Oracle Zero Downtime Migration software
|
Oracle Zero Downtime Migration: zdmuser |
|
x86 server or Oracle Database Appliance: root/sudoer user |
|
x86 server or Oracle Database Appliance Database: sys/system |
Run Data Pump to export database |
Oracle Autonomous Database Serverless: Database Admin |
Create target database |
Oracle Autonomous Database Serverless: ADMIN |
Run Data Pump to import database |
See Oracle Products, Solutions, and Services to get what you need.
Considerations for Migration
Before you begin your migration, review these assumptions and considerations.
- Logical migration is the only supported method to migrate databases from x86 server or Oracle Database Appliance to Oracle Autonomous Database Serverless.
- The following steps in this playbook describe how to migrate using an offline logical migration, see the Review Documentation section for information on how to migrate using an online logical migration. During logical online migration, Oracle Zero Downtime Migration configures Oracle GoldenGate for migrations between the source and target databases to ensure the databases are always online during migration.
- During logical migration, pluggable databases (PDBs) and/or schemas are migrated. Non-container databases are migrated to Oracle Autonomous Database Serverless.
- A shared file system is required for logical migrations. During logical migration, Oracle Zero Downtime Migration will not export the data directly to OCI Object Storage. On the source database, Oracle Zero Downtime Migration exports data to a shared file system (either network file system or Oracle Advanced Cluster File System). Exported data is then uploaded to OCI Object Storage. Oracle Zero Downtime Migration then moves the data dumps from OCI Object Storage to OCI File Storage. Finally, Oracle Autonomous Database Serverless can import the data directly from OCI Object Storage.
- x86 server or Oracle Database Appliance on-premises can run both single-instance and RAC databases. Oracle Autonomous Database Serverless runs RAC databases. During database migration, Oracle Zero Downtime Migration converts single-instance to RAC databases when required.
- Oracle Transparent Data Encryption is optional for on-premise databases running on x86 server or Oracle Database Appliance. When migrating databases to Oracle Autonomous Database Serverless, the target database will always be encrypted.
- The source x86 server or Oracle Database Appliance database and target databases must run the same timezone files. For instructions, refer to "Manage Time Zone File Version on Autonomous Database" in the Review Documentation section. For instructions on how to update timezone files in Oracle Autonomous Database Serverless, refer to "Manage Time Zone File Version on Autonomous Database" in the Review Documentation section.
- The steps in this playbook assume there is direct network connectivity between the data center where the x86 server or Oracle Database Appliance is installed, and the OCI Virtual Cloud Network (VCN) where the Oracle Zero Downtime Migration virtual machine is configured (via FastConnect or IPSec VPN as shown in the architecture diagram). Connectivity between the VCN and the target database via a service gateway is also required.
- Oracle Autonomous Database Serverless supports only one standard tablespace called
DATA
. All tables must be placed on this tablespace. If the source database uses custom tablespaces, they must be remapped to theDATA
tablespace during migration.