RE: Error Bringing Online 7.31 Up - Please Help
Try starting with the undocumented Informix option:
oninit -D
It will start without "memory", just in Online mode.
If it does not work, try starting in quiescent mode:
oninit -sy
Then, execute
onmode -suyThis command will end all attached user sessions, rolling back any
uncommitted transactions.
(leaving the server in quiescent mode)
Force a checkpoint
onmode -cAt this point, there should be no attached users, no opened transactions, no
dirty pages ... absolutely nothing in the physical log. Do not start any
processes that alter the instance in anyway (e.g. onspaces, onparams,
archive (e.g., ontape, onbar))
Bring your engine completely off-line
onmode -ky;
And try to start again....
If you cannot even start in quiescent mode,
try start the quiescent mode with the option "-p"
It will not reclaim any temporal table left on disk
Regards,
Javier
_________________________________
Javier Garza
Software Engineer
MARCONI Communications
Dun Laoghaire - Dublin
IRELAND
javier.garza@marconi.com
www.marconi.com
> -----Original Message-----
> From: Mark Griebling [mailto:mgriebling@webswift.com]
> Sent: 23 October 2000 17:17
> To: Garza, Javier; informix-list@iiug.org
> Subject: RE: Error Bringing Online 7.31 Up - Please Help
>
>
> Hi Javier,
>
> Unfortunately that's not an option. This server basically
> has data from other
> servers as convenient local storage (for a WEB site). I
> unloaded the tables
> that were specific to this server before the upgrade but
> that's only a small
> subset of the entire database.
>
> I was hoping there was some simple option of oninit or
> something that might
> clear the error. If no simple solution exists I'd like to
> know that too so I
> can start the 3 hours of data loading I would have to do
> after creating a new
> database.
>
> Any other ideas?
>
> Later,
>
> Mark
>
>
> At 11:50 AM 10/23/00 -0400, Garza, Javier wrote:
> A drastic solution is recover from a backup.
>
> Javier
>
>
> > -----Original Message-----
> > From: Mark Griebling [mailto:mgriebling@webswift.com]
> > Sent: 23 October 2000 14:00
> > To: informix-list@iiug.org
> > Subject: Error Bringing Online 7.31 Up - Please Help
> >
> >
> > Hello All,
> >
> > After upgrading our NT version of Online 7.21 to 7.31.TC5 I
> > get the following
> > error when trying to bring the engine online. Does anyone
> > know how to rectify
> > this error condition?
> >
> > Mon Oct 23 07:58:23 2000
> >
> > 07:58:23 DR: DRAUTO is 0 (Off)
> > 07:58:24 Informix Dynamic Server Version 7.31.TC5> > Software Serial Number
> > 07:58:26 Informix Dynamic Server Initialized -- Shared> > Memory Initialized.
> > 07:58:26 Physical Recovery Started.
> > 07:58:26 Physical Recovery Complete: 0 Pages Restored.
> > 07:58:26 Logical Recovery Started.
> > 07:58:26 Open transaction detected when changing log versions.
> > 07:58:28 Cannot Rollforward from Checkpoint.
> > 07:58:29 Informix Dynamic Server Stopped.
> > 07:58:33 mt_shm_remove: WARNING: may not have removed> > all/correct segments
> >
> > Thanks in advance for any help.
> >
> > Later,
> >
> > Mark
> >
>