Archive Schedules
The tb/ontape program provides a three-level archive schema. A full archive is a Level 0 archive, and it corresponds to an epoch level UNIX dump. Everything is dumped to tape. A Level 1 archive will back up any database pages that have changed since the last Level 0 archive. Likewise, a Level 2 archive will back up any changes since the last Level 1 archive.
In deciding on an archive schedule, the DBA needs to balance several factors. Obviously, if the DBA has two fast extended capacity tape drives available, he will handle the archives differently than he will if he is backing up to one smaller tape drive. How volatile is the data? Does it change often, or are some of the tables very large and relatively static? How valuable ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
