Versions Compared

Key

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

...

The following are examples of locations and log files needed during setup:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
set MINE_PLOG /home/oracle/dbvrep/mine/%S.%E

 

File name and location of the Plog files on the source server.

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
set APPLY_STAGING_DIR C:\app\oracle\dbvrep

 

Location of the Plog files on the target server.

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
set LOG_FILE dbvrep_%P_%D.%E

 

Name of log files on both source and target server.

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
%S is sequence, %T thread, %F original filename (stripped extension), %P (process), %E default extension.

 

Handy Tips

Show real time replication in status bar. This is the default:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
set STATUS_BAR status+list

 

Turn off list progress report in status bar:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
set STATUS_BAR status

 

Turn off status bar. This will require a restart of the Dbvisit command console:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
set STATUS_BAR off

 

Show progression during Dbvisit Replicate setup. This will show the internal Dbvisit Replicate tables being replicated:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
list progress all

 

Run healthcheck of Dbvisit Replicate.

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
healthcheck

 

Check connectivity of mine and apply. These commands will display the version id of the processes if functioning correctly.

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
engine mine send engine id

engine apply send engine id

 

Limit the number of tables shown in the status bar.

Section
Column
width5%

 

Column
width95
panel No Format
bgColorCCC
set STATUS_BAR_ACTIVE_TABLES 10

 

Show all the network interface settings:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
show interface

 

Show all the notification settings:

Section
Column
width5%

 

Column
width95
Panel No Format
bgColorCCC
show notify

 

Show all settings:

Section
Column
width5%

 

Column
width95
panel No Format
bgColorCCC
show all