Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 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

1 Answer 1

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:

http://serverfault.com/questions/125720/easy-oracle-log-shipping/125781#125781

share|improve this answer

Your Answer

 
discard

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