Check the Statistics in a Broadcast Topology Based Data Replication
# !/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/