Check the Statistics After Replication in a Consolidation Topology

REST API Admin Client

Copy and use the following cURL script to set up Oracle GoldenGate data replication environment on a pre-installed database.

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.

#!/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 DPNW"
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "


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

echo "DistPath DPNW statistics:"
curl -s -k -X GET https://north:9002/services/v2/sources/DPNW/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 " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- Extract EXTS "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "


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

echo "Extract EXTS lag:"
curl -s -k -X POST https://south:9101/services/v2/extracts/EXTS/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 EXTS statistics:"
curl -s -k -X POST https://south:9101/services/v2/extracts/EXTS/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 DPSW"
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "


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

echo "DistPath DPSW statistics:"
curl -s -k -X GET https://south:9102/services/v2/sources/DPSW/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


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

echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- Replicats REPN and REPS "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "Replicat REPN status:"
curl -s -k -X GET https://west:9201/services/v2/replicats/REPN                                            \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Replicat REPN lag:"
curl -s -k -X POST https://west:9201/services/v2/replicats/REPN/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 "Replicat REPN statistics:"
curl -s -k -X POST https://west:9201/services/v2/replicats/REPN/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPS status:"
curl -s -k -X GET https://west:9201/services/v2/replicats/REPS                                            \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Replicat RESN lag:"
curl -s -k -X POST https://west:9201/services/v2/replicats/REPS/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 "Replicat REPS statistics:"
curl -s -k -X POST https://west:9201/services/v2/replicats/REPS/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

ls -ltrR /u01/app/oracle/deployments/depl_west/var/lib/data/north
ls -ltrR /u01/app/oracle/deployments/depl_west/var/lib/data/south
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 dpnw

shell ls /u01/app/oracle/deployments/depl_north/var/lib/data/north/ 2>/dev/null

# Connect the GoldenGate Deployment depl_south

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_26ai !

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

INFO DISTPATH ALL
STATS DISTPATH dpsw

shell  ls /u01/app/oracle/deployments/depl_south/var/lib/data/south/ 2>/dev/null

# Connect the GoldenGate Deployment depl_west

CONNECT https://west:9201 DEPLOYMENT depl_west AS ggma PASSWORD GGma_26ai !

INFO  REPLICAT repn
SEND  REPLICAT repn, GETLAG
STATS REPLICAT repn, TOTAL, TOTALSONLY *.*

INFO  REPLICAT reps
SEND  REPLICAT reps, GETLAG
STATS REPLICAT reps, TOTAL, TOTALSONLY *.*

shell  ls /u01/app/oracle/deployments/depl_west/var/lib/data/north/ 2>/dev/null
shell  ls /u01/app/oracle/deployments/depl_west/var/lib/data/south/ 2>/dev/null

DISCONNECT

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

echo "obey check_replication_dataconsolidation.oby" | adminclient