Release 10.1C: OpenEdge Replication:
User Guide


Setting up the source and target databases

This section describes how to set up the source and target databases.

To set up the source database for offline backup:

  1. Back up the source database, as shown:
  2. probkup source-db-name device-name 
    

  3. Create a structure file. For example:
  4. prostrct list source-db-name source-db-name.st 
    

  5. If AI is not enabled:
    1. Create and edit a structure file (source-db-name_ai.st) to add AI.
    2. Apply source-db-name_ai.st to the source database, as shown:
    3. prostrct add source-db-name source-db-name_ai.st 
      

    4. Back up the database, as shown:
    5. probkup source-db-name source-db-name.bak 
      

    6. Begin AI, as shown:
    7. rfutil source-db-name -C aimage begin 
      

  6. Enable Replication, as shown:
  7. proutil source-db-name -C enableSiteReplication source 
    

  8. Perform an incremental backup, as shown:
  9. probackup source-db-name incremental device-name2 
    

To set up the source database with deferred agent startup for online backup:

  1. Create a structure file. For example:
  2. prostrct list source-db-name source-db-name.st 
    

  3. If AI is not enabled:
    1. Create and edit a structure file (source-db-name-ai.st) to add AI.
    2. Apply source-db-name-ai.st to the source database, as shown:
    3. prostrct add source-db-name source-db-name-ai.st 
      

    4. Begin AI, as shown:
    5. rfutil source-db-name -C aimage begin 
      

  4. Set defer-agent-startup in the server properties file, as shown:
  5. [server] 
         control-agents=agent-name 
         database=source-db-name 
         transition=manual 
         transition-timeout=1200 
         defer-agent-startup=1400 
    

  6. Enable Replication, as shown:
  7. proutil source-db-name -C enableSiteReplication source 
    

  8. Restart the source database, as shown:
  9. PROSERVE -db source-db-name -DBService replserv 
    -S [ port | service name] 
    

To set up the target database:

  1. Move the source-db-name.st, the source backup file, and the incremental backup from the source machine to the target machine directory.
  2. Edit source-db-name.st on your target machine to match the target physical structure.
  3. Do a restore from both the backup and the incremental backup of the source database, as shown:
  4. prorest target-db-name device-name
    prorest target-db-name device-name2 
    

  5. Enable Replication, as shown:
  6. proutil target-db-name -C enableSiteReplication target 
    

  7. Start the server for the target, as shown:
  8. proserve -db target-db-name -DBService replagent 
    -S [port | service name] 
    

For more information about setting up the source and target databases, see the "Choosing the implementation method" section.


Copyright © 2008 Progress Software Corporation
www.progress.com