SUCCESS!!!!
Thanks to all who replied, I had several issues get me on this.
The missing /etc/services entry as pointed out earlier and then the underlying raw devices of the links. Again the sysadmin told me he mirrored the production box on the backup box and was about 99% correct. The devices were all defined, the correct size, but didn't have correct ownership/read-write attributes.
I now know that our backups are useful for restoration and have experience doing it.
Next up, HDR to the backup box:)
Thanks again,
Randy
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Walter Lowich
Sent: Tuesday, March 11, 2008 12:33 PM
To: ids@iiug.org
Subject: RE: Trying to restore a level 0 backup to a di.... [11577]
Check the permissions and ownership of the underlying raw devices. You may have to wade thru multiple levels of links, but it is the raw devices you have to modify. Thee permission must be rw-rw---- for each device and the owner and group must be informix.
"Kennedy, Randy" <RKennedy@scottsdaleaz.gov> wrote:
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 from module <>
09:47:14 Loading Module
09:47:14 Booting Language from module <>
09:47:14 Loading Module
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.
*******************************************************************************
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!!
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
