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