Ok, I will try to explain what I did and where I stand.
Both systems are identical hardware. I will call the production system that the backup was taken from PROD and the new system that I am trying to restore it to BAK.
On Prod, the settings are:
Servername - courtshm
Onconfig - onconfig.courtshm
Everything works just fine.
On BAK, the system was supposed to be a mirror of PROD (and it was for the most part, /etc/services entry withstanding)
The chunks are raw devices referenced as links, the links are identical on both systems.
I modified the onconfig file as follows (before attempting restore)
Changed the name to onconfig.courtsbak
changed servername to courtsbak
I modified env variables for informixserver and onconfig to reference courtsbak & onconfig.courtsbak.
I modified sqlhosts to reference courtsbak name
I left the tapedev the same so it would point to the backup 'file' created by ontape from PROD
Executed 'ontape -r' (a 2nd time after adding the sqlexec entry to /etc/services)
Received the "oninit: Fatal error in shared memory creation" error as I posted last night. Went home and left it.
This morning, the prompt returned so I did an 'onstat -' to see where I was.
It showed block checkpoint, so I shut down server, changed tapedev to /dev/null and did the oninit and get the following:
=>oninit
oninit: Cannot open chunk '/db/links/llogdbs'. errno = 2
oninit: Cannot open chunk '/db/links/casedbs'. errno = 2
oninit: Cannot open chunk '/db/links/physdbs'. errno = 2
oninit: Cannot open chunk '/db/links/tempdbs1'. errno = 2
oninit: Cannot open chunk '/db/links/tempdbs2'. errno = 2
oninit: Cannot open chunk '/db/links/tempdbs3'. errno = 2
oninit: Cannot open chunk '/db/links/tempdbs4'. errno = 2
oninit: Cannot open chunk '/db/links/chrgdbs'. errno = 2
oninit: Cannot open chunk '/db/links/dwdbs'. errno = 2
oninit: Cannot open chunk '/db/links/clndrdbs'. errno = 2
oninit: Cannot open chunk '/db/links/ctntndbs'. errno = 2
oninit: Cannot open chunk '/db/links/eventdbs'. errno = 2
oninit: Cannot open chunk '/db/links/masterdbs'. errno = 2
oninit: Cannot open chunk '/db/links/peopledbs'. errno = 2
oninit: Cannot open chunk '/db/links/1gbdbs3'. errno = 2
oninit: Cannot open chunk '/db/links/smat2dbs1'. errno = 2
oninit: Cannot open chunk '/db/links/awdbs'. errno = 2
oninit: Cannot open chunk '/db/links/rcptmstrdbs'. errno = 2
oninit: Cannot open chunk '/db/links/1gbdbs1'. errno = 2
oninit: Cannot open chunk '/db/links/eventdbs2'. errno = 2
oninit: Cannot open chunk '/db/links/sccdbs'. errno = 2
oninit: Cannot open chunk '/db/links/1gbdbs2'. errno = 2
oninit: Cannot open chunk '/db/links/testdbs'. errno = 2
Can Not Open Primary Chunk /db/links/llogdbs
oninit: Fatal error in shared memory initialization
Here is the log file:
Tue Mar 11 09:47:14 2008
09:47:14 Event alarms enabled. ALARMPROG = '/db/scripts/no_log.sh'
09:47:14 Booting Language <c> from module <>
09:47:14 Loading Module <CNULL>
09:47:14 Booting Language <builtin> from module <>
09:47:14 Loading Module <BUILTINNULL>
09:47:23 IBM Informix Dynamic Server Version 9.40.FC3 Software Serial Number AAA#B000000
09:47:23 Assert Warning: chunk failed sanity check
09:47:23 IBM Informix Dynamic Server Version 9.40.FC3
09:47:23 Who: Session(1, informix@hp9ux2, 0, c000000015785028)
Thread(31, main_loop(), c000000015743028, 1)
File: rspartn.c Line: 7733
09:47:23 Results: Chunk 2 is being taken OFFLINE.
09:47:23 Action: Restore chunk from archive.
09:47:23 stack trace for pid 29728 written to /tmp/af.407b79a
09:47:23 See Also: /tmp/af.407b79a
09:47:24 chunk failed sanity check
09:47:24 I/O error, Primary Chunk '/db/links/llogdbs' -- Offline (sanity)
09:47:24 Assert Warning: chunk failed sanity check
09:47:24 IBM Informix Dynamic Server Version 9.40.FC3
09:47:24 Who: Session(1, informix@hp9ux2, 0, c000000015785028)
Thread(31, main_loop(), c000000015743028, 1)
File: rspartn.c Line: 7733
09:47:24 Results: Chunk 3 is being taken OFFLINE.
09:47:24 Action: Restore chunk from archive.
09:47:24 stack trace for pid 29728 written to /tmp/af.407b79a
09:47:24 See Also: /tmp/af.407b79a
09:47:25 chunk failed sanity check
09:47:24 I/O error, Primary Chunk '/db/links/llogdbs' -- Offline (sanity)
09:47:24 Assert Warning: chunk failed sanity check
09:47:24 IBM Informix Dynamic Server Version 9.40.FC3
09:47:24 Who: Session(1, informix@hp9ux2, 0, c000000015785028)
Thread(31, main_loop(), c000000015743028, 1)
File: rspartn.c Line: 7733
09:47:24 Results: Chunk 3 is being taken OFFLINE.
09:47:24 Action: Restore chunk from archive.
09:47:24 stack trace for pid 29728 written to /tmp/af.407b79a
09:47:24 See Also: /tmp/af.407b79a
09:47:25 chunk failed sanity check
09:47:25 I/O error, Primary Chunk '/db/links/casedbs' -- Offline (sanity)
09:47:25 Assert Warning: chunk failed sanity check
-----repeats for every chunk----------
09:47:47 mt_shm_remove: WARNING: may not have removed all/correct segments
What am I missing/doing wrong??
Thanks,
Randy
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Martin Fuerderer
Sent: Tuesday, March 11, 2008 3:00 AM
To: ids@iiug.org
Subject: RE: Trying to restore a level 0 backup to a di.... [11572]
Hi,
with the instances being on different machines this is not a strict requirement.
However, it might be good practice to have a clear one-to-one correlation of the onconfig file to the IDS instance. One way of doing that is by naming the onconfig file with the instance's server name - in which case you would actually want to change the name of the onconfig file. And then you'd have to change the setting of the ONCONFIG environment variable as well ... :)
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany Information Management
IBM Deutschland Entwicklung GmbH
Chairman of the Supervisory Board: Martin Jetter Board of Management: Herbert Kircher Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294
ids-bounces@iiug.org wrote on 11.03.2008 09:58:41:
> Hi Martin,
>
> I think you have to change the name of the onconfig file, also.
>
> Regards
> Knuth
>
> On Tue, 2008-03-11 at 04:38 -0400, Martin Fuerderer wrote:
> > Hi,
> >
> > a) when changing the name of the server, also change the environment
> > variable INFORMIXSERVER accordingly. (There are 3 places: the
> > environment variable, the entry in onconfig file and the entry in
> > sqlhosts
> > file.)
> >
> > b) check the message log (see MSGPATH in your onconfig file).
> > It may contain useful information to determine the cause of the
> > problem.
> >
> > Regards,
> > Martin
> > --
> > Martin Fuerderer
> > IBM Informix Development Munich, Germany Information Management
> >
> > IBM Deutschland Entwicklung GmbH
> > Chairman of the Supervisory Board: Martin Jetter Board of
> > Management: Herbert Kircher Corporate Seat: Boeblingen, Germany
> > Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294
> >
> > ids-bounces@iiug.org wrote on 10.03.2008 23:11:22:
> >
> > > So much for it being an identical configuration as I was told by
> > > the
> > > sysadmin who prepared it:)
> > >
> > > The sqlexec entry was indeed missing from /etc/services.
> > >
> > > I added it and tried to rerun ontape -r and got this message (and
the
> > > prompt didn't return):
> > >
> > > oninit: Fatal error in shared memory creation
> > >
> > > Some one else stated to look at $INFORMIXDIR/etc/sqlhosts. On the
> > > system that the backup was created on is courtshm and I changed
> > > that
to
> > > courtbak on the system I am trying to restore it to. This matches
the
> > > name I changed servername to in onconfig to avoid the duplicate
> > > when
> > > restored.
> > >
> > > Thanks,
> > > Randy
> > >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
Of
> > > Art S. Kagel (Oninit)
> > > Sent: Monday, March 10, 2008 1:43 PM
> > > To: ids@iiug.org
> > > Subject: Re: Trying to restore a level 0 backup to a di....
> > > [11560]
> > >
> > > Kennedy, Randy wrote:
> > > > Server: HP/UX 11.11
> > > > Informix: 9.4FC3
> > > >
> > > > We are attempting to 'test' our backup solution and received the
> > > > following error when doing an 'ontape -r' on the backup server.
> > > > Physical restore failed - could not fork server connection,
SQLCODE
> > > > -931
> > > >
> > > > We have the tapedev configured as a file on a remote server
> > > > (/remote/recovery/informix/level0) on both servers.
> > > > The hardware and chunk links are identical on both servers.
> > > > The onconfig & host has different server names so when I bring
> > > > up
the
> > > > backup (if I can restore the backup), they won't have same names.
> > > > It is a single instance with 24 dbspaces & 7 non system databases.
> > > > The backups have run without a problem for a couple of years and
have
> > > > never needed to test recovery (and didn't have the downtime to
really
> > > > try). Now we have this identical server and want to ensure our
backup
> > > > solution actually works. Still not sure:)
> > > >
> > > > I have read through the Backup & Restore guide several times for
> > > > Ontape restores and it doesn't say a whole lot, run ontape -r
> > > > and
you
> > > > should be good to go.
> > > >
> > > > I pressed enter at the mount tape prompt, entered yes to
> > > > continue
at
> > > > next prompt, no to backup logs on disk, it ran for about 30
minutes
> > > > then I noticed the error message. Below is the complete attempt.
Any
> > > > help would be greatly appreciated.
> > >
> > > This is the clue:
> > > > Physical restore failed - could not fork server connection,
SQLCODE
> > > > -931
> > > >
> > >
> > > Finderr -931 would report that the servicename for the server in
> > > the
> > > sqlhosts file is not found in /etc/services.
> > >
> > > Art S. Kagel
> > > Oninit
> > >
> > >
========================================================================
> >
> > > ===================
> > > Please access the attached hyperlink for an important electronic
> > > communications disclaimer:
> > >
> > > http://www.oninit.com/home/disclaimer.php
> > >
> > >
========================================================================
> >
> > > ===================
> > >
> > >
************************************************************************
> >
> > > *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > > See you at the IIUG Informix 2008 Conference The Power Conference
> > > for Informix Professionals April 27 - 30, 2008 Marriott Overland
> > > Park (Kansas City), Kansas http://www.iiug.org/conf Registration
> > > Now Open!!
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > > See you at the IIUG Informix 2008 Conference The Power Conference
> > > for Informix Professionals April 27 - 30, 2008 Marriott Overland
> > > Park (Kansas City), Kansas http://www.iiug.org/conf Registration
> > > Now Open!!
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > See you at the IIUG Informix 2008 Conference The Power Conference
> > for Informix Professionals April 27 - 30, 2008 Marriott Overland
> > Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now
> > Open!!
>
> Knuth Hartlieb
> IMPIRE AG
> "AGROB-Medienpark" Geb. 5
> Münchener Straße 101B
> D-85737 Ismaning
>
> Phone: +49 (0) 89-4 52 25-4 61
> Fax: +49 (0) 89-4 52 25-2 90
> Mobil: +49 (0) 1 72-4 38 35 00
> E-mail: knuth.hartlieb@impire.de
> Skype: kjhartlieb
> ITToolbox: kjhartlieb
>
> Besuchen Sie uns unter
>
> www.impire.de & www.bundesliga-datenbank.de
>
> IMPIRE AG: Sitz: D-85737 Ismaning, Amtsgericht München HR B 152 835;
> Vorstand: Hartmut Braun (Vorsitzender), Harald Keilbach;
> Aufsichtsratsvorsitzender: Bernd Künzler
>
> CAIROS technologies AG; Sitz: 76307 Karlsbad, Amtsgericht Mannheim HRB
> 362651; Vorstand: Hartmut Braun (Vorsitzender), Christian Holzer;
> Aufsichtsratsvorsitzender: Roland Schmider
>
> Die in dieser E-Mail beinhaltete Information oder Anlagen zu dieser E-
> Mail (im Folgenden Mitteilung) können privilegiert, vertraulich oder
> nach dem Gesetz geheime Informationen enthalten. Sie sind
> ausschließlich
> für den genannten Empfänger bestimmt, an den sie gerichtet sind. Falls
> Sie nicht der genannte Empfänger oder einer seiner Angestellten oder
> Mitarbeiter sind, oder diese Mitteilung irrtümlich erhalten haben,
> bitten wir Sie, uns unverzüglich darüber in Kenntnis zu setzen und
> diese
> Mitteilung sowie alle bestehenden Kopien dieser Mitteilung zu
> vernichten. Wir weisen Sie darauf hin, dass das Lesen, Weiterleiten,
> Verbreiten oder Kopieren dieser Mitteilung ohne die Zustimmung des
> Absenders verboten ist.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference The Power Conference for
> Informix Professionals April 27 - 30, 2008 Marriott Overland Park
> (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
