Jeff Hartmann
New Member
We have a Progress 9.1e setup (Windows) that currently does a nightly online backup to disk that is then both written to tape and copied to our DR site overnight. The copy takes almost all night to complete and if we lost the main database we could possibly lose the last 24 hours of data. (I've got AI files, but those don't get copied to DR) I'm working on setting up a new server and as part of that I'm fixing this scenario.
I've setup the database with 8 variable AI extents and I'm working on some VBScripts to backup the AI extents by sequence number and then copy them over to the new server. I'm planing on having it switch and copy extents every 15 minutes or so.
The part that I'm not completely understanding is how to handle the full backup. Should I do a full backup every day, once a week, once a month? How often should I transfer the full backup to DR?
It sounds like if I did a full backup every day and archived 60 days worth of AI files, I could restore from any of the full backups in the last 60 days and roll-forward to current with my AI archives. So I could still do full backups to dump to tape every day and only copy the backup to DR once a month or so. Is that correct? If so, is that a good solution, or is there a better recommended approach?
I've also read that there is a point where I'll hit a limit on the sequence number. What's the best way to handle that? Start the AI sequence over again once a year or something?
The other thing I'm wondering about is restoring after a DR situation. Say we did have to go into DR mode and I brought up the DR database. Is it possible to take the AI files at DR and transfer those back to the main database when that server comes back online and roll-forward there?
I've setup the database with 8 variable AI extents and I'm working on some VBScripts to backup the AI extents by sequence number and then copy them over to the new server. I'm planing on having it switch and copy extents every 15 minutes or so.
The part that I'm not completely understanding is how to handle the full backup. Should I do a full backup every day, once a week, once a month? How often should I transfer the full backup to DR?
It sounds like if I did a full backup every day and archived 60 days worth of AI files, I could restore from any of the full backups in the last 60 days and roll-forward to current with my AI archives. So I could still do full backups to dump to tape every day and only copy the backup to DR once a month or so. Is that correct? If so, is that a good solution, or is there a better recommended approach?
I've also read that there is a point where I'll hit a limit on the sequence number. What's the best way to handle that? Start the AI sequence over again once a year or something?
The other thing I'm wondering about is restoring after a DR situation. Say we did have to go into DR mode and I brought up the DR database. Is it possible to take the AI files at DR and transfer those back to the main database when that server comes back online and roll-forward there?