Physical and Logical Recovery
Posted in 1992
This is a little after the fact, but I have some questions about recovery, on a Pyramid MIS S server, running Online 4.1. I will pass on the details I have heard from the person on site. The system in question was running along fine, when everything hung. The logs were not full. Bouncing the application programs did not help, so it was decided to bounce Informix. 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. Can someone offer a guess as to what was actually occurring, and what we could have done to avoid going to the archive (without Informix patching)? -- Naomi Walker (aka N7FSA) naomi%anasaz.UUCP@asuvax.eas.asu.edu Enthusiasm is caught, In tennis, not taught. love means nothing.