The replication can be viewed from the Dbvisit Replication console.
1. Switch to the session where the Dbvisit Replicate console is running and the replication can be seen to be progressing while Swingbench is running in the background.
\ 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. |
In the above console line numbers are shown for clarity and each line number relate to the following explanation:
If the Dbvisit Replicate console is not running then:
|
TIP 1 If there are many tables in the replication, then only a certain number of tables will be shown in the console. The number of active tables shown in the console is configurable with setting "STATUS_BAR_ACTIVE_TABLES". To get a list of all the tables in the replication, use the command: "list progress" The "list progress" report can be emailed automatically if notification is setup. The schedule when this report is sent is controlled by "NOTIFY_DAILY_LIST_PROGRESS_TIME24" |
TIP 2 There are many settings and configurations possible with Dbvisit Replicate. To see all the settings type: "show all" For example, to see all the settings regarding notifications:
|
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 |
This query 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 be the same. |