I want to migrate a production database from one linux server to other. I am not concern about upgrading my database version, just I want to move the database from one server to other with minimum down time.
The version of my database is 8.3. Its of size 160 GB.
It takes 12 Hours to take the dump and 8 hours to restore it.
Over here the downtime is of 20 Hours, which I cannot afford. I can afford a down time of 4 hours at max.
So how will I refresh the delta changes that happened in 20 Hours into the production database with the database over the other server.
Please help.