Mar 17 2020
Migrate an on-premises Oracle database to Oracle on Amazon EC2 using AWS DMS
There are many ways to migrate on premises Oracle database to Elastic Compute Cloud (EC2). In this post I will show how to use AWS Database Migration Service to migrate on-premises Oracle Database 12.1.0 running in Windows to AWS EC2 running in Linux. I installed locally Oracle 12c software in Windows environment and created manually a new Oracle database 12.1.0 (SID SRCDB) then installed the Sample Schemas/Users that populate data in the new schemas: IX , SH , OE , Read More
May 2 2020
Migrate on-premises Oracle 12c running in Windows to AWS EC2 Linux using Oracle Data Guard and SSH tunel
In this post I will walk you trough the steps to migrate a database Oracle 12.1.0.2.0 running in Windows 7 to AWS EC2 running Linux CentOS release 6.9 using Oracle Data Guard 12c The below diagram shows a Dataguard architecture of replication sending the redo streams trough a SSH Tunnel from the Primary Database (source db) to the Standby Database (target db) in AWS EC2. Current Environment SOURCE TARGET Operating System Microsoft Windows 7 Enterprise Edition 64 bits CentOS release Read More
By DBA_JAF • Amazon Web Services (AWS), Cloud, Data Guard, Databases, Migration, Oracle, Replication • 0