RE: Can't complete recovery following successful onbar restore

I have seen this a few times when I am doing multiple restores of live databases to a backup server. My solution has been to reboot the server and start again. The scripts I use delete all devices and volumes before it starts, so is always starting from a clean position. Easy to do on a test server. I have the luxury of being the only one to know when I screw Up :-) Colin Bull c.bull@videonetworks.com > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Neil Truby > Sent: 29 January 2004 21:48 > To: informix-list@iiug.org > Subject: Can't complete recovery following successful onbar restore > > > 9.40 FC2 on HP-UX 11.11: > > I've done a 12-hour whole database restore (onbar -r -w). > > At the end I got these messages: > > 20:39:15 Maximum server connections 0 > 20:39:15 Start Logical Recovery - Start Log 113124, End Log ? > 20:39:15 Starting Log Position - 113124 0x3abf018 > 20:39:15 Clearing the physical and logical logs has started > 20:41:06 Cleared 2548 MB of the physical and logical logs in> 111 seconds > 20:43:12 Suspending Logical Restore> > Nothing until I tried onmode -m, when I got > > 21:05:15 No logical log restore will be performed. > 21:05:15 A Logical Restore is active. > > 21:05:15 Cannot change to On-Line Mode. > 21:08:59 No logical log restore will be performed. > 21:08:59 A Logical Restore is active. > 21:08:59 Cannot change to On-Line Mode.> > Eventually I stopped then re-started the engine, but I get a > shared-memory > failure, though nothing discernibly useful from the logs: > > 21:09:09 IBM Informix Dynamic Server Stopped. > > 21:09:31 IBM Informix Dynamic Server Started. > 21:09:38 Segment locked: addr=0xc000000000478000, size=1080684544> > Thu Jan 29 21:09:40 2004 > > 21:09:40 Event alarms enabled. ALARMPROG = > '/opt/informix/9.21/etc/log_full.sh' > 21:09:40 Booting Language <c> from module <> > 21:09:40 Loading Module <CNULL> > 21:09:40 Booting Language <builtin> from module <> > 21:09:40 Loading Module <BUILTINNULL> > 21:09:44 IBM Informix Dynamic Server Version 9.40.FC2> Software Serial > Number AAA#B000000 > 21:09:44 HPUX Version B.11.11 -> Using flag/select style KAIO > 21:09:44 HP KAIO concurrent requests changed from 1000 to 2300 > 21:09:46 (6) connection rejected - no calls allowed for sqlexec > 21:09:46 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > > 21:09:47 (12) connection rejected - no calls allowed for sqlexec > 21:09:47 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > > 21:09:48 IBM Informix Dynamic Server Initialized -- Shared Memory> Initialized. > > 21:09:48 Physical Recovery Started at Page (2:35801). > 21:09:48 Physical Recovery Complete: 0 Pages Examined, 0> Pages Restored. > 21:09:48 Logical Recovery Started. > 21:09:48 10 recovery worker threads will be started. > 21:09:51 Logical Recovery has reached the transaction cleanup phase. > 21:09:51 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > Any ideas how I can get the engine on line? Probably Tech Support can > intervene, but it really shouldn't be this difficult ... > > thanks > Neil > > sending to informix-list