As soon as SwingBench starts generating DML changes, the tables that have changes applied to them will appear in the Replication Console.
| Note |
|---|
See the TIPS below for handy common Dbvisit Replicate tips. |
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.
| Code Block | ||||
|---|---|---|---|---|
| ||||
| ||||
\/ Dbvisit Replicate 2.7.02.433306(MAX edition) - Evaluation License expires in 30 days MINE IS running. Currently at plog 13326 and SCN 3214278527369 (08/0112/2014 0615:1754:5709). APPLY IS running. Currently at plog 13326 and SCN 3214206527392 (08/0112/2014 0615:1754:5510). Progress of replication dbvrep_orclXE:MINE->APPLY: total/this execution -------------------------------------------------------------------------------------------------------------------------------------------- OE REPOE.CUSTOMERS: 99%98% Mine:113856/1138 56 Unrecov:0/0 Applied:55/55 Applied:1133/1133 Conflicts:0/0 Last:0112/08/2014 0615:1754:5811/OK OEREPOE.ADDRESSES: 100% 99% Mine:113855/113855 Unrecov:0/0 Applied:55/55 Applied:1133/1133 Conflicts:0/0 Last:0112/08/2014 0615:1754:5811/OK OEREPOE.CARD_DETAILS: 100% 99% Mine:100847/100847 Unrecov:0/0 Applied:47/47 Applied:1005/1005 Conflicts:0/0 Last:0112/08/2014 0615:1754:5811/OK OEREPOE.ORDER_ITEMS: 95% 99% Mine:7615/7615 235/235 Unrecov:0/0 Applied:7596/7596 Conflicts:0/0 Last:01/08/2014 06:17:58/OK OE.ORDERS: 99% Mine:6143/6143224/224 Unrecov:0/0 Applied:6127/6127 Conflicts:0/0 Last:0112/08/2014 0615:1754:5811/OK OEREPOE.INVENTORIESORDERS: 93% 99% Mine:7468/7468 195/195 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 182/182 Conflicts:0/0 Last:0112/08/2014 0615:1754:58/OK -------------------------------------------------------------------------------------------------------------------------------------------- 7 tables listed. | ||||
| Code Block | ||||
| ||||
- 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 11/OK REPOE.INVENTORIES: 95% Mine:228/228 Unrecov:0/0 Applied:365217/365217 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: 08/2014 15:54:11/OK REPOE.LOGON: 97% Mine:2636265/2636265 Unrecov:0/0 Applied:2582/2582 Conflicts:0/0259/259 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 -----08/2014 15:54:11/OK --------------------------------------------------------------------------------------------------------------------------------------- 7 tables listed. dbvrep> |
In the above console output of the Replication Console the line numbers are shown for clarity reference and each line number relate relates to the following explanation:
- Shows the version number and the edition, edition of the software (LTD, XTD, or MAX), and the type of license.
- Shows the MINE process is running. Which PLOG sequence (which is the same as the redo log sequence) and SCN the MINE is processing and the database time related to the SCN
- Shows the APPLY process is running. Which PLOG sequence and SCN the APPLY is processing and the (source) database time related to the SCN
- Name of the replication
- Separator
- Replication statistics for table OEREPOE.CUSTOMER. The replication is at 98%. 372 56 records have been mined. 365 55 records have been applied. No There are 0 conflicts.
- Replication statistics for table OEREPOE.ADDRESSES. The replication is at 98%100%. 372 55 records have been mined. 365 55 records have been applied. No There are 0 conflicts.
- Replication statistics for table OEREPOE.CARD_DETAILS. The replication is at 98%100%. 331 47 records have been mined. 327 47 records have been applied. No There are 0 conflicts.
- Replication statistics for table OEREPOE.ORDER_ITEMS. The replication is at 97%95%. 2636 235 records have been mined. 2582 224 records have been applied. No There are 0 conflicts.
- Replication statistics for table OEREPOE.ORDERS. The replication is at 98%93%. 2140 195 records have been mined. 2098 182 records have been applied. No There are 0 conflicts.
- Replication statistics for table OEREPOE.INVENTORIES. The replication is at 97%95%. 2577 228 records have been mined. 2525 217 records have been applied. No There are 0 conflicts.
- Replication statistics for table OEREPOE.LOGON. The replication is at 98%97%. 2605 265 records have been mined. 2554 259 records have been applied. No There are 0 conflicts.
- Separator
- Number of tables listed in the command console
...
- .
- The Replication Console command prompt.
| Note | ||||||
|---|---|---|---|---|---|---|
TIP 1 If the Dbvisit Replicate console is not running then:
|
Confirm the data is replicated
...
|
...
| No Format |
|---|
sqlplus oe/oe |
| 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 |
This query should give the same number on the source and target database when the replication is at 100%
...
|
| Note | ||
|---|---|---|
TIP 2 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:
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 |
| Note | ||
|---|---|---|
TIP 3 The statistics of the replication can be viewed with the following commands:
|
| Note | ||
|---|---|---|
TIP 4 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:
|