Progress Fathom Replication
User’s Guide

> ## Re-enabling Fathom Replication after transition

> After transition, you can re-enable what was once the target database on the source machine.

> To re-enable what was once the target database on the source machine after transition:

> 1. Shut down the former target database from the target database directory using the following command:

>     PROSHUT target_db_name -by

> 2. Back up the former target database from the target database directory using the following command:

>     PROBKUP target_db_name target_db_name.bak

> 3. Copy or move `target_db_name``.bak` to the source machine using FTP or RCP. Be sure to use binary transfer.

> 4. Disable Fathom Replication for the source database from the source database directory using the following command:

>     PROUTIL source_db_name -C disablesitereplication source

> 5. Restore the source database from the target database backup in the source database directory using the following command:

>     PROREST source_db_name target_db_name.bak

> The structure file that existed prior to transition will be used by `PROREST`, so the physical structure of the newly restored source database matches the structure file from the restore. If `PROREST` does not find a structure file, the structure of the newly restored source database will not match what it was before the restore.

> For more details about backup and recovery strategies, see the Progress Database Administration Guide and Reference .

> 6. Enable after imaging on the source database from the source database directory using the following command:

>     RFUTIL source_db_name -C aimage begin

> 7. Enable the source database for Fathom Replication in the source database directory using the following command:

>     PROUTIL source_db_name -C enablesitereplication source

> 8. Delete the file `source_db_name`.`repl.recovery`.

> 9. Enable the target database for Fathom Replication in the target database directory using the following command:

>     PROUTIL target_db_name -C enablesiterepliation target

> 10. Delete the file `target_db_name` .`repl.recovery`.

> The source machine now has the source database, and the target database has been re-enabled. Fathom Replication can again be used on both databases. To start Fathom Replication, see the "Fathom Replication startup and initialization process" section.

> ##### Re-enabling a second target database

> If you have a second target database that was not designated as the transition database, you can re-enable Fathom Replication for the second target database.

> To re-enable Fathom Replication for the second target database directory:

> 1. Disable Fathom Replication for the second target database using the following command:

>     PROUTIL target2_db_name -C disablesitereplication target

> 2. Restore the second target database from the target database using the following command:

>     PROREST target2_db_name target_db_name.bak

> The structure file that existed prior to transition will be used by `PROREST`, so the physical structure of the newly restored source database matches the structure file from the restore. If `PROREST` does not find a structure file, the structure of the newly restored source database will not match what it was before the restore. For more details about backup and recovery strategies, see the Progress Database Administration Guide and Reference .

> Enable the second target database for Fathom Replication using the following command:

>     PROUTIL target2_db_name -C enablesiterepliation target

> 3. Delete the file `target2_db_name``.repl.recovery`.

> The source machine now has the source database, and the target databases have been re-enabled. Fathom Replication can again be used on the three databases. To start Fathom Replication, see the "Fathom Replication startup and initialization process" section for more details.

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