To confirm that the data is replicated the following query can be run on both the source and the target database.
1. Connect to the source database.
| No Format |
|---|
sqlplus oe/oe@ttorcl_src |
Run the query.
| No Format |
|---|
SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders;
Total Orders
--------------------
$7,317,074,993.00 |
2. Connect to the target database.
| No Format |
|---|
sqlplus oe/oe@ttorcl_trg |
Run the query.
| No Format |
|---|
SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders;
Total Orders
--------------------
$7,317,074,993.00 |
...
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.
| No Format |
|---|
./record_count.bash
|
| Note |
|---|
This queries should give the approximately the same number on the source and target database when the replication is < 100%. Run the queries several times to see that the numbers are updating on both the source and target database. If the replication is at 100% then the numbers will should be the same. |