Locations
The following are examples of locations and log files needed during setup:
set MINE_PLOG /home/oracle/dbvrep/mine/%S.%E
File name and location of the Plog files on the source server.
set APPLY_STAGING_DIR C:\app\oracle\dbvrep
Location of the Plog files on the target server.
set LOG_FILE dbvrep_%P_%D.%E
Name of log files on both source and target server.
%S is sequence, %T thread, %F original filename (stripped extension), %P (process), %E default extension.
Handy Tips
Show real time replication on status bar:
set STATUS_BAR status+list
Show progression during Dbvisit Replicate setup. This will show the internal Dbvisit Replicate tables being replicated. This is the default setting.
list progress all
Run healthcheck of Dbvisit Replicate.
healthcheck
Check connectivity of mine and apply. These commands will display the version id of the processes if functioning correctly.
engine mine send engine id
engine apply send engine id
Limit the number of tables shown in the status bar.
set STATUS_BAR_ACTIVE_TABLES 10