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:

>     probkup source_db_name device-name

> 2. Create a structure file:

>     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:

>     prostrct add source_db_name source_db_name_ai.st

> 3. Begin AI:

>     rfutil source_db_name -C aimage begin

> 4. Enable Replication:

>     proutil source_db_name -C enableSiteReplication source

> 5. Do an incremental backup:

>     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:

>     prostrct list source_db_name source_db_name.st

> 2. 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:

>     prostrct add source_db_name source_db_name_ai.st

> 3. Begin AI:

>     rfutil source_db_name -C aimage begin

> 3. Set `defer-agent-startup` in the server properties file:

>     [server]
>          control-agents=agent_name
>          database=source_db_name
>          transition=manual
>          transition-timeout=1200
>          defer-agent-startup=1400

> 4. Enable Replication:

>     proutil source_db_name -C enableSiteReplication source

> 5. Restart the source database:

>     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:

>     prorest target_db_name device-name
>     prorest target_db_name device-name2

> 4. Enable Replication:

>     proutil target_db_name -C enableSiteReplication target

> 5. Start the server for the target:

>     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