Physical and Logical Recovery (fwd)

According to Naomi Walker: > > The Informix log shows that OnLine was initialized, Physical recovery > started, and completed, restoring 648 pages. For six hours after > that, dots flew across the screen, over and over and over again. > It appeared to be reading, maybe something again and again. Logical > Recovery never completed. The engineer on site finally aborted the > logical recovery and restored via archives (owwwwww!). > > I remember when 4.0 had a problem in recovery when the logs were filled, > and it looked the same way. One time, Informix was able to patch > something it looked like there was nothing in the Logical logs, and the > system came back up. > If it's not the age old log problem, perhaps it is what we recently encountered. We were building (correction, attempting to build) an index on a very large table (no transactions in db - don't even think about that for an index build like this). For an unrelated reason, the machine crashed. Upon recovery, physical recovery was done quickly and logical (i.e. "*fast*") recovery took 20 hours. It turns out that this is a bug fixed under 4.10.UF (or UG or UH, not sure) regarding the way a create index rollback is handled. The reason I don't know the level is that we're 4.10.UD and are currently working on installing 5.0, so I've no compunction to get the upgraded 4.1 at this juncture -- might want to check with your Informix contact.. If it's not this nor the infamous, "sorry your logs are already full" problem, we haven't encountered it. Scott Ford, DBA | sford@wvus.org World Vision USA/ISD | elroy.jpl.nasa.gov!wvus!sford 919 W. Huntington Dr. | Voice: 818/357-1111 x3333 Monrovia, CA 91016 | FAX: 818/303-6212 "...The bozone layer: shielding the rest of the solar system from the earth's harmful effects...."