Best way to move Oracle database to another machine
721832Sep 10 2009 — edited Jul 12 2011Hello,
I'm trying to find the best solution for that case:
On first Unix machine I'm running 10g database. Whole oracle (binary files + datafiles + index + redo) takes about 350GB from my first storage.
On second Unix machine (and second storage) I'd like to run exactly the same instance (the first one is going to be a backup server).
I work in real OLTP environment, and I can only afford a 4-5 hours of downtime (in the night) to move from server 1. to 2.
Could you recommend me the best solution for moving database to no. 2. My problem is, that between storage 1. and storage 2. I've only 30MB/s bandwidth, sequence:
1) instance_on_1: shutdown immediate
2) scp /u01/oracle server2:/u01/oracle
3) instance_on_3: startup
will take about 3-4 hours, so I would have no time to additional tasks.
Best regards
R.