Best way to update DB nightly with data from another DB
ChaosADSep 23 2008 — edited Sep 28 2008Good 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.