VM vs Data Guard for DB redundancy

In a few days, I need to start investigating maintenance and viability for a DB redundancy solution for 2,700 Oracle 12.1.0.2 databases on Linux. Currently, the 2,700 customers are in individual instances, but will be looking to put them into PDB's later this year.

Leadership has told me that RAC is not an option to be considered. Only Data Guard and VM with external storage. If the VM goes down, the thought is to bring up another VM and mount the original storage (san). It's obvious what to do with Data Guard.

I thought I'd check with the pros here to see what the rest of the best are doing.

What are the best options for DB redundancy? Considering maintenance, cost and overall viability. Want to be up 99% and downtime is limited to 45 minutes or less.

The VM option sounds interesting. Just bring up a new VM on the same IP and mount the same storage - viola. No app fail-over or DNS change, etc. Got just one DB cost. You would lose in-flight, but that appears to be acceptable.

Thoughts, pros/cons ? Other better solutions?

--

Sincerely,

WoodyMcKay

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 28 2016 - 17:47:39 CEST