lost database after restart
A new IDS 10 user on Red Hat 4 restarted with 'onmode -ky' then 'oninit -iv' and found his database gone. Replies explained that -i re-initialises disk space, wiping rootdbs and all user databases; it should only ever be used on the very first setup, with plain 'oninit' (or 'oninit -v') for normal restarts. The lost data is unrecoverable without an ontape/onbar restore, so he must recreate it. Posters also suggested wrapping/renaming oninit to block accidental '-i', and one shared a ksh wrapper script that refuses -i (and -y) unless '-I' is used.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi
I have just installed my 1st informix server under Linux Redhat Enterprise 4.
The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
I´ve restarted the server with: onmode -ky (to stop the server) and then
oninit -iv (to start)
The problem is that now I can´t see a database that I created before
restarting the server. How can I see this database?
Thnaks in advance
Regards
Do NOT use -i option after ste first initialisation. This option will recreate
rootdbs and all data will be lost.
Just start your database using "oninit" or "oninit -v".
Good luck,
gerd
> Hi
>
> I have just installed my 1st informix server under Linux Redhat Enterprise 4.
> The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
>
> I´ve restarted the server with: onmode -ky (to stop the server) and then
> oninit -iv (to start)>
> The problem is that now I can´t see a database that I created before
> restarting the server. How can I see this database?
>
> Thnaks in advance
> Regards
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
_______________________________________________________________________
Viren-Scan für Ihren PC! Jetzt für jeden. Sofort, online und kostenlos.
Gleich testen! http://www.pc-sicherheit.web.de/freescan/?mc=022222
The problem is that you are initializing the instance every time you start it.
Oninit -i must be executed only the first time, subsequent restarts must be
done using onmode -yk and either oninit or oninit -v for startup. The -v to
see what is doing during startup.
Regards
Kenneth Penza
Technical Services Officer
Systems and Database Services
Service Management Department
Malta Information Technology & Training Services Ltd
Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
P
Please consider your environmental responsibility before printing this e-mail.
END OF TEXT
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
GUILLERMO PENAGOS
Sent: 22 February 2007 11:57
To: ids@iiug.org
Subject: lost database after restart [8469]
Hi
I have just installed my 1st informix server under Linux Redhat Enterprise 4.
The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
I´ve restarted the server with: onmode -ky (to stop the server) and then
oninit -iv (to start)
The problem is that now I can´t see a database that I created before
restarting the server. How can I see this database?
Thnaks in advance
Regards
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Yip quite correct. oninit -I initialises your whole instance
and will therefor wipe any user created databases.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Penza Kenneth at MITTS
> Sent: 22 February 2007 13:07
> To: ids@iiug.org
> Subject: RE: lost database after restart [8471]
>
> The problem is that you are initializing the instance every
> time you start it.
> Oninit -i must be executed only the first time, subsequent
> restarts must be
> done using onmode -yk and either oninit or oninit -v for
> startup. The -v to
> see what is doing during startup.
>
> Regards
> Kenneth Penza
> Technical Services Officer
> Systems and Database Services
> Service Management Department
> Malta Information Technology & Training Services Ltd
>
> Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
>
> P
> Please consider your environmental responsibility before
> printing this e-mail.
> END OF TEXT
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> GUILLERMO PENAGOS
> Sent: 22 February 2007 11:57
> To: ids@iiug.org
> Subject: lost database after restart [8469]
>
> Hi
>
> I have just installed my 1st informix server under Linux
> Redhat Enterprise 4.
> The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
>
> I´ve restarted the server with: onmode -ky (to stop the
> server) and then
> oninit -iv (to start)>
> The problem is that now I can´t see a database that I created before
> restarting the server. How can I see this database?
>
> Thnaks in advance
> Regards
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
GUILLERMO PENAGOS said:
> oninit -iv (to start)
Hahahahahahahahahahahahahahahaha!!!!!
Sorry, am I allowed to say RTFM?
--
Bye now,
Obnoxio
"I'm astonished anyone pays real money for this crap."
-- Cosmo
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
Sorry typo. Meant to say "oninit -i"
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Erhard Eiselen
> Sent: 22 February 2007 13:14
> To: ids@iiug.org
> Subject: RE: lost database after restart [8472]
>
> Yip quite correct. oninit -I initialises your whole instance
> and will therefor wipe any user created databases.
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> > Behalf Of Penza Kenneth at MITTS
> > Sent: 22 February 2007 13:07
> > To: ids@iiug.org
> > Subject: RE: lost database after restart [8471]
> >
> > The problem is that you are initializing the instance every
> > time you start it.
> > Oninit -i must be executed only the first time, subsequent
> > restarts must be
> > done using onmode -yk and either oninit or oninit -v for
> > startup. The -v to
> > see what is doing during startup.
> >
> > Regards
> > Kenneth Penza
> > Technical Services Officer
> > Systems and Database Services
> > Service Management Department
> > Malta Information Technology & Training Services Ltd
> >
> > Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
> >
> > P
> > Please consider your environmental responsibility before
> > printing this e-mail.
> > END OF TEXT
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of
> > GUILLERMO PENAGOS
> > Sent: 22 February 2007 11:57
> > To: ids@iiug.org
> > Subject: lost database after restart [8469]
> >
> > Hi
> >
> > I have just installed my 1st informix server under Linux
> > Redhat Enterprise 4.
> > The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
> >
> > I´ve restarted the server with: onmode -ky (to stop the
> > server) and then
> > oninit -iv (to start)> >
> > The problem is that now I can´t see a database that I
> created before
> > restarting the server. How can I see this database?
> >
> > Thnaks in advance
> > Regards
> >
> >
> > **************************************************************
> > *****************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > **************************************************************
> > *****************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
The switch -i means "Initialize disk space and shared memory, leave in on-line
mode." Maybe you started with "-iy", then you have already answered "yes" to
the
question if you want to delete existing databases. So if you don't have a
backup
then it is just to do the job again.
Regards,
Rolf Wasteson
------- Original Message -------
Subject: lost database after restart [8469]
From: GUILLERMO PENAGOS (gpenagos@cic-sl.es)
To: ids@iiug.org
Sent: 2007-02-22 11:56
From: gpenagos@cic-sl.es
To: ids@iiug.org
Date: Thu, 22 Feb 2007 05:56:55 -0500
Reply-To: ids@iiug.org
Subject: lost database after restart [8469]
Content-Transfer-Encoding: Quoted-Printable
Message-Id: <20070222105655.148C4A0C9@perform.iiug.org>
---------------------------------------------------
Note: This message was written with the unsupported
character set 'unknown-8bit'. Some characters may have
been substituted.
---------------------------------------------------
Hi
I have just installed my 1st informix server under Linux Redhat Enterprise 4.
The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
I¿ve restarted the server with: onmode -ky (to stop the server) and then
oninit -iv (to start)
The problem is that now I can¿t see a database that I created before
restarting the server. How can I see this database?
Thnaks in advance
Regards
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
You have done what many people have done in the past, used "oninit -i" when
meaning to use "oninit".
While I was working at Informix (pre-IBM), many people called in with this
issue. You even had "pro" Informix DBAs calling in asking if there was "any
way on (insert favorite deity here)'s green earth" their instance could be
restored short of a ontape/onbar restore. The answer, sadly, is always no.
While there, I even entered in a "Feature Request" asking that the oninit
i be replaced with a build initialize. Other build arguments would
have generated the onparams commands and/or the onspaces commands needed to
rebuild your instance should the need ever arise. I am guessing it is
either still gathering dust or was deleted a long time ago.
It is really surprising that nobody (and that includes myself) has never
written a shell around the oninit command that would prohibit the use of the
"oninit -i" command. Maybe one day ...
Take care.
Clifton Bean
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
GUILLERMO PENAGOS
Sent: Thursday, February 22, 2007 4:57 AM
To: ids@iiug.org
Subject: lost database after restart [8469]
Hi
I have just installed my 1st informix server under Linux Redhat Enterprise
4.
The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
I´ve restarted the server with: onmode -ky (to stop the server) and then
oninit -iv (to start)
The problem is that now I can´t see a database that I created before
restarting the server. How can I see this database?
Thnaks in advance
Regards
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
I seem to remember assisting in just such a feature request mere week=
s ago.
The simplest thing to do is rename oninit and then make aliases for t=
he
common commands to that name, while not creating an alias for oninit =
-i.
j.
-----Original Message-----
=46rom: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf O=
f
Clifton Bean
Sent: Thursday, February 22, 2007 9:18 AM
To: ids@iiug.org
Subject: RE: lost database after restart [8477]
You have done what many people have done in the past, used "oninit -i=
" when
meaning to use "oninit".
While I was working at Informix (pre-IBM), many people called in with=
this
issue. You even had "pro" Informix DBAs calling in asking if there wa=
s "any
way on (insert favorite deity here)'s green earth" their instance cou=
ld be
restored short of a ontape/onbar restore. The answer, sadly, is alway=
s no.
While there, I even entered in a "Feature Request" asking that the =
=93oninit
=96i=94 be replaced with a =93build =96initialize=94. Other build arg=
uments would
have generated the onparams commands and/or the onspaces commands nee=
ded to
rebuild your instance should the need ever arise. I am guessing it is
either still gathering dust or was deleted a long time ago.
It is really surprising that nobody (and that includes myself) has ne=
ver
written a shell around the oninit command that would prohibit the use=
of the
"oninit -i" command. Maybe one day ...
Take care.
Clifton Bean
-----Original Message-----
=46rom: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf =
Of
GUILLERMO PENAGOS
Sent: Thursday, February 22, 2007 4:57 AM
To: ids@iiug.org
Subject: lost database after restart [8469]
Hi
I have just installed my 1st informix server under Linux Redhat Enter=
prise
4.
The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
I=B4ve restarted the server with: onmode -ky (to stop the server) and=
then
oninit -iv (to start)
The problem is that now I can=B4t see a database that I created befor=
e
restarting the server. How can I see this database?
Thnaks in advance
Regards
*********************************************************************=
*******
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*********************************************************************=
*******
***
Forum Note: Use "Reply" to post a response in the discussion forum.
I found a script a while back...heck maybe on the iiug website...
just getting old and cannot remember.
#!/bin/ksh
# I found an example like this somewhere,
# I wish I knew where so I could give credit where credit is due.
# I modified it some from that one..
# simple wrapper to prevent accidental running of oninit -iy
# mv /usr/informix/bin/oninit /usr/informix/bin/oninit.cmd
# cp this file to /usr/informix/bin/oninit
# set appropriate permissions for new file.
CMD=${0}.cmd
if [[ "$1" = -*i* ]] ; then
echo "WARNING! oninit -i will completely erase this instance!"
echo "If that's what you REALLY want to do, then re-run this"
echo "command using a capital '-I' instead. (e.g. oninit -I )."
exit
fi
if [[ "$1" = -*y* ]] ; then
echo "Please do not use the y flag when initializing the engine."
exit
fi
if [[ "$1" = -*I* ]] ; then
$CMD -i
exit
else
$CMD $*
fi
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Jack Parker
Sent: Thursday, February 22, 2007 6:36 PM
To: ids@iiug.org
Subject: RE: lost database after restart [8484]
I seem to remember assisting in just such a feature request mere week=
s ago.
The simplest thing to do is rename oninit and then make aliases for t=
he
common commands to that name, while not creating an alias for oninit =
-i.
j.
-----Original Message-----
=46rom: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf O=
f
Clifton Bean
Sent: Thursday, February 22, 2007 9:18 AM
To: ids@iiug.org
Subject: RE: lost database after restart [8477]
You have done what many people have done in the past, used "oninit -i=
" when
meaning to use "oninit".
While I was working at Informix (pre-IBM), many people called in with=
this
issue. You even had "pro" Informix DBAs calling in asking if there wa=
s "any
way on (insert favorite deity here)'s green earth" their instance cou=
ld be
restored short of a ontape/onbar restore. The answer, sadly, is alway=
s no.
While there, I even entered in a "Feature Request" asking that the =
=93oninit
=96i=94 be replaced with a =93build =96initialize=94. Other build arg=
uments would
have generated the onparams commands and/or the onspaces commands nee=
ded to
rebuild your instance should the need ever arise. I am guessing it is
either still gathering dust or was deleted a long time ago.
It is really surprising that nobody (and that includes myself) has ne=
ver
written a shell around the oninit command that would prohibit the use=
of the
"oninit -i" command. Maybe one day ...
Take care.
Clifton Bean
-----Original Message-----
=46rom: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf =
Of
GUILLERMO PENAGOS
Sent: Thursday, February 22, 2007 4:57 AM
To: ids@iiug.org
Subject: lost database after restart [8469]
Hi
I have just installed my 1st informix server under Linux Redhat Enter=
prise
4.
The Informix version is "Informix Dynamic Server 10.00.UC3R1TL"
I=B4ve restarted the server with: onmode -ky (to stop the server) and=
then
oninit -iv (to start)
The problem is that now I can=B4t see a database that I created befor=
e
restarting the server. How can I see this database?
Thnaks in advance
Regards
*********************************************************************=
*******
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*********************************************************************=
*******
***
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.