Versions Compared

Key

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

...

Align

The Dbvisit Replicate wizard has completed and has created the necessary replication environment.
Exit out of dbvrep and run the *-all.sh or *all.bat script created by the wizard. If you chose the 'no lock' option for data instantiation during the Step 2 of the Setup Wizard there will be an additional script called *pre-all.sh. In the above example the script is called orcl-pre-all.sh. This script will turn on supplemental logging on the database as well as turn on table level supplemental logging. The *-pre-all.sh script should be run at a time when the database is not as active as supplemental logging will require a lock on those tables.

In the above example the script is called orcl-all.sh. This script can be run at any time to reset or recreate the replication environment. The Nextsteps.txt explains the next steps to initiate the replication.
This completes the Dbvisit Replicate setup and configuration.
Before running the script, review the created scripts as indicated by the Nextsteps.txt (shown at the end of all.* script). For example:

  • Review the location of dbvrep(.exe) if it differs among the nodes if RAC is used.
  • Check TNS_ADMIN and ORACLE_HOME paths and make sure they are correct on all the different servers involved.

After testing, consider adding the starting of dbvrep processes to init scripts on Linux/Unix to automatically start them on server reboot. (This is not needed on Windows, as processes are registered as services by default).

...