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.

migrated from stackoverflow.com Mar 31 '10 at 17:09

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

  • 1
    You might get better answers on ServerFault.com – 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:

Easy Oracle Log-Shipping

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy