I work in a small company, that runs an ERP that holds about 600MB of data. My task at hand is, to find a way to always have real time backup of the erp (Oracle 11g) that can be retrieved easily (so that the company keeps working). Right now, the erp is hosted on one IBM Server (Windows 2008 R2), and we keep backups of the previous day. The company that supports the erp, says "Go IBM Storage, it is awesome and we know how to do it", but my question is: is an IBM Storage device really safe? Sure, it has 2 controllers, 2 psus, disks in raid, but can i depend on it? if something happens on the device itself (not some disk, or a psu, or even the pc that will access it itself as there will be 2 of them), ain't the company out of business (without even the backups of the previous day?). I found and proposed to the support company the Active Data Guard (Oracle software for data mirroring), but they don't use it at all (my guess is that it is cheaper than storage solution and they won't make much by selling just one pc and some software). What would you suggest?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as primarily opinion-based by Paul White♦, RolandoMySQLDBA, Jon Seigel, Michael - sqlbot, Mark Storey-Smith Feb 1 '14 at 21:44
Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.
Fault-tolerant storage, a stand-by database (Data Guard in your case), and the database backup are three different solutions to different types of problems. Depending on how much downtime you can afford, you may need to implement all three.