Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to setup replication of oracle databases, with one server outside the firewall? If so any suggestions on how to setup would be great.

share|improve this question

migrated from Mar 31 '10 at 17:09

This question came from our site for professional and enthusiast programmers.

You might get better answers on – Raj More Mar 31 '10 at 17:07
Do you need the entire DB shipped outside the firewall or would a select few views/tables suffice? Is it bi-directional or one-way (will the DB outside the FW be updateable)? – DCookie Mar 31 '10 at 20:43

We do log shipping. Basically, our primary is set to archive log mode, which creates the files, then every couple of hours, they get rsync'd (over ssh, so it's viable for your situation) to the backup where they get replayed.

This does mean that you can't query against the other server, because it's in standby mode, and you need to activate it, but the data is copied over.

You can read more about it in an answer that I posted to this question:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.