Progress Fathom Replication
User’s Guide


Setting up the source and target databases

This section summarizes the commands you use and the tasks you perform to set up the source and target databases.

To set up the source database for offline backup:

  1. Back up the source database:
  2. probkup source_db_name device-name 
    

  3. Create a structure file:
  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:
    3. prostrct add source_db_name source_db_name_ai.st 
      

    4. Begin AI:
    5. rfutil source_db_name -C aimage begin 
      

  6. Enable Replication:
  7. proutil source_db_name -C enableSiteReplication source 
    

  8. Do an incremental backup:
  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:
  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:
    3. prostrct add source_db_name source_db_name_ai.st 
      

    4. Begin AI:
    5. rfutil source_db_name -C aimage begin 
      

  4. Set defer-agent-startup in the server properties file:
  5. [server] 
         control-agents=agent_name 
         database=source_db_name 
         transition=manual 
         transition-timeout=1200 
         defer-agent-startup=1400 
    

  6. Enable Replication:
  7. proutil source_db_name -C enableSiteReplication source 
    

  8. Restart the source database:
  9. PROSERVE -db source_db_name -DBService replserv 
    [-S port or 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:
  4. prorest target_db_name device-name
    prorest target_db_name device-name2 
    

  5. Enable Replication:
  6. proutil target_db_name -C enableSiteReplication target 
    

  7. Start the server for the target:
  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 "Implementing Fathom Replication" section.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095