DR and data replication on Oracle 9i Standard

Hello,

We have two windows servers in different locations, and are currently logshipping from one to the other, to provide an almost realtime copy at the remote site. The theory being that we can bring it up with minimal data loss in the event of losing the primary site. We have very little in the way of Oracle skills (read, practically none).

We are purchasing a SAN solution at both the production and DR site (too far from each otherfor sync writes unfortunately), and are wondering if there is another way to doing this.

One suggestion has been to take snapshots of the oracle server and replicate those snapshots (well the delta's) to the DR site every five minutes (often mentioned with putting the Oracle DB in hot-backup mode first).

Is this going to be a workable solution?

The reason for looking at solutions other than logshipping is that we don't have any real oracle skills, so if we can do the data replication at a lower level (without compromising data integrity) it would be easier for us. However, It seems like despite the addition of a SAN, we are better off ignoring that and using logshipping.

Thanks Received on Sat Dec 01 2007 - 05:59:50 CST