How do you migrate a "Live" database to the Cloud?
I've been wondering what the best way to migrate a live database into the Cloud? Ideally downtime will be very short (10 minutes?), and risk will be low.
The specifics in our case are:
Oracle v18.104.22.168 on Solaris v10 --> Amazon EC2 Oracle v22.214.171.124 on RedHat (or maybe RDS)
PostgreSQL v9.2 on FreeBSD --> Amazon EC2 PostgreSQL v9.2 on FreeBSD (or maybe RDS)
In each case the databases are 2TB, and any sort of dump/restore will take too long... it takes over 3 hours just to copy the dump file to Amazon, let alone the export and import times. It's got to be a live migration where the source/target are in-sync. I have some ideas, but I won't bias you with them just yet.
Just to add one extra wrinkle, the Oracle database is currently WE8MSWIN1252 and I'd like to get it to AL32UTF8 at the same time if possible.