Honored Contributor Honored Contributor
Re: Suggestions about system restore

recovery from what type of failure? hardware, software, communications, fire, earthquake, comet strike?

what state do you need to recover to? beginning of day, beginning of week, beginning of last month, 10 minutes ago, one minute ago, or instantaneous?

15-20 mins from when? instant of failure, time of detection, start of recovery?

There are many possibilities, depending on what type of failures you want to be able to recover from, and (most important), how much money you're prepared to spend. In simple terms, the shorter you want the recovery time, and the fewer lost transactions, the more you need to spend.

With enough cash you can build an OpenVMS system that can recover from complete site
destruction in a matter of minutes with no lost transactions. I'm thinking three sites with three member shadow sets, symmetric with at least two nodes at each site, all with redundant comms links and power.

If you're serious about building a highly reliable system, you need to approach the problem from a much higher level than could be answered in a forum like this. Engage a consultant to help you - expect to pay a fairly significant sum for the service.
A crucible of informative mistakes