Re: backup takes too long
Posted in 1997
>> I'm periodically hearing about how bad OnArchive is, but nobody has any definite reasons why. Because it's crap! :-) Specifically, it's rather flaky. I've never had any problems restoring with it, and do it every day to a contingency environment, but the two major problems I have are: (1) The catalog frequently gets out of step with what's actually on disk. This happens particularly when you've done a restore - the archive you've restored from is not registered in the catalog of the restored database! Ergo, when next you archive, an inconsistency is reported. (2) The continuous log back-up option is prone to crash when a logical log fills during an archive. The first problem is specific to disk dumping. I would suggest that this product has been "designed" for those of us who dump, and have always dumped, to disk. One of my surprises when joining the Informix community is the obsession that people seem to have with dumping to tape. This seems to be an out-of-date concept to me, unless of cousrse your databases are huge. Neil Truby Chase Manhattan Bournemouth, UK