RE: Physical restore failed

Hi Art, I have not heard from you, I went on to reboot the server, checked the chunks are owned by user Informix group Informix, and have at least 660 permissions, and restarted the restore process. I got ontape -r Please mount tape 1 on /backups/informix_bu and press Return to continue ... Archive Tape Information Tape type: Archive Backup Tape Online version: Informix Dynamic Server Version 7.31.UD6 Archive date: Wed May 5 03:00:02 2010 User id: root Terminal id: ? Archive level: 0 Tape device: /backups/informix_bu Tape blocksize (in k): 16 Tape size (in k): 12000000 Tape number in series: 1 Spaces to restore:1 [rootdbs ] 2 [tasablob ] 3 [tasa ] 4 [tasalog ] Archive Information Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc. Initialization Time 04/10/2003 10:10:35 System Page Size 2048 Version 6 Archive CheckPoint Time 05/05/2010 03:00:23 Dbspaces number flags fchunk nchunks flags owner name 1 1 1 1 N informix rootdbs 2 1 2 2 N informix tasa 3 2001 3 1 N T informix tasatemp 4 1 4 1 N informix tasalog 5 11 5 1 N B informix tasablob Chunks chk/dbs offset size free bpages flags pathname 1 1 0 26000 2913 PO- /dev/ifx/rootdbs 2 2 0 1000000 57 PO- /dev/ifx/tasa 3 3 0 1000000 999897 PO- /dev/ifx/tasatemp 4 4 0 1000000 999947 PO- /dev/ifx/tasalog 5 5 0 1000000 1000000 POB /dev/ifx/tasablob 6 2 0 1000000 843922 PO- /dev/ifx/tasa1 Continue restore? (y/n)y Do you want to back up the logs? (y/n)n Physical restore failed - function read archive backup failed code -2 errno 0 Please advicd. Wally Tang DOD-Defense Media Center - IT Lockheed Martin - IT 23755 Z Street Riverside, CA 92518-2017 951-413-2246 E-mail: wally.tang.ctr@dma.mil -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Tang, Wally, CTR, DMA-Riv/IT Sent: Tuesday, May 04, 2010 8:35 AM To: ids@iiug.org Subject: RE: Physical restore failed [19987] Thank you, Art. I would not know any of the supervisor tasks would kill off the ontape process. The average time from starting and completing the physical restore about 1 hour and 40 minutes, but in this failure, the time is about 1 hour and 18 minutes. I will run it with the time command to any different progress. Thanks again for your help. Wally Tang DOD-Defense Media Center - IT Lockheed Martin - IT 23755 Z Street Riverside, CA 92518-2017 951-413-2246 E-mail: wally.tang.ctr@dma.mil -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Tuesday, May 04, 2010 8:02 AM To: ids@iiug.org Subject: Re: Physical restore failed [19984] Is it possible that some supervisor task is killing off the ontape process because it's running too long? Or that the window ontape was running in was closed or the session otherwise logged out? Try running the ontape -r under 'time' (or 'timex' if you have that). The time utility uses the wait() system call to determine some of the runtime values and if a signal was sent to the child ontape task time should report that signal. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 4, 2010 at 9:47 AM, Tang, Wally, CTR, DMA-Riv/IT < Wally.Tang.CTR@dma.mil> wrote: > Oops, after the restore successfully ran and completed daily since > 4/28/2010, the restore failed again with > > Tue May 4 04:13:44 2010 > > 04:13:44 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' > 04:13:50 DR: DRAUTO is 0 (Off) > 04:13:50 Requested shared memory segment size rounded from 588KB to 592KB > 04:13:50 Informix Dynamic Server Version 7.31.UD5 Software Serial > Number AA > D#J358202 > 04:13:51 Informix Dynamic Server Initialized -- Shared Memory Initialized. > 04:13:51 Dynamically allocated new virtual shared memory segment (size > 8192KB) > 04:13:51 Dataskip is now OFF for all dbspaces > 04:13:51 Restartable Restore has been DISABLED > 04:13:51 Recovery Mode > 04:13:54 Physical Restore of rootdbs, tasablob, tasa, tasalog started. > > 04:13:59 Checkpoint Completed: duration was 0 seconds. > 04:13:59 Checkpoint loguniq 652, logpos 0x31018 > > 04:31:55 Checkpoint Completed: duration was 0 seconds. > 04:31:55 Checkpoint loguniq 652, logpos 0x31018 > > 05:49:18 Aborting physical restore of ROOT DBSpace > 05:49:18 Aborted by client. > 05:49:18 Informix Dynamic Server Stopped. > > Please advice. > > Wally Tang > DOD-Defense Media Center - IT > Lockheed Martin - IT > 23755 Z Street > Riverside, CA 92518-2017 > 951-413-2246 > E-mail: wally.tang.ctr@dma.mil > > -----Original Message----- > From: Tang, Wally, CTR, DMA-Riv/IT > Sent: Wednesday, April 28, 2010 6:17 AM > To: 'ids@iiug.org' > Subject: RE: Physical restore failed [19909] > > There is nothing that I could think of. > > Wally Tang > DOD-Defense Media Center - IT > Lockheed Martin - IT > 23755 Z Street > Riverside, CA 92518-2017 > 951-413-2246 > E-mail: wally.tang.ctr@dma.mil > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Keith > Simmons > Sent: Wednesday, April 28, 2010 12:33 AM > To: ids@iiug.org > Subject: Re: Physical restore failed [19909] > > So what has changed between then and now? What did you do different this > time > ? > > Keith > > On 27 April 2010 20:47, Tang, Wally, CTR, DMA-Riv/IT > <Wally.Tang.CTR@dma.mil> wrote: > > Good news; for some reason, I tried to restore once again. It is restored > > without any problem. I am going rerun the restore process again, is there > > any suggestion before I do it again. > > > > Thanks for all your help. > > > > Wally Tang > > DOD-Defense Media Center - IT > > Lockheed Martin - IT > > 23755 Z Street > > Riverside, CA 92518-2017 > > 951-413-2246 > > E-mail: wally.tang.ctr@dma.mil > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Everett Mills > > Sent: Tuesday, April 27, 2010 9:06 AM > > To: ids@iiug.org > > Subject: RE: Physical restore failed [19890] > > > > That's what I thought, but we're getting down to grasping at straws... > > > > If he was on a supported version, I'd suggest a support call. > > > > --EEM > > > >> -----Original Message----- > >> From: ids-bounces@iiug.org

Hello, I am new to this thread so I might not be getting the story straight, but I did not see an answer to the question regarding the difference in versions: the backup tape is saying it was a backup of: Online version: Informix Dynamic Server Version 7.31.UD6 but when you start the restore, this tape is attempting to be put on an Informix engine of a different version: > 04:13:50 Requested shared memory segment size rounded from 588KB to 592KB > 04:13:50 Informix Dynamic Server Version 7.31.UD5 Software Serial Number AAD#J358202 > 04:13:51 Informix Dynamic Server Initialized -- Shared Memory Initialized. ... > 04:13:51 Recovery Mode > 04:13:54 Physical Restore of rootdbs, tasablob, tasa, tasalog started. Also have you checked your unix configuration? Meaning has there been any change in the O/S config between the server that took the backup tape and the one that it is being restored to (i don't recall seeing that this backup tape is attempting to be restored to the same server the backup was taken on or a different one)? A different O/S config that is more restrictive than the O/S config of the server that took the backup tape could be limiting O/S resources and cutting you off. I apologize for asking what might be stupid questions, I have recently come back to the forums and just jumping into this thread. thanks, Norma Jean