As you should see from the Replication Console, the target database is only a few records (usually a small number of seconds) behind the source database.
While SwingBench is still running, execute the record_count.bash
| No Format |
|---|
./record_count.bash
TABLE_NAME TTORCL_SRC TTORCL_TRG
------------------------------ ----------- -----------
ADDRESSES 750684 750672
CARD_DETAILS 750645 750638
CUSTOMERS 500631 500623
INVENTORIES 900131 900131
LOGON 1196213 1196135
ORDERENTRY_METADATA 4 4
ORDERS 716549 716536
ORDER_ITEMS 2148121 2148103
PRODUCT_DESCRIPTIONS 1000 1000
PRODUCT_INFORMATION 1000 1000
WAREHOUSES 1000 1000
11 rows selected.
Sum of orders TTORCL_SRC TTORCL_TRG
------------- ------------------ ------------------
ORDERS $3,584,875,457.00 $3,585,393,081.00 |
The numbers won't be the same as in the output above but you should see only a few records difference between the source and target.
| No Format |
|---|
./record_count.bash
TABLE_NAME TTORCL_SRC TTORCL_TRG
------------------------------ ----------- -----------
ADDRESSES 750816 750816
CARD_DETAILS 750760 750760
CUSTOMERS 500760 500760
INVENTORIES 900131 900131
LOGON 1196958 1196958
ORDERENTRY_METADATA 4 4
ORDERS 716839 716839
ORDER_ITEMS 2148955 2148955
PRODUCT_DESCRIPTIONS 1000 1000
PRODUCT_INFORMATION 1000 1000
WAREHOUSES 1000 1000
11 rows selected.
Sum of orders TTORCL_SRC TTORCL_TRG
------------- ------------------ ------------------
ORDERS $3,586,575,013.00 $3,586,575,013.00 |
To confirm that the data is replicated the following query can be run on both the source and the target database.
1. On the source server, as oracle, in the $HOME/replicate directory, execute the record_count.bash script to check the number of rows in each table and the sum total of all orders in both the source and target databases.
...