Time for action – basic monitoring with Data Guard broker

Now we'll see how to perform basic Data Guard monitoring using the broker interface DGMGRL.

1. Check the configuration status with the following command. It provides the overall health status of the Data Guard configuration. If the Configuration Status resulted to SUCCESS, it means that the Data Guard configuration is working properly. Output can also be WARNING or ERROR as follows:

   DGMGRL> show configuration;
   Configuration - PACKT
     Protection Mode: MaxPerformance
     Databases:
       turkey_un - Primary database
         Error: ORA-16778: redo transport error for one or more databases
       INDIA_UN  - Physical standby database
         Error: ORA-01031: insufficient privileges
   Fast-Start Failover: DISABLED
   Configuration Status:
   ERROR
   

2. Check the database status to find out if there are any warnings or errors in the databases of the Data Guard configuration. Use the following command from the DGMGRL utility:

   DGMGRL> show database turkey_un...