Search code examples
oracleamazon-web-servicesmigrationdatabase-migrationaws-dms

Oracle database migration from on premise to AWS with zero downtime and only AWS services

I wanted to know if we can migrate an oracle database from on premise to AWS, using aws/open source tools/services only with zero downtime. The preference is just AWS services. since this is a 1 time requirement we are not interested in purchasing third party tool licenses. The important requirement for this POC is that there shouldn't be any downtime.

Kindly let me know if you can provide me any inputs for the same.

Thanks

Solution

  • To reduce database downtime, use standby technology.

    1. Install Oracle software only(same version on premise server) on the new server AWS EC2.
    2. Perform a hot backup on the premise server.
    3. Restore the hot backup to the new server AWS EC2.
    4. Configure the standby between the premise Oracle servers and new AWS EC2.
    5. Make switchover role primary to standby AWS EC2.