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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Best way to update DB nightly with data from another DB

ChaosADSep 23 2008 — edited Sep 28 2008
Good morning. This is my first trip into the land of replication with DBs. I'm used to just dealing with standalone DBs that work in their own little world. Now I need to have 2 DBs that are identical in every way. One is live and on the production side gathering data everyday in a transaction style environment. The other sits offline, but needs to have the data from the production DB updated to it every night. What is the best way to first setup the off network DB and then what is the best way to update it every night with the data from the production DB? One thing to take note of is that these servers can not talk to each other so I couldn't do any network talking. This would be burning a cd/dvd and then going to the other server and performing actions on it. Below is some info on the servers:

11.1.0.6G Oracle
AMD64 Servers running 64bit Linux (Debian / Ubuntu)
Database is 2 schemas and size is around 3GB

My ideas for right now would be to do a expdp/impdp but I haven't quite figured out how to just update the information and not have it add it again without dropping the schema first then adding it again via the impdp.

Thanks in advance.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 26 2008
Added on Sep 23 2008
5 comments
1,297 views