Re: Recovery time with Online 5.x ??

> Earlier this evening, one of our programmers suffered a rather > spectacularexception while testing a new application. Needless to say, > it dumpedcore and aborted the engine. > > I started it up again with tbmonitor, and it recovered, BUT it stayed in > 'Recovering, please wait {dot dot dot}' mode for almost four hours. > > I thought this was somewhat unusual, since a level-0 archive was done > about12 hours before. > > What is the usual recovery time when starting after a dirty halt of the > engine ?? > > Thanks Good day JSW You don't say whether you actually got out of the recovering phase. Did it come out after 4 hours? I would suspect that it didn't! It looks to me as if you could have had a VERY LONG transaction. Normal recovery time should be less than a few minutes but an unfinsihed long transaction could take some time to rollback. Malcolm Weallans Online Database Consultancy Phone (+44)1628-72154 Fax (+44)1628-37463