Re: archiving strategies with OnLine 5

> From: cmattern@mindspring.com > Date: 16 Jun 1995 04:14:53 GMT > > [...other stuff deleted...] > > Am I missing something? What are the arguments in favor of Level-1 and > Level-2 archives, versus piling up the logical log backups? > > I would argue against incremental backups in all but the most > controlled environments. I have seen too many problems due to one > tape being bad or misplaced. (I'm sure to get some reation from this > stance...) > ------------------------------------------------------------------------------ > |Chuck Mattern | "That which does not kill us, makes us stronger.." > |cmattern@mindspring.com | -Friedrich Nietzsche- | > ------------------------------------------------------------------------------ Ditto. We find it too easy to do level 0 backups, even on our large databases, to justify the hassle of keeping up with all those incremental things. The old SE databases, with no OnLine archiving, were different, but now that we can archive while users do their thing I just do the whole enchilada during a low-use time of day. We are running ~20 instances of OnLine in a 24x7 operation, with very reliable hardware, and we are pretty happy with this scheme. __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|