Release 10.1B: Progress Fathom 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, as shown:
  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, as shown:
  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 © 2006 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095