Migration from remote to local Oracle database
889602Sep 21 2011 — edited Sep 23 2011Hello,
I'm looking for advice with the following problem. I can connect to remote oracle database (located in VPN) and also local oracle database (running on localhost). What I need, is to copy the database from remote to local. The problem is, that the remote database is offline every hour (from xx.00 to xx.10) and I'm not able to continue transferring when the connection drops. The database is really big (about 10G, so it's not possible to download it in 50 minutes). I tried to pause the transfer 5 minutes before shutdown and resume it 5 minutes after startup, no success.
I tried about 20 different programs (like Navicat, also MySQL migration tool when I was trying to load the data into MySQL database), but none of them was able to do it.
The error I'm getting is: ora-01089: immediate shutdown in progress - no operations are permitted
The reason why it's offline every hour is, that this database is only mirror of production database, and it is syncing every hour, so I can't avoid the shutdown...
Please advice,
Thank You,
Filip