Hi Tom.

I've been an avid follower for many years and I feel lucky to ask you a question.

I've been asked to recommend a solution to a business unit. They are using Oracle Standard Edition and they want to enable a disaster recovery solution to a 3rd party site some miles away.

I've recommended they upgrade to Enterprise Edition and use Dataguard. The business is not happy upgrading to Enterprise Edition and they want me to develop an answer without spending the extra cost. (I know they will spend this in the development).

Their solution is to log switch every xxx minutes and apply the logs to the DR server, however my question to them is "why re-invent the wheel"? As well, this will generate many more archive logs throughout the day.

The other option is to use "true copy" to mirror data across the network, however this will generate way too much traffic.

Is there another solution for Standard Edition. What are you thoughts?