How can I check the synchronization status of ADG in Or…

2 years ago
Liam
2 minutes

You can check the synchronization status of Oracle ADG (Active Data Guard) using one of the following methods:

  1. You can check the ADG synchronization status by executing the following SQL query.
SELECT NAME, VALUE
FROM V$DATAGUARD_STATS
WHERE NAME IN ('transport lag', 'apply lag', 'estimated startup time');

Among them, ‘transport lag’ refers to transmission delay, ‘apply lag’ refers to application delay, and ‘estimated startup time’ refers to the estimated time to start up.

  1. By using Enterprise Manager (EM), you can check the ADG synchronization status by logging into the Oracle Enterprise Manager interface. Select “Primary Database” in the “Data Guard” section on the left, then view the ADG synchronization status in the “Data Guard Status” area.
  2. You can use the DGMGRL (Data Guard Broker) command-line tool to check the ADG synchronization status. Start by opening a command line terminal and connecting to the Data Guard Broker, then run the following command to view the synchronization status:
DGMGRL> SHOW DATABASE <database_name> 'Transport Lag';
DGMGRL> SHOW DATABASE <database_name> 'Apply Lag';

Among them, is the name of the ADG database.

Please ensure you have adequate permissions to access the relevant views and tables when running these queries.

bannerAds