Check the Statistics in a Broadcast Topology Based Data Replication

REST API Admin Client

# !/bin/bash

# ----------------------------------------------------------------------------------------------------

# --

# -- Create USERIDALIAS to connection from GoldenGate to the Databases

# --

# ----------------------------------------------------------------------------------------------------

echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- Extract EXN "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "Extract EXTN status:"
curl -s -k -X GET <https://north:9001/services/v2/extracts/EXTN>                                            \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Extract EXTN lag:"
curl -s -k -X POST <https://north:9001/services/v2/extracts/EXTN/command>                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Extract EXTN statistics:"
curl -s -k -X POST <https://north:9001/services/v2/extracts/EXTN/command>                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- DistPath DPNS"
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "DistPath DPNS_A status:"
curl -s -k -X GET <https://north:9002/services/v2/sources/DPNS_A>                                           \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "DistPath DPNS_A statistics:"
curl -s -k -X GET <https://north:9002/services/v2/sources/DPNS_A/stats>                                       \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
      | jq '.response' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "DistPath DPNS_B status:"
curl -s -k -X GET <https://north:9002/services/v2/sources/DPNS_B>                                           \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "DistPath DPNS_B statistics:"
curl -s -k -X GET <https://north:9002/services/v2/sources/DPNS_B/stats>                                     \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
      | jq '.response' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "DistPath DPNS_C status:"
curl -s -k -X GET <https://north:9002/services/v2/sources/DPNS_C>                                           \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "DistPath DPNS_C statistics:"
curl -s -k -X GET <https://north:9002/services/v2/sources/DPNS_C/stats>                                     \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
      | jq '.response' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

exit

Note: The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work.

# --
# -- Connect the GoldenGate Deployment depl_north
# --
CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_26ai !

INFO  EXTRACT extn
SEND  EXTRACT extn, GETLAG
STATS EXTRACT extn, TOTAL, TOTALSONLY *.*

INFO DISTPATH ALL
STATS DISTPATH dpns_a
STATS DISTPATH dpns_b
STATS DISTPATH dpnw_a
STATS DISTPATH dpnw_b

After creating the OBEY file, create a shell script to run in Admin Client:

echo "obey check_replication_datadistribution.oby" | adminclient

ls -ltrR /u01/app/oracle/deployments/depl_north/var/lib/data/north/
ls -ltrR /u01/app/oracle/deployments/depl_south/var/lib/data/north/
ls -ltrR /u01/app/oracle/deployments/depl_west/var/lib/data/north/