Re: C-ISAM Corrupted Indexes (fwd)

Previously, I wrote: > > Generally, it's important to note that Informix-SE provides only a logical > log, whereas Online provides both logical and physical logs. As you point > out, the only sure way to recover from a crash with SE is to RECOVER > and ROLL FORWARD whereas Online Fast Recovery handles all that automatically. > In the real world, after a crash if there's nothing OBVIOUSLY wrong with > SE (even though undetected corruption may be present), the user is unlikely > to want to go through all the pain of recovery and rollforward (assuming he > isn't sending his logical logs to /dev/null in the first place). This can > lead to BIG recovery problems later, when the corruption is all over your > backups. I'd like to note that the kind of crash I refer to here is one in which the system goes down and then comes back up with hardware & media intact. Crashes where you lose a drive or a site permenantly are definitely NOT handled by Informix ONLINE fast recovery. To paraphrase a worthwhile comment I saw in this forum: THERE IS NO SUBSTITUTE FOR A SOUND DISASTER RECOVERY PLAN. ------------ DHL WORLDWIDE EXPRESS ------------------------------------------- Greg Bryan gbryan@ssf-sys.dhl.com DHL Systems Data Administrator uunet!ssf-sys.dhl.com!gbryan San Francisco -------------------------------------------------------------------------------