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
- [Video] How to Register For FREE Oracle Cloud Trial Account 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.
Also Check Our Blog Post on Provision EBS R12 On OCI
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.
Also Read: Our blog post on OCI Load Balancer 502 Bad Gateway. Click here
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
Also Read: Our previous blog post on Oracle EBS Cloud Manager. Click here
Large Data Transfer Options:
If you have a large database then there are different options to migrate data to the Oracle Cloud.
Check Out: Our blog post on Oracle EBS R12 On Cloud. Click here
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
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
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, the 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.
Also Check: Our blog post on Oracle EBS Cloud Manager Overview. Click here
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
Also Check: Our previous blog post on Oracle Database 18c. Click here
Related/Further Readings
- Check out the Data Guard In Oracle Cloud Infrastructure (OCI): Overview & Concepts
- Check out the Overview of Oracle Exadata Cloud Service
- 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
If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.
Leave a Reply