Oracle Data Guard Review
Ensures data protection and reduces backup overhead, when set up well


Primary Use Case

Oracle Data Guard ensures data protection and disaster recovery. The better way to configure Data Guard is by having an Oracle production database on one site as the primary database, and an Oracle standby database on another site. This solution provides high availability.

Valuable Features

If you have a problem with your primary site and can't access your primary database, you can continue working with the database that you have as standby on the other site, by changing its role to primary.

Another valuable feature is the possibility of backing up the database from the standby database instead of the primary database, to avoid backup process overhead in the primary system.

Active Data Guard is other feature with advanced capabilities that extend basic Data Guard functionality. Some of the functions of Active Data Guard are: 

  • Real Time Query - Offloads read-only workloads to an up-to-date standby database
  • Automatic Block Repair - Automatically detects a block corruption and repairs it.

Room for Improvement

I think it would be great to have a graphical interface assistant (like DBCA, ASMCA, NETCA, etc.) for initial configuration, monitoring, configuring Oracle Data Guard Broker and all the Data Guard Broker commands, without needing Oracle Enterprise Manager Cloud Control installed.

Use of Solution

More than five years.

Stability Issues

There is no issue with primary database stability. Once Data Guard is configured, you don't have to change anything more in your primary database.

Pricing, License Cost and Setup

Oracle Data Guard is a feature available only in Oracle Database Enterprise Edition, and is available for extra cost.

Disclosure: My company has a business relationship with this vendor other than being a customer: Oracle Partner and Oracle University Partner.
1 visitor found this review helpful

8 Comments

Rodolfo DiazReal UserTOP 20

Muy buen Post !!!!!

Like (0)29 May 18
Liliana RodríguezReal UserTOP 20

Excelente post. Gracias por tu aporte.

Like (0)29 May 18
Marco A. Vidal L.Real UserTOP 10

Lo unico que debiera indicarse es que Dataguard por si solo entraria en Solucion de Contingencia , cuando hablamos de alta disponibilidad hablamls de Rac mezclado con Dataguard

Like (0)29 May 18
Diego E. AguirreReal UserTOP 5POPULAR

Muy bueno Rita, gracias por compartir

Like (0)29 May 18
Rita NuñezReal UserTOP 5

Marco A. Vidal L. considero como vos que para asegurar la alta disponibilidad tenes que tener una base de datos en RAC en un cluster. Sin embargo la definición de alta disponibilidad es dar alto nivel operacional, no estrictamente tiene que ser en un Cluster, en este caso, con Data Guard si se te cae la base primaria, seguís trabajando con la standby y podes continuar con el servicio. Claro que configurar para que sea lo mas transparente y el corte sea mínimo es complejo y artesanal, por eso sin duda el RAC es la mejor solución de alta disponibilidad y Data Guard para contingencia.

Like (0)30 May 18

Muy buen post. Gracias por el aporte

Like (0)31 May 18
Marco A. Vidal L.Real UserTOP 10

Completamente de acuerdo Rita , gracias por el aporte

Like (0)31 May 18
Rita NuñezReal UserTOP 5

Hola Marco A Vidal L tu comentario me llevo a re.leer detenidamente la publicación y me di cuenta que lo que estaba mal era el titulo que fue puesto por la Editora porque si bien yo lo mencione al final de una respuesta no es lo primero ni lo mas relevante. Asi que le pedi que lo cambie. Muchas gracias me ayudo mucho tu aporte, porque yo de la emoción ni lo habia leido.

Like (0)03 June 18
Guest
Why do you like it?

Sign Up with Email