RE: Restore Informix software & Database to another server

In my personal opinion, why bother using ufsdump when you could restore with ontape. Don't forget that all chunk structures must be the same but that ontape & ufsdump might not read & write the same way, thus creating incompatibilities. There is gain in using ufsdump versus the potential problems just like the one you encountered. Andr' >From: St'phane Gadoury <stephane.gadoury@transat.com> >To: <informix-list@iiug.org> >Subject: RE: Restore Informix software & Database to another server >Date: Mon, 19 Jan 2004 09:54:50 -0500 > >Make sure you don't have any informix process still running..and grabbing >memory > >Verify with ipcs -m > >Also, verify your $ONCONFIG, so that you SHMBASE goes with the release >notes >( if should not impact, but you never know) > >If that still does not work, try reducing the SHMVIRTSIZE > >-----Message d'origine----- >De : owner-informix-list@iiug.org >[mailto:owner-informix-list@iiug.org]De la part de Paul Watson >Envoy' : 19 janvier, 2004 06:18 >' : informix-list@iiug.org >Objet : Re: Restore Informix software & Database to another server > > >Check the release note in $INFORMIXDIR/release/*/*/ or look in the >/etc/system on the working server > >KW Foo wrote: > > > > What should I check in the /etc/system ? > > > > Regards, > > KW Foo > > > > -- > > "Paul Watson" <paul@oninit.com> wrote in message > > news:400B9841.75DB2436@oninit.com... > > > Have you checked that the /etc/system on the second server is correct > > > > > > KW Foo wrote: > > > > > > > > We are trying to backup the server which includes the Informix 7.31 > > > > application and the data and restore to another server. > > > > > > > > We are running the Informix in SUN Solaris 2.6, backup the server >using > > > > "ufsdump" to the tape drive and restore using the "ufsrestore" to > > another > > > > server (with the same directory structure and hardware). > > > > > > > > We use "ufsdump" to backup the informix software and also all the > > Informix > > > > chunk directories after we shutdown the Informix using "onmode -ky". > > > > > > > > We also did an "ontape" level 0 backup to a tape. > > > > > > > > After we restore the application and the Informix chunk directory, >when > > we > > > > try to start the Informix engine using "oninit", the server go into > > "FAST > > > > RECOVERY" mode, after few minutes, it display message "oninit: Fatal > > error > > > > in shared memory initialization". > > > > > > > > The following are the message recorded in the online.log: > > > > > > > > 13:41:32 Informix Dynamic Server Initialized -- Shared Memory> > Initialized. > > > > 13:41:32 Physical Recovery Started. > > > > 13:45:16 Physical Recovery Complete: 84946 Pages Restored. > > > > 13:45:16 Logical Recovery Started. > > > > 13:45:16 shmget: [ENOMEM][12]: key 52564806: out of shared memory,> > check > > > > system > > > > max shared memory segment size > > > > 13:45:16 out of virtual shared memory > > > > > > > > 13:45:16 Cannot Rollforward from Checkpoint. > > > > 13:45:17 Informix Dynamic Server Stopped. > > > > 13:45:18 mt_shm_remove: WARNING: may not have removed all/correct> > segments > > > > > > > > After that, we check the "onstat -", and receive message "shared >memory > > not > > > > initialized for INFORMIXSERVER 'informix'". > > > > > > > > Is this the way to do it and how can I get the Informix engine up to > > restore > > > > from the "ontape" backup ? > > > > > > > > Regards, > > > > KW Foo > > > > > > -- > > > Paul Watson # > > > Oninit Ltd # Growing old is mandatory > > > Tel: +44 1436 672201 # Growing up is optional > > > Fax: +44 1436 678693 # > > > Mob: +44 7818 003457 # > > > www.oninit.com # > >-- >Paul Watson # >Oninit Ltd # Growing old is mandatory >Tel: +44 1436 672201 # Growing up is optional >Fax: +44 1436 678693 # >Mob: +44 7818 003457 # >www.oninit.com # > >sending to informix-list _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=dept/features&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca sending to informix-list

"Andr' D'ziel" <dansika@hotmail.com> wrote in message news:bui9qg$m49$1@terabinaries.xmission.com... > > In my personal opinion, why bother using ufsdump when you could restore with > ontape. Don't forget that all chunk structures must be the same but that > ontape & ufsdump might not read & write the same way, thus creating > incompatibilities. There is gain in using ufsdump versus the potential > problems just like the one you encountered. > > Andr' ... although it would seem that his problems are not actually related to the dump/restore of his chunks, but of his failure to do the same for some important non-Informix files. It ought to be an acceptable technique for a shut-down database housed entirely on cooked file, although like you I wouldn't do it that way, for reasons of speed for example. Not sure what you mean by "ontape & ufsdump might not read & write the same way, thus creating incompatibilities."