In this blog post, I’m going to cover how to Migrate Database & Application (EBS R12) to Oracle Cloud with almost Zero Migration Down Time using Hybrid Data Guard.
In Migration, Downtime takes time to change the role of the Standby Database to the Primary database after migration to the Cloud. If you can’t afford this much downtime then use Golden Gate Cloud Service.
Note: Oracle Golden Gate is not supported with (EBS R12) so the recommended approach is to use the Hybrid Data Guard as covered in this post.
Note: In our DBA to Cloud DBA Training, We cover Hybrid Data Guard as a Bonus Module, To know more about Why should DBAs Learn Cloud, How to upgrade From DBA To Oracle Cloud DBA and Which Cloud Certification is Useful for DBAs Join Our FREE Masterclass
If you are a beginner in Cloud Migration then I highly recommend you to check our previous posts :
- Oracle EBS (R12) On-Premise to OCI Migration (Lift & Shift) Click here
- Oracle Database Migration To Cloud (Lift & Shift) Click Here
Migration Approach Using Hybrid Data Guard:
1) Create a Physical Standby Database on Oracle Cloud.
2) Copy the data file & control file from Primary (On-Premise) to Standby (Cloud) using a) Fastconnect, b) Data Transfer Service and for Application use rsync.
3) Make sure to archive logs shipped & applied to standby database on cloud.
4) When ready to migrate change:
a) Role of DB on Cloud from Standby to Primary
b) Re-Configure Application to point to DB on Oracle Cloud.
5) Change DNS from On-Premise to Application on Oracle Cloud.
Hybrid Data Guard Overview:
In Data guard both Primary and Standby databases either available on Cloud or on On-Premise, while in Hybrid Data Guard On-Premise data center worked as a Primary database & Database in the cloud works as a Standby database or vice-versa.
Data Guard Overview:
Data Guard provides a complete set of services that create, maintain, manage one or more standby databases to enable production Oracle databases to survive disasters and data corruption. Data Guard maintains these standby databases as copies of the production database.
If the primary database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production unit, minimizing the downtime associated with the outage.
To know more about Data Guard Click Here
To Know More about Data Guard Broker Click Here
Large Data Transfer Options:
If you have a large database then there are different options to migrate data to the Oracle Cloud.
1) Data Transfer Service: Offline data migration service that lets you securely move petabytes-scale datasets from customer’s data-center to Object/Archive storage on OCI.
2) Using Storage Gateway: Using storage gateway you can sync your On-Premise application data that can write to NFS mount without writing API to Oracle Cloud Object Storage.
To know more about Storage Gateway and how to Install Storage Gateway Click Here
3) FastConnect: OCI FastConnect provides an easy way to create a dedicated, private connection between your data center and OCI. FastConnect provides higher-bandwidth options, and more reliable and consistent networking experience compared to internet-based connections.
4) VPN Connect: To connect your On-Premises network and your VCN is to use a VPN Connect, which is an IPSec VPN. IPSec is a protocol suite that encrypts the entire IP traffic before the packets are transferred from the source to the destination.
For the fast data transfer and to get higher bandwidth use Fastconnect.
To know more Difference Between FastConnect & VPN Connect Click here
Hybrid Data Guard Deployment Process Key Points:
1. In Networking port 1521 should be open for connectivity between OCI and On-Premises through the public internet. To know more about Security List & Internet Connectivity Click here
2. In the Primary database and Standby, database name should be the same but the Unique name should be different.
3. Oracle Home for the On-Premises database must be the same Oracle patch set as the standby database.
$ORACLE_HOME/OPatch/opatch lspatches can be executed to check the one-off patches installed on both Source and Target environments
4. Use Oracle Transparent Data Encryption (TDE) for both primary and standby databases to ensure all data is encrypted at rest. Transparent Data Encryption (TDE) is by default Enable in Oracle Cloud.
6. Ensure network bandwidth is enough to handle peak redo transfer rates.
7. Ensure network reliability and security between On-Premise and OCI Cloud.
Note: There are two ways to Securely connect your cloud network to the On-Premises network, IPSec VPN and FastConnect. To know more about IPSec VPN and FastConnect Click here
8. To transport large data, use data transfer service. Offline data transfer service lets you securely move petabytes-scale datasets from the customer’s data center to Object/Archive storage on OCI using Data Transfer Disc and Data Transfer Appliance.
Hybrid Data Guard Deployment Process High-Level Steps:
1. Create DB System VM or BM. To know how to create DB system Click here
2. Manually delete data file created by tooling (To delete the starter database, use the manual method of removing the database files from ASM disk groups)
Note: Don’t remove Oracle Home.
3. Copy password file On-Premises to $ORACLE_HOME/dbs/orapw<ORACLE_SID> on OCI DBaaS host, if TDE is enabled on On-Premise.
4. Copy the wallet file to the OCI DBaaS host, consider this when configuring the standby database.
Note: Don’t forget to remove old wallet files in the OCI DBaaS host.
5. Configure static listeners.
- A static listener is needed for the initial instantiation of a standby database.
- The static listener enables remote connection to an instance while the database is down in order to start a given instance.
6. Oracle Net Encryption and TNS Entries for Redo Transport.
- Set TCP socket size, check the TCP socket sizes for the On-Premises system as well as the Cloud instance.
7. Instantiate the standby database.
- The standby database can be created from the active primary database or from a backup of the primary database.
8. Configure the Data Guard Broker via DGMGRL on the primary database, To know more about Data Guard Broker Click here
- Check out the Data Guard In Oracle Cloud Infrastructure (OCI): Overview & Concepts
- Check out the Overview of Oracle Exadata Cloud Service
- Learn More AboutData Guard Broker
- Read about Oracle Exadata Cloud Service Architecture
- Learn more about Oracle Exadata Deployment Options
- [Troubleshooting] Backup Failed In Exadata DB On Cloud With Error (ORA-600, RMAN-03002)
- Zero Downtime Migration In Oracle Cloud Infrastructure (OCI) Click here
Next Task for You
Join our FREE training on Migrate E-Business Suite database and application to Cloud using hybrid data guard, in this training, we cover Migration Overview & Options, Migration Tools: ZDM, MV2ADB, RMAN, Migration Solution: 4 Phase using Hybrid DR, Customer Case Study: Migration Requirement, Live Q/A Session & Much More.