Versions Compared

Old Version 23

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 24

changes.mady.by.user Paul Steffensen (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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. 

No Format
\/ Dbvisit Replicate 2.7.02.4333(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:     98%             99%  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:                99%95%  Mine:7615235/7615235       Unrecov:0/0         Applied:7596224/7596224     Conflicts:0/0       Last:0112/08/2014 0615:1754:5811/OK
OEREPOE.ORDERS:         93%            99%  Mine:6143/6143   195/195    Unrecov:0/0         Applied:6127182/6127182     Conflicts:0/0       Last:0112/08/2014 0615:1754:5811/OK
OEREPOE.INVENTORIES:    95%            99%  Mine:7468/7468    228/228   Unrecov:0/0         Applied:7450217/7450217     Conflicts:0/0       Last:0112/08/2014 0615:1754:5811/OK
OEREPOE.LOGON:              97%        99%  Mine:7567/7567    265/265   Unrecov:0/0         Applied:7534259/7534259     Conflicts:0/0       Last:0112/08/2014 0615:1754:5811/OK
--------------------------------------------------------------------------------------------------------------------------------------------
7 tables listed.

dbvrep>

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

...

Note

TIP 1

If the Dbvisit Replicate console is not running then:

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

  2. Cd to the correct directory.

    No Format
    cd ~oracle/dbvrep_orclXE

  3. Start the Replication console:

    No Format
    ./start-console.sh

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

    No Format
    dbvrep --ddcfile /u01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-APPLY.ddc

    * The console can be started on any server that has a TNS connection to both the source and 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 OEREPOE.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