Re: AGAIN: Cannot start Online Engine

In article <Cnsn0L.GHG@informatik.uni-muenchen.de>, spitz@GANS1X.ana.med.uni-muenchen.de (Richard Spitz) says: > >Dear Online Gurus, > >I can read the backup tape without problems, but when I try to start up >the engine, I get an error, and the engine stays offline. The logfile >gives the following messages: > >Tue Apr 5 17:39:55 1994 > >17:39:55 INFORMIX-Online Initialized -- Shared Memory Initialized >17:39:55 Physical Recovery Started >17:39:55 Checkpoint Completed >17:39:55 Physical Recovery Complete: 0 Pages Restored >17:39:55 Checkpoint Record not Found in Logical Log >17:39:55 Cannot Rollforward from Checkpoint >17:39:55 INFORMIX-Online Stopped> >What is going on here? Please help, I am getting desperate! Do you have another archive tape. If so, try it. Do you have logical log backups for this archive. If so, try applying them. Otherwise, call Informix Technical Support and ask for "tbzero", denigrated elsewhere in this forum. It will cause Logical Recovery to be skipped for this recovery, and MAY (probably) cause some consistency checks in data and indexes that were being updated when the archive was taken. The good news is that if you are unloading all rows, the system will skip on past bad pages, and will not use the index. Your recovery cannot complete because Logical Recovery cannot find the last checkpoint record. This is a serious internal consistency error in the database as restored. >This is Online 4.10 on a Siemens-Nixdorf MX300-30 with SINIX 5.24. Platform doesn't matter for this problem. Jim Burks jburks@promus.com Database Administrator The Promus Companies Memphis, TN USA