Manual update / replication on a live database?

Pardon me if this is naive, but I'm not an expert on Oracle - and this is why I'm coming to the group..

I have a question about replicating data across non-connected databases.. (both Oracle 10g)

We have two databases - one is our "active" database that takes in transactions, and the other is a read-only "copy" at a remote location.  We'd like to update this "copy" database three times a week, but since this remote database is not WAN connected, it'd have to be via CD or other manual file transfer.

The single requirement, however, is that we can't take either database down to extract the data (on the "active" side) or to upload the data (on the "read only copy" side). Both databases need to be able to be accessed uninterrupted during any such maintenance procedures.

What would you folks say is the best practice for this? Our intent right now is to take the transaction / redo log from the live database, and simply transport it over via CD, and then 'recover' the database from the redo log in live mode.. Is that feasible, and is there a better way?

Thanks in advance for any pointers or tips..

-Chris Received on Tue Jan 02 2007 - 15:27:09 CST