Setup Wizard Reference

Owned by Copy Space for Confluence
Jan 22, 2017
2 min read

The Dbvisit Replicate setup wizard is the recommended way to configure a replication. The wizard does not make changes to the database, it creates text-based scripts (for SQL*Plus, dbvrep and shell/cmd.exe) that do the actual work. These scripts can be edited to tailor it for specific needs or migrated to another environment before running them.
To recreate or reset the replication environment, the scripts can be rerun at anytime and can be used for scripted deployment into production environments. They will drop and recreate the replication setup. 

The setup wizard is logically split into four parts:

  1. Describing the individual databases that are taking part in the replication.
  2. Setting up the replication pairs to determine which are the source and target databases.
  3. Choosing what to replicate, this can be tables and schemas.
  4. Process configuration which includes hostnames, port numbers and notification settings.

The wizard does not make changes to the database, it creates text-based scripts (for SQL*Plus, dbvrep and shell/cmd.exe) that do the actual work. These scripts can be edited to tailor it for specific needs before running them.To recreate or reset the replication environment, the scripts can be rerun at anytime and can be used for scripted deployment into production environments. They will drop and recreate the replication setup. The scripts created are (default names are listed here, using * for DDC name):

  • *.ddc: configuration variables, used when running dbvrep during the setup or anytime in the future. Only basic variables are included here, as most of them are stored in MINE database after setup. (See *-onetime.ddc and chapter on DDC files.)
  • *-onetime.ddc: configuration variables; these are stored in DDC DB after the scripts are run.
  • -dbsetup.sql: (re)creates the Dbvisit Replicate schema user and grants appropriate privileges. Because Oracle internal tables and views are involved, sysdba credentials are needed.
  • -grants.sql: grants the Dbvisit Replicate schema user privileges on the replicated objects.
  • *-setup.dbvrep: dbvrep script creating the Dbvisit Replicate schema tables and views, populating them with data and preparing selected schemas and tables for replication.
  • Nextsteps.txt: a plaint text file describing the next steps to take to initiate the replication.
  • -wizard.cfg: saves the configuration of the wizard after each step for the next run of the wizard or in case of a restart. This saves having to type all the information in again.
  • *-all.sh / *-all.bat: script that invokes the scripts described above and then starts the replication processes.
  • *-pre-all.sh/*-pre-all.bat: an optional script that is run before the *-all.sh script that configures supplemental logging when using the no-lock option for data instantiation.

The scripts contain all changes needed for both source and target database; running the all script once (e.g. on the source server) configures both source and target database.

This section describes the individual setup questions in the setup wizard.