I have an on premise oracle 11g database that i have to migrate to an EC2 instance hosting Oracle 11g in AWS. I have three options to achieve this
- Use Oracle Data guard to replicate the on premise database to cloud database
- Using RMAN to backup the existing database and restore it on Cloud
- Using expdp and impdp commands to export and import the database
My database size is approximately 2 TB.
I have following doubts
Q1: What is the best way among the three options?
Q2: Using data guard means that the AWS and the on premise database should be connected the entire time until the data is replicated on cloud, what if there is a network disconnect in between the process? Do i have to restart the replication process or will it continue from where it stopped?
Edit: We have a 2 day downtime window in which the data has to be migrated and restored on cloud. The on premise database is hosted on Solaris Operating System and Operating System on the AWS cloud will be RedHat Linux since Solaris in not available in AWS.
Will Oracle Data guard or RMAN support the change in the Operating system on the servers?