Which are the two prerequisites to migrate a physical database to an autonomous database?
Skip to main content This browser is no longer supported. Show
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Oracle database migration to AzureThis solution migrates an Oracle database and its applications to Azure. We use Oracle Active Data Guard for the database, and we use Azure Load Balancer for the application tier. ArchitectureDownload a Visio file of this architecture. Dataflow
Note
Components
AlternativesIf your database is over 2 TB, you can use Oracle Data Guard with Oracle Recovery Manager (RMAN), or use Data Pump to replicate changes after an initial bulk data transfer, which provides a minimal downtime migration. SQL Server Migration Assistant for OracleMicrosoft SQL Server Migration Assistant (SSMA) for Oracle is a tool for migrating Oracle databases to Microsoft SQL Server and Azure SQL Database. SSMA for Oracle converts Oracle database objects to SQL Server database objects, creates those objects in SQL Server, and then migrates data from Oracle to SQL Server or Azure SQL Database. Scenario detailsOracle DB migrations can be accomplished in multiple ways. This solution covers one of these options, wherein Oracle Active Data Guard is used to migrate the Database. It's assumed that Oracle Data Guard (or Active Data Guard) is used for HA/DR purposes. Depending on the application, either the application can be migrated first or the database. In this case, the application is migrated to Azure using Azure Load Balancer. This enables you to split your traffic between on-premises and Azure, allowing you to gradually migrate your application tier. The database migration is performed in multiple steps. As a first step, Oracle Data Guard is used to set up a Secondary/Standby Database in Azure. This allows you to migrate your data to Azure. Once the secondary in Azure is in-sync with the primary, you can flip the database in Azure to be your primary database while maintaining your secondary on-premises. As a next step, you may set up a secondary database in a different Availability Zone (or region) for HA/DR purposes. At this point, you can decommission your on-premises environment. All data traffic between on-premises and Azure flows over Azure ExpressRoute or Site-to-Site VPN connectivity. Potential use casesThis solution applies when migrating Oracle DB to Azure. ConsiderationsThese considerations implement the pillars of the Azure Well-Architected Framework, which is a set of guiding tenets that can be used to improve the quality of a workload. For more information, see Microsoft Azure Well-Architected Framework. MigrationYou can migrate your entire Oracle database from on-premises to Azure VM with minimal downtime by using Oracle Recovery Manager (RMAN) and Oracle Data Guard. Use RMAN to restore your database to the target standby Azure VM, using either backup/restore or the duplicate database method. You can then configure the target database as a physical standby database with Oracle Data Guard, allowing all the transaction/redo data changes from the primary on-premises database to the standby database. When the primary on-premises Oracle database is in sync with the target standby database on the Azure VM instance, you can switch over to the target database, which will convert it to a read-write database. You can then point your application connections to the new primary database. This option provides a minimum downtime while migrating your database to Azure. The Oracle Data Pump utility is used to export and import data and metadata from or to Oracle databases. You can run Data Pump export/import on an entire database, selective schemas, tablespaces, or database objects. Data Pump is the recommended tool for migrating data to Azure, for large databases that range from 10 GB to 20 TB in size. It allows a high degree of parallelism, flexible data extraction options, and scalable operations, which enable high-speed movement of data and metadata from a source database to the target database. Oracle Data Pump also supports encryption and compression, when exporting your data to data dump files. You can use Oracle Data Pump with Oracle Data Guard or Golden Gate to handle the initial data transfer for large databases. Note that Data Pump is available only on Oracle Database 10g Release 1 (10.1) and later. Design considerationsVM sizingConsider using a hyperthreaded memory-optimized virtual machine with constrained core vCPUs for your Oracle Database VM, to save on licensing costs and to maximize performance. Oracle has guaranteed license mobility from on-premises to Azure. See the Oracle-Azure FAQ. StorageUse multiple premium or ultra disks (managed disks) for performance and availability on your Oracle database. The disk/device name may change on reboots when using managed disks. It's recommended that you use the device UUID instead of the name, to ensure your mounts persist across reboots. Consider using Oracle Automatic Storage Management (ASM) for streamlined storage management for your database. Testing and tuningWe recommend the following tests to validate your application against your new Oracle database:
Oracle licensingIf you're using hyper-threading enabled technology in your Azure VMs, count two vCPUs as equivalent to one Oracle Processor license. See Licensing Oracle Software in the Cloud Computing Environment for details. Backup strategyOne backup strategy is to use Oracle Recovery Manager (RMAN) and Azure Backup for application-consistent backups. You can also use the Azure backup method. Optionally use Azure Blob Fuse to mount a highly redundant Azure Blob Storage account and write your RMAN backups to it for added resiliency. Business continuity and disaster recoveryFor business continuity and disaster recovery, consider deploying the following software:
Use Availability Zones to achieve high availability in-region. For more information, see the Reference architectures for Oracle databases on Azure. An uptime availability of 99.99% for your database tier can be achieved by using a combination of Azure Availability Zones and Oracle Active DataGuard with FSFO. Consider using proximity placement groups to reduce the latency between your application and database tier. MonitoringSet up Oracle Enterprise Manager for management, monitoring, and logging. Next stepsRefer to these articles for supporting information:
Learn more about the various architectural components:
FeedbackSubmit and view feedback for How do I migrate to autonomous database?Migrate Data into Autonomous Database.. Loading Data into Autonomous Database.. Load Data from Files in the Cloud.. Use Oracle Data Pump.. Use SQL*Loader.. Migrate to Autonomous Database Using Oracle Database Migration Service.. Use Oracle GoldenGate to Replicate Data with Autonomous Database.. Which two characteristics do you need to consider when choosing a method to migrate a database to Oracle cloud infrastructure?Some of the characteristics and factors to consider when choosing a migration method are:. On-premises database version.. Database service database version.. On-premises host operating system and version.. On-premises database character set.. Quantity of data, including indexes.. Data types used in the on-premises database.. What are two pre requisites for successful deployment of an autonomous dedicated database in OCI?Before you discover Autonomous Databases – Dedicated, you must ensure that you have performed the following tasks:. Create an Autonomous Database – Dedicated in Oracle Cloud Infrastructure. ... . Configure and deploy Oracle Enterprise Manager on Oracle Cloud Infrastructure.. Which two prerequisites must pass before the source database can be migrated using Oracle zero downtime migration?Meet the following prerequisites on the source database before the Zero Downtime Migration process starts.. The source database must be running in ARCHIVELOG mode. ... . The character set on the source database must be the same as the target database.. Configure the TDE wallet on Oracle Database 12c Release 2 and later.. |