Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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.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%. 372 records have been mined. 365 records have been applied. No conflicts
  7. Replication statistics for table OE.ADDRESSES. The replication is at 98%. 372 records have been mined. 365 records have been applied. No conflicts
  8. Replication statistics for table OE.CARD_DETAILS. The replication is at 98%. 331 records have been mined. 327 records have been applied. No conflicts
  9. Replication statistics for table OE.ORDER_ITEMS. The replication is at 97%. 2636 records have been mined. 2582 records have been applied. No conflicts
  10. Replication statistics for table OE.ORDERS. The replication is at 98%. 2140 records have been mined. 2098 records have been applied. No conflicts
  11. Replication statistics for table OE.INVENTORIES. The replication is at 97%. 2577 records have been mined. 2525 records have been applied. No conflicts
  12. Replication statistics for table OE.LOGON. The replication is at 98%. 2605 records have been mined. 2554 records have been applied. No conflicts
  13. Separator
  14. Number of tables listed in the command console

 

If the Dbvisit Replicate console is not running then:

  1. ssh to the souce server (dbv01) as oracle

    ssh oracle@source-int

  2. cd ~oracle/dbvrep_orcl

    cd ~oracle/dbvrep_orcl

  3. Start the Replication console

    ./start-console.sh
  • No labels