Versions Compared

Old Version 11

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version Current

changes.mady.by.user Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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
themeConfluence
linenumberstrue
No Format
\ Dbvisit Replicate 2.67.0002.37354333(MAX edition) - Evaluation License expires in 30 days
MINE IS running. Currently at plog 715133 and SCN 145875183214278 (1208/2801/20132014 2006:4417:3857).
APPLY IS running. Currently at plog 715133 and SCN 145874463214206 (1208/2801/20132014 2006:4417:3655).
Progress of replication dbvrep_orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
OE.CUSTOMERS:                  98%99%  Mine:3721138/3721138         Unrecov:0/0         Applied:3651133/3651133     Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3858/OK
OE.ADDRESSES:                  98%99%  Mine:3721138/372  1138       Unrecov:0/0         Applied:3651133/365 1133    Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3858/OK
OE.CARD_DETAILS:               98%99%  Mine:3311008/3311008         Unrecov:0/0         Applied:3271005/3271005     Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3858/OK
OE.ORDER_ITEMS:                97%99%  Mine:26367615/26367615       Unrecov:0/0         Applied:25827596/25827596   Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3858/OK
OE.ORDERS:                     98%99%  Mine:21406143/21406143       Unrecov:0/0         Applied:20986127/20986127   Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3958/OK
OE.INVENTORIES:                97%99%  Mine:25777468/25777468       Unrecov:0/0         Applied:25257450/25257450   Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3858/OK
OE.LOGON:                      98%99%  Mine:26057567/26057567       Unrecov:0/0         Applied:25547534/25547534   Conflicts:0/0       Last:2801/1208/20132014 2006:4417:3958/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 (which is the same as the redo log 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 There are 0 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  There are 0 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  There are 0 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  There are 0 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  There are 0 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  There are 0 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 conflictsSeparator There are 0 conflicts.
  13. Number of tables listed in the command console. 
Note

TIP 1

If the Dbvisit Replicate console is not running then:

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

    No Format
    ssh oracle@source-int

    cd ~oracle/dbvrep_orcl

    .

  2. Cd to the correct directory.

    No Format
    cd ~oracle/dbvrep_orcl

  3. Start the Replication console:

    No Format
    ./start-console.sh

Confirm the data is replicated

...

  1. The console can also be started on the target server *. The manual command to start the console is:

    No Format
    dbvrep --ddcfile /u01/oracle/dbvrep_orcl/dbvrep_orcl-APPLY.ddc

    * The console can be started on any server that has a TNS connection to both the source and

...

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%

...

  1. target database, and has the Dbvisit Replicate software installed (including Windows or the host machine). You will need to copy either the MINE ddc or APPLY ddc file to the server you are running the console from. This is to connect the console to the replication.

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:

No Format
dbvrep> 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"

Note

TIP 3

The statistics of the replication can be viewed with the following commands:

No Format
dbvrep> list stats
dbvrep> list stats all
dbvrep> list stats OE.ORDER_ITEMS
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:

No Format
dbvrep> show notify                                                                                                                          
*.NOTIFY_ALERT_EMAIL = OFF
*.NOTIFY_ALL_EMAIL = OFF
*.NOTIFY_CONFLICT_CURRENT_PAUSE = YES
*.NOTIFY_CONFLICT_CURRENT_RETRY = 2
*.NOTIFY_CONFLICT_THRESHOLD = 100
*.NOTIFY_DAILY_LIST_PROGRESS_TIME24 = 0700
*.NOTIFY_EXCEEDED_CYCLE_NUM = 2
*.NOTIFY_INCIDENT_LIMIT = 10
*.NOTIFY_INTERVAL_BETWEEN_CHECK = 5m
*.NOTIFY_ON_DDL = YES
*.NOTIFY_PEER_DOWN = ALL
*.NOTIFY_PROGRESS_DIFFERENCE_PERC = 10
*.NOTIFY_SCN_DIFFERENCE = 1000
*.NOTIFY_SEND_HEARTBEAT_TIME24 = 0800:1300
*.NOTIFY_SEQUENCE_DIFFERENCE = 10
*.NOTIFY_SUCCESS_EMAIL = OFF
*.NOTIFY_TIME_DIFFERENCE = 300