Page Comparison

...

\ Dbvisit Replicate 2.7.02.4333(MAX edition) - Evaluation License expires in 30 days
MINE IS running. Currently at plog 133 and SCN 3214278 (08/01/2014 06:17:57).
APPLY IS running. Currently at plog 133 and SCN 3214206 (08/01/2014 06:17:55).
Progress of replication dbvrep_orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
OE.CUSTOMERS:                  99%  Mine:1138/1138       Unrecov:0/0         Applied:1133/1133   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
OE.ADDRESSES:                  99%  Mine:1138/1138       Unrecov:0/0         Applied:1133/1133   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
OE.CARD_DETAILS:               99%  Mine:1008/1008       Unrecov:0/0         Applied:1005/1005   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
OE.ORDER_ITEMS:                99%  Mine:7615/7615       Unrecov:0/0         Applied:7596/7596   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
OE.ORDERS:                     99%  Mine:6143/6143       Unrecov:0/0         Applied:6127/6127   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
OE.INVENTORIES:                99%  Mine:7468/7468       Unrecov:0/0         Applied:7450/7450   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
OE.LOGON:                      99%  Mine:7567/7567       Unrecov:0/0         Applied:7534/7534   Conflicts:0/0       Last:01/08/2014 06:17:58/OK
--------------------------------------------------------------------------------------------------------------------------------------------
7 tables listed.

- Dbvisit Replicate 2.6.00.3735(MAX edition) - Evaluation License expires in 30 days
MINE IS running. Currently at plog 715 and SCN 14587518 (12/28/2013 20:44:38).
APPLY IS running. Currently at plog 715 and SCN 14587446 (12/28/2013 20:44:36).
Progress of replication dbvrep_orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
OE.CUSTOMERS:                  98%  Mine:372/372         Unrecov:0/0         Applied:365/365     Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.ADDRESSES:                  98%  Mine:372/372         Unrecov:0/0         Applied:365/365     Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.CARD_DETAILS:               98%  Mine:331/331         Unrecov:0/0         Applied:327/327     Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.ORDER_ITEMS:                97%  Mine:2636/2636       Unrecov:0/0         Applied:2582/2582   Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.ORDERS:                     98%  Mine:2140/2140       Unrecov:0/0         Applied:2098/2098   Conflicts:0/0       Last:28/12/2013 20:44:39/OK
OE.INVENTORIES:                97%  Mine:2577/2577       Unrecov:0/0         Applied:2525/2525   Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.LOGON:                      98%  Mine:2605/2605       Unrecov:0/0         Applied:2554/2554   Conflicts:0/0       Last:28/12/2013 20:44:39/OK
--------------------------------------------------------------------------------------------------------------------------------------------
7 tables listed.

In the above console line numbers are shown for clarity and each line number relate to the following explanation:

1. Shows the version number and the edition
2. Shows the MINE process is running. Which PLOG sequence and SCN the MINE is processing and the database time related to the SCN
3. Shows the APPLY process is running. Which PLOG sequence and SCN the APPLY is processing and the (source) database time related to the SCN
4. Name of the replication
5. Separator
6. Replication statistics for table OE.CUSTOMER. The replication is at 98%99%. 372 1138 records have been mined. 365 1133 records have been applied. No conflicts
7. Replication statistics for table OE.ADDRESSES. The replication is at 98%99%. 372 1138 records have been mined. 365 1133 records have been applied. No conflicts
8. Replication statistics for table OE.CARD_DETAILS. The replication is at 98%99%. 331 1008 records have been mined. 327 1005 records have been applied. No conflicts
9. Replication statistics for table OE.ORDER_ITEMS. The replication is at 97%99%. 2636 7615 records have been mined. 2582 7596 records have been applied. No conflicts
10. Replication statistics for table OE.ORDERS. The replication is at 98%99%. 2140 6143 records have been mined. 2098 6127 records have been applied. No conflicts
11. Replication statistics for table OE.INVENTORIES. The replication is at 97%99%. 2577 7468 records have been mined. 2525 7450 records have been applied. No conflicts
12. Replication statistics for table OE.LOGON. The replication is at 98%99%. 2605 7567 records have been mined. 2554 7534 records have been applied. No conflicts
13. Separator
14. Number of tables listed in the command console

...

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.

sqlplus oe/oe@ttorcl_src

Run the query.

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.

sqlplus oe/oe@ttorcl_trg

Run the query.

SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders;
 
Total Orders
--------------------
$7,317,074,993.00