-
Oracle Cloud Infrastructure, Solutions
|
October 8, 2018
Database Migration to Oracle Cloud Infrastructure: Planning for Database Backup Transfers to Object Storage
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.