X

Database Migration to Oracle Cloud Infrastructure: Planning for Database Backup Transfers to Object Storage

Rohit Chandok
Architect, OCI Product Management

 


This post is part of the “Database Migration to Oracle Cloud Infrastructure blog series", which includes the posts related to database migration. Use these posts as building blocks for various migration approaches.

For more information on Oracle Database and Exadata Cloud Services, review the details at Oracle Cloud Infrastructure - Database


 

When you want to transfer database backups to Oracle Cloud Infrastructure Object Storage, use the following guidance and options to help you plan and estimate the transfer.

Data Transfer Guidance

The following table provides some high-level guidance based on "theoretical minimums" from over-the-internet data transfer time calculators. Start with these estimates to evaluate the time it might take to transfer your data, but then be sure to test for the actual numbers based on your data volume, network bandwidth, and network reliability.

Note: If uploading data takes longer than 1 to 2 weeks, consider using the Data Transfer service option (see the following section).

 

  10 Mbps 50 Mbps 100 Mbps 1 Gbps 10 Gbps
5 GB 1+ hours 13+ mins 7+ mins 1+ mins < 1 min
10 GB 2+ hours 27+ mins 13+ mins 1+ mins < 1 min
100 GB 23+ hours 4.5+ hours 2.25+ hours 14+ mins 1+ mins
1 TB 9.5+ days 1.5+ days 1+ days 2.25+ hours 14+ mins
5 TB 48+ days 10+ days 5+ days 12+ hours 1.10+ hours
10 TB 100+ days 20+ days 10+ days 1+ days 2.20+ hours


Transfer Options

Based on your data volume, network bandwidth, and network reliability, use one of the following options to upload the backups to Oracle Cloud Infrastructure (OCI) Object Storage. 

 

Option Transfer Mode Options for Copying Data
Public internet Online OCI CLI, OCI API, OCI Console, rclone
IPSec VPN Online OCI CLI, OCI API, OCI Console, rclone
FastConnect Online OCI CLI, OCI API, OCI Console, rclone
Data Transfer service Offline cp/scp to NFS mount points
Storage Gateway Sync cp/scp to NFS mount points


Incremental Backups Considerations

Based on your data volume, network bandwidth, and network reliability, you can also upload incremental backups to Object Storage by using the any of the preceding options.

As long as backups are complete and consistent, you can use a combination of transfer options, staggered over a period of time, to transfer the required backups to the target bucket. For example, say that you transferred the bulk of your data by using the Data Transfer service. The incremental backups that occurred since the last level 0 or level 1 backups shipped via the Data Transfer service can be uploaded by using different methods, such as the OCI CLI or rclone, to the same target bucket, which has another level 0/1 backups.

TDE Wallets Considerations

As a best practice, we recommend that you do not upload TDE wallet files and backups to the same location.

Oracle

Integrated Cloud Applications & Platform Services