The Duplicate Model for Workshare command generates a series of scripts that have a specific order of execution. The PreBackup<InstanceName>_<SiteDB>_<LocationID>.bat scripts are the first in a series of scripts that need to be executed from the GoldenGate folder. These scripts create the initial objects required for replication, including the GoldenGate manager service. The scripts must be executed on the Host and all corresponding Satellite servers while logged in with the administrator account.
-
Log on to the Host or Satellite server as an administrator with the SP3D_PROJECT_ADMINISTRATORS Oracle role.
You can execute the PreBackup scripts on all Satellite servers simultaneously.
-
Click Start > All Programs > Accessories > Command Prompt (Run as Administrator), and navigate to the GoldenGate installation folder.
-
Type the following command, and press ENTER:
PreBackup_<InstanceName>_<SiteDB>_<LocationID>.bat > PreBackup_<InstanceName>_<SiteDB>_<LocationID>.log
The names for the scripts above are for illustrative purposes. Ensure the names for
your scripts are correct before running them.
-
Review the log file output of the script, and resolve any reported errors.
-
To allow a remote director server connection, you need to add the entries below to the Host server and to all Satellite servers.
-
Add ACCESSRULE, PROG *, IPADDR *,PRI 1,ALLOW to the <OGG_HOME>\dirprm\mgr.prm file.
-
Add _DISABLEFIX21427144 to the <OGG_HOME>\GLOBALS file.
-