We are in the process of establishing Fathom site replication between two remote sites.
The way this has been done in the past is to create one full offline Progress backup and one incremental backup of the source database. And while the source database is down transport the backups to the target server and restore the backups there. Then configure replication and start both databases in the right order. I don't have all the details since this is all done by our application provider.
The problem we are facing is the time it takes to backup and restore. We are using a USB 2 drive to transport the data. So it takes 10-12 hours. (NO - we don't have anything else at the moment)
My question is: Could we create a full offline backup of the database, start it up again, use it in production, (meanwhile we would transfer the full backup to the target site and restore.). And then, when the longer maintenance window arrives, shut the databases down again, make a final incremental backup, apply it, and establish the Fathom / site replication?
Another question, can you mix incremental offline and online backups?
(I was hoping we could make daily incrementals after the initial full backup. So that when crunch time comes, we would only have a small final incremental to apply).
We already have the databases replicating by means of copying/applying AI files every 15 minutes, doing weekly full online backups and daily incrementals.
RHEL 5.4 / Progress 10.2B03
TIA!
/Pinne
The way this has been done in the past is to create one full offline Progress backup and one incremental backup of the source database. And while the source database is down transport the backups to the target server and restore the backups there. Then configure replication and start both databases in the right order. I don't have all the details since this is all done by our application provider.
The problem we are facing is the time it takes to backup and restore. We are using a USB 2 drive to transport the data. So it takes 10-12 hours. (NO - we don't have anything else at the moment)
My question is: Could we create a full offline backup of the database, start it up again, use it in production, (meanwhile we would transfer the full backup to the target site and restore.). And then, when the longer maintenance window arrives, shut the databases down again, make a final incremental backup, apply it, and establish the Fathom / site replication?
Another question, can you mix incremental offline and online backups?
(I was hoping we could make daily incrementals after the initial full backup. So that when crunch time comes, we would only have a small final incremental to apply).
We already have the databases replicating by means of copying/applying AI files every 15 minutes, doing weekly full online backups and daily incrementals.
RHEL 5.4 / Progress 10.2B03
TIA!
/Pinne