How to migrate an on-premises Oracle database to Oracle Cloud Infrastructure (OCI)

Migrating a local Oracle database to OCI requires evaluating the version, scale, license, and dependencies; 2. Choose the appropriate method: Data Pump is suitable for downtime migration of small databases, RMAN is suitable for large database backup and recovery, and GoldenGate achieves near-zero downtime synchronization; 3. Create a target environment in OCI and configure the network and permissions; 4. Verify data consistency, application connections, and failover after migration; 5. Optimize cloud performance and backup, and it is recommended to use autonomous databases to reduce operation and maintenance burden.

Migrating an on-premises Oracle database to Oracle Cloud Infrastructure (OCI) involves careful planning and execution to ensure data integrity, minimal downtime, and performance alignment with cloud capabilities. The process can be streamlined using native Oracle tools and OCI services designed for database migration.

Assess Your Current Environment

Before initiating the migration, evaluate your on-premises Oracle database setup:

• Database version and edition: Confirm compatibility with OCI-supported versions. Oracle Autonomous Database and DB Systems support most recent editions.
• Size and workload: Analyze storage requirements, peak usage patterns, and dependencies on other systems or applications.
• Licensing model: Decide whether to bring your own license (BYOL) or use pay-as-you-go licensing in OCI.
• Dependencies: Identify linked applications, custom scripts, or network configurations that may need adjustment post-migration.

Choose the Right Migration Method

OCI supports multiple migration approaches depending on your downtime tolerance and technical constraints:

• Data Pump Export/Import: Use Oracle Data Pump to export schema or full database from on-premises and import into an OCI DB System or Virtual Private Database (VPD). Suitable for smaller databases or when some downtime is acceptable.
• RMAN Backup and Restore: Perform a backup using Recovery Manager (RMAN), transfer backup files to OCI Object Storage via multipart upload, then restore to an OCI-based Oracle instance. Ideal for large databases needing consistent recovery points.
• Oracle GoldenGate: Set up real-time replication between on-premises and OCI. Enables near-zero downtime migration by synchronizing changes during cutover.
• Database Clone with Transportable Tablespaces: Move self-contained tablespaces across platforms using cross-platform transport. Efficient for selective schema migrations.

Set Up the Target Environment in OCI

Create and configure the destination database environment:

• Launch a DB System in OCI or provision an Autonomous Transaction Processing (ATP) / Autonomous Data Warehouse (ADW) instance based on workload type.
• Configure virtual cloud network (VCN), subnets, security lists, and firewall rules to allow connectivity from on-premises or application tiers.
• Ensure proper IAM policies are assigned for user access and management tasks.
• Mount block storage or increase disk size if needed for data file growth.

Execute and Validate the Migration

Run the chosen migration method and verify success:

• Initiate data transfer during a maintenance window or using continuous sync tools like GoldenGate.
• Monitor progress through logs, OCI console metrics, or Oracle Enterprise Manager.
• After cutover, validate data consistency, run test queries, and check application connectivity.
• Update connection strings, DNS entries, or tnsnames.ora files to point to the new OCI database endpoint.
• Test failover, backup schedules, and monitoring integrations in the cloud environment.

Post-migration, optimize performance using OCI autoscaling, automatic backups, and monitoring via Oracle Cloud Observability services. Keep licenses compliant and consider moving toward Autonomous Database for reduced operational overhead.

Basically, pick the right tool based on your needs—Data Pump for simplicity, RMAN for reliability, or GoldenGate for zero-downtime scenarios. With proper prep, most Oracle databases can move smoothly to OCI.

The above is the detailed content of How to migrate an on-premises Oracle database to Oracle Cloud Infrastructure (OCI). For more information, please follow other related articles on the PHP Chinese website!