Re: HELP !!! Recovery mode

andywen@my-dejanews.com offerred: +> and the system seems hung in Recovery, you may well be hosed. +> However, depending on the version you are running (a detail you failed to +> mention), you may not be in an uncorrectable state. + +I've been there before. Your logs are full, and there just isn't a way to +back up logical logs. Informix Tech Support has a way to fix this if they +have dial-in access, but sometimes it's just easier to restore the last +backup. Hope you do good backups. Sorry. I've been there too. Quite +irritating. As I mentioned in the previous post, this is only true if you have run into a "long transaction". If you simply negelected to back the logs up, you can recover it yourself. You just have to proceed as I described in the earlier post, starting the log backup as soon as online gets into on-line mode, before the next checkpoint can occur. If you do have a "long transaction" (logs are backed up but not freed because they contain records for a transaction that is still open), you will have to call Informix. ** Dave Kosenko davek@summitdata.com ** ** Director of Training Services (732) 469-4070 ** ** Summit Data Group (an Informix Authorized Education Center) ** ** Find my advise useful? Then take your Informix training at SDG ** ** see http://www.summitdata.com/training for details **