Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration from remote to local Oracle database

889602Sep 21 2011 — edited Sep 23 2011
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2011
Added on Sep 21 2011
4 comments
433 views