If you were talking to someone whose organization is considering Oracle Data Guard, what would you say?
How would you rate it and why? Any other tips or advice?
It is a very useful administrative IT tool. It saves on costs. I strongly recommend Data Guard. I've been using it for eight years and I would strongly recommend it. I'd rate Oracle Data Guard a seven out of ten. To make it a ten, the core base license could be cheaper. The cloud environment would also make it cheaper.
We're Oracle partners. We've worked with databases 11G and 12C. If a company is planning to implement Oracle solutions, I would suggest they also implement Data Guard. I'd rate the solution nine out of ten.
Most of my projects are on-premise, and most of them are based on low-cost engineers and information on the internet. Right now, the cloud is really good if you change units. There is a direct limitation on some solutions because of the cost being high for this type of software and I chose not to use the cloud. The solution is quite functional, however, I do find that some features are not great in real production. You need to have the software to ensure the continuity in the case of using Oracle. I'd rate the solution six out of ten due to its difficulty in terms of maintenance and audio problems. I'm also looking for CTCT maintenance and implementation and wish is was a bit easier.
This solution is for small to medium-sized businesses, who can't afford to have two data centers or two servers. Oracle Data Guard has many features to ensure that the database is in place. In case the primary database goes down or is corrupt in any way, you can recall the data immediately to restore the primary database. It's important to know that backup is in place at any given time. I would rate this solution a ten out of ten.
I don't really have any advice for other users, because we only use the solution's basic functionality for disaster recovery. Personally, I would advise others to avoid it due to its complexity. On a scale from one to ten, I rate this solution a seven. From a functionality point of view, I can't complain about Data Guard. But I would avoid it as it adds more complexity to a configuration, which is not necessary. From a setup point of view, Oracle has experienced people that will help you with it.
We use the on-premises deployment model. I would rate the solution eight out of ten. I'd rate it higher if the GUI was better, but it's a very stable solution. For disaster recovery, I think this is one of the best native Oracle products that you could use, provided you have the Enterprise edition.
Currently, we are using the on-premise version on the solution. I would rate this solution eight out of ten. I would recommend the solution because it is a good product and it's working fine. But I'm not sure if it's suitable for every consideration or any environment.
They could enhance their GUI or they should have a cloud control tool. They should have Data Guard tools in order to troubleshoot whenever there is a problem. There isn't anything in place for the configuration. Everything has to be done manually within the standard guide in Data Guard-related commands. Having a GUI with Data Guard is something that would be appreciated. I would rate this solution an eight out of ten.
Keep monitoring. This is the problem with the product. You have to keep monitoring the system all the time, just to avoid the interruption from the archive mode. I am going to give Oracle Data Guard a seven out of ten. It still needs improvements. When you are doing the troubleshooting there are no monitoring tools. You have to keep watching the log all the time. Also, for the configuration, if you miss one of the backlogs, you have to re-issue again. Re-issuing is not easy. It's a long process to do it.