RE: Can't complete recovery following successful onbar restore

Have you run the following command "ipcs |grep informix". If after you run "oninit -yuk" to verify that the database is down and you see a file that looks similar to the following: s 137625608 00000000 --ra-ra---- root informix, have the system admin remove any and all the shared memory segments. This problem usually occurs when the database crashes. I believe the command that the system admin must run to remove the shared memory segments that are still allocated is: ipcsrm -s number value after the s. Rerun the command "ipcs |grep informix", the command should return no shared memory segments. Next step is to try and bring the engine on-line. Good luck. Barbara A. McCabe-Reed breed@sikorsky.com (203) 386-6431 -----Original Message----- From: Neil Truby [mailto:neil.truby@ardenta.com] Sent: Thursday, January 29, 2004 4:48 PM 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 SerialNumber 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 = : Noconnections 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 = : Noconnections are allowed in Dynamic Server quiescent mode. 21:09:48 IBM Informix Dynamic Server Initialized -- Shared MemoryInitialized. 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