Configuring Replicate with DDC file

The following Step-by-step example shows steps needed to configure APPLY process for using DDC file instead of DDC database.

1. Run Setup Wizard as usually and create a new replication using all script generated by Setup Wizard.
2. Do not start mine, apply and fetcher processes.
3. Backup <ddc_name>-APPLY.ddc file on apply server.

4. On mine server run

   sh start-console.sh show all > <ddc_name>-APPLY.ddc

5. Open new <ddc_name>-APPLY.ddc file and delete

   Initializing......done
   DDC loaded from database (368 variables).
   Dbvisit Replicate version 2.7.20_unreleased.5952
   Copyright (C) Dbvisit Software Limited.  All rights reserved.
   DDC file /home/oracle/<ddc_name>/<ddc_name>-MINE.ddc loaded.

   from the beginning and

   OK-0: Completed successfully.

   from the end of the file.

6. Check that every parameter is printed on one line only. Sometimes you can find incorrect formatting like this:

   *.DDC_PASSWORD =
   53616c7465645f5f8098ca975d0f9e56cd1f7174ff6da2adfa304f82a50b1f1f

   Fix if necessary.

7. Remove all lines that do not set any value, for example:

   *.FETCHER_PEER = 

   (note: there can be a space character at the end of the line which causing parameters to be set incorrectly)

8. Add "memory_set " at the beginning of every line.
9. Find every occurrence of the following parameters:
   • DDC_DATABASE
   • DDC_DATABASE_DBID
   • DDC_PASSWORD
   • DDC_SCHEMA
   • DDC_USER

   and comment them out by adding # sign at the beginning of the line (every occurrence means parameters with *., MINE., APPPLY., FETHCER. prefixes)

10. Copy the new <ddc_name>-APPLY.ddc file from the mine server to the apply server.
11. Do not change <ddc_name>-run-<hostname>.sh script on apply server. The script used to call the old apply ddc file which instructed the process to read all the parameters from the DDC database (see the load ddcdb command in the backed up script). Now the new apply ddc file contains all the parameters and does not read the DDC database.
12. Start the replication (all processes) as usually.