Initalisation error
Posted in 1999
Topics: Storage & Space Management
> Can anyone help please?
> The informix/templog file (chunk) has been deleted by mistake. A level
> 0 restore was done but we cannot now bring informix online.
>
> INFORMIX-OnLine Version 7.13.UC7
>
> The following messages appear from onmonitor:-
>
> oninit: Fatal error in shared memory initialization
> INFORMIX-OnLine is still in INIT or RECOVERY mode.
>
> The online log looks like this:-
>
> Thu Jun 10 10:28:06 1999
>
> 10:28:06 DR: DRAUTO is 0 (Off)
> 10:28:06 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
> 10:28:07 Physical Recovery Started.
> 10:28:07 Physical Recovery Complete: 0 Pages Restored.
> 10:28:07 Logical Recovery Started.
> 10:28:07 dynamically allocated new shared memory segment (size
> 8388608)
>
> 10:28:11 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
>
> 10:28:11 INFORMIX-OnLine Stopped.
> 10:28:12 mt_shm_remove: WARNING: may not have removed all/correct> segments
>
> Thanks in advance.
Looks like you did a restore using ontape -r and said 'NO' to restore
logfiles. When the restore completed the engine was in Quiescent mode
and then you shut it down. If you do not restore logs you MUST bring
the engine to full ONLINE mode with 'onmode -m' before you can shut it
down or the restore will not be completed. Bringing the engine online
completes the fast recovery needed to clean up the log files which is
otherwise done as part of restoring logs.
Since you did not bring the engine online before shutting down you have
to do the restore all over again and this time bring it online before
shutting down. The fast recovery to bring it fully online MUST
complete before you issue the onmode -ky to shutdown or you will be in
the same boat again. So wait until onmonitor or onstat reports the
engine status as "OnLine" which is sometime very quick but
occassionally, with restores like this, can take several hours if there
was a large transaction in the logs on tape that must be rolled back.
Art S. Kagel
Phil Allen wrote:
>
> > Can anyone help please?
> > The informix/templog file (chunk) has been deleted by mistake. A level
> > 0 restore was done but we cannot now bring informix online.
> >
> > INFORMIX-OnLine Version 7.13.UC7
> >
> > The following messages appear from onmonitor:-
> >
> > oninit: Fatal error in shared memory initialization
> > INFORMIX-OnLine is still in INIT or RECOVERY mode.
> >
> > The online log looks like this:-
> >
> > Thu Jun 10 10:28:06 1999
> >
> > 10:28:06 DR: DRAUTO is 0 (Off)
> > 10:28:06 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
> > 10:28:07 Physical Recovery Started.
> > 10:28:07 Physical Recovery Complete: 0 Pages Restored.
> > 10:28:07 Logical Recovery Started.
> > 10:28:07 dynamically allocated new shared memory segment (size
> > 8388608)
> >
> > 10:28:11 Logical Recovery Complete.> > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
> >
> > 10:28:11 INFORMIX-OnLine Stopped.
> > 10:28:12 mt_shm_remove: WARNING: may not have removed all/correct> > segments
> >
> > Thanks in advance.