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 [mailto:ids-bounces@iiug.org] On Behalf Of
>> Keith Simmons
>> Sent: Tuesday, April 27, 2010 10:49 AM
>> To: ids@iiug.org
>> Subject: Re: Physical restore failed [19889]
>>
>> I don't think the issue is with missing chunks, the restore wouldn't
>> even start if it
>> couldn't find all the space in which to restore, nor are any chunks
>> too small as,
>> again, the restorewill not try to start if it cannot find/create
>> chunks of the correct
>> size.
>> Is this restore on a freshly reboted server, or has it been running
>> for a period of
>> time? A clean reboot might help.
>> I don't we've seen your sqlhosts file, appropriate entries in
>> /etc/services
>> and
>> detail from onconfig.
>>
>> Keith
>>
>> On 27 April 2010 16:20, Everett Mills <Everett.Mills@nationalbeef.com>
>> wrote:
>> > OK, then. How about running onstat -d on your primary. That will tell
>> us if
>> > the restore is looking for a device it can't find.
>> >
>> > --EEM
>> >
>> >> -----Original Message-----
>> >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>> Of
>> >> Tang, Wally, CTR, DMA-Riv/IT
>> >> Sent: Tuesday, April 27, 2010 10:11 AM
>> >> To: ids@iiug.org
>> >> Subject: RE: Physical restore failed [19886]
>> >>
>> >> I looked at the syslog.log, there was no any error during the time
>> of
>> >> "aborted"
>> >>
>> >> 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
>> >> rroussey@comcast.net
>> >> Sent: Tuesday, April 27, 2010 7:27 AM
>> >> To: ids@iiug.org
>> >> Subject: Re: Physical restore failed [19882]
>> >>
>> >> Yeah, "aborted by client" is suspicious. Is there anything unusual
>> in
>> >> /var/adm/syslog/syslog.log file at the time it aborts? Any memory
>> >> errors on
>> >> the system?
>> >>
>> >> Bob
>> >>
>> >> ----- Original Message -----
>> >> From: "Everett Mills" <Everett.Mills@nationalbeef.com>
>> >> To: ids@iiug.org
>> >> Sent: Tuesday, April 27, 2010 10:05:17 AM GMT -05:00 US/Canada
>> Eastern
>> >> Subject: RE: Physical restore failed [19878]
>> >>
>> >> One thing I notice is that it runs for over an hour before it
>> crashes.
>> >> Is
>> >> the
>> >> device you're restoring to smaller than the one the backup was made
>> on?
>> >> Was
>> >> a
>> >> chunk added to the original and no device created to match it on the
>> >> new
>> >> one?
>> >> Not sure what "Aborted by client" means in this context. Ordinarily,
>> >> I'd
>> >> think
>> >> someone had hit ctrl-C or issued kill -9 against the ontape -r.
>> >>
>> >> --EEM
>> >>
>> >> > -----Original Message-----
>> >> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>> Of
>> >> > Roger Kee
>> >> > Sent: Tuesday, April 27, 2010 8:49 AM
>> >> > To: ids@iiug.org
>> >> > Subject: Re: Physical restore failed [19877]
>> >> >
>> >> > Wally,
>> >> >
>> >> > Do you have multiple installs of IDS on your server or are you
>> trying
>> >> > to
>> >> > restore to a different server
>> >> > than where this archive was taken? I see in the message log that
>> it
>> >> is
>> >> > using IDS 7.31.UD5, but
>> >> > the ontape header info says IDS 7.31.UD6. This may be your
>> problem.
>> >> >
>> >> > On Tue, Apr 27, 2010 at 9:40 AM, Tang, Wally, CTR, DMA-Riv/IT <
>> >> > Wally.Tang.CTR@dma.mil> wrote:
>> >> >
>> >> > > Thanks, Art. Below is the message from the log:
>> >> > >
>> >> > > Thu Apr 22 12:45:04 2010
>> >> > >
>> >> > > 12:45:04 Event alarms enabled. ALARMPROG =
>> >> > '/usr/informix/etc/log_full.sh'
>> >> > > 12:45:10 DR: DRAUTO is 0 (Off)
>> >> > > 12:45:10 Requested shared memory segment size rounded from 588KB
>> to
>> >> > 592KB
>> >> > > 12:45:10 Informix Dynamic Server Version 7.31.UD5 Software
>> Serial
>> >> > > Number AA
>> >> > > D#J358202
>> >> > > 12:45:11 Informix Dynamic Server Initialized -- Shared Memory
>> >> > Initialized.
>> >> > > 12:45:11 Dynamically allocated new virtual shared memory segment
>> >> > (size
>> >> > > 8192KB)
>> >> > > 12:45:11 Dataskip is now OFF for all dbspaces
>> >> > > 12:45:11 Restartable Restore has been DISABLED
>> >> > > 12:45:11 Recovery Mode
>> >> > > 12:45:15 Physical Restore of rootdbs, tasablob, tasa, tasalog
>> >> > started.
>> >> > >
>> >> > > 12:45:20 Checkpoint Completed: duration was 0 seconds.
>> >> > > 12:45:20 Checkpoint loguniq 647, logpos 0xa018
>> >> > >
>> >> > > 13:03:39 Checkpoint Completed: duration was 0 seconds.
>> >> > > 13:03:39 Checkpoint loguniq 647, logpos 0xa018
>> >> > >
>> >> > > 14:26:18 Aborting physical restore of ROOT DBSpace
>> >> > > 14:26:18 Aborted by client.
>> >> > > 14:26:18 Informix Dynamic Server Stopped.
>> >> > >
>> >> > > 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: Monday, April 26, 2010 8:12 PM
>> >> > > To: ids@iiug.org
>> >> > > Subject: Re: Physical restore failed [19858]
>> >> > >
>> >> > > Wait, I didn't notice this before. The ontape output says:
>> >> > >
>> >> > > > Physical restore failed - could not fork server connection
>> >> > >
>> >> > > That means the real problem is that it could not start up the
>> >> engine
>> >> > > instance after restoring the reserved pages so that the engine
>> >> could
>> >> > > complete the restore. This is usually a problem with some
>> parameter
>> >> > in the
>> >> > > ONCONFIG file or with the configuration of the server's sqlhosts
>> >> file
>> >> > > entries. What does the server message log say at the time the
>> >> engine
>> >> > tried
>> >> > > to start up last during the restore? The time of the restore
>> below
>> >> > was:
>> >> > > April 22 at 13:03
>> >> > >
>> >> > > 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 Mon, Apr 26, 2010 at 9:29 AM, Tang, Wally, CTR, DMA-Riv/IT <
>> >> > > Wally.Tang.CTR@dma.mil> wrote:
>> >> > >
>> >> > > > Good morning, Art,
>> >> > > >
>> >> > > > It is a file.
>> >> > > >
>> >> > > > 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: Friday, April 23, 2010 4:45 PM
>> >> > > > To: ids@iiug.org
>> >> > > > Subject: Re: Physical restore failed [19842]
>> >> > > >
>> >> > > > What is the backup device "/backups/informix_bu"? File? Tape?
>> >> Named
>> >> > > > pipe? What?
>> >> > > >
>> >> > > > 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 Fri, Apr 23, 2010 at 9:25 AM, Tang, Wally, CTR, DMA-Riv/IT
>> <
>> >> > > > Wally.Tang.CTR@dma.mil> wrote:
>> >> > > >
>> >> > > > > Good morning, Art,
>> >> > > > >
>> >> > > > > Output of ontape -r
>> >> > > > >
>> >> > > > > # 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 Apr 21 03:00:03 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 04/21/2010 03:00:42
>> >> > > > >
>> >> > > > > 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 845180 PO- /dev/ifx/tasa1
>> >> > > > >
>> >> > > > > Continue restore? (y/n)y
>> >> > > > > Do you want to back up the logs? (y/n)n
>> >> > > > >
>> >> > > > > Physical restore failed - could not fork server connection
>> >> > > > >
>> >> > > > > Physical restore failed - function read archive backup
>> failed
>> >> > code -2
>> >> > > > errno
>> >> > > > > 0
>> >> > > > >
>> >> > > > > Program over.
>> >> > > > >
>> >> > > > > # ls -l
>> >> > > > > total 0
>> >> > > > > crw-rw---- 1 informix informix 64 0x010000 Mar 20 2003 group
>> >> > > > > brw-rw---- 1 informix informix 64 0x010005 Apr 22 13:03
>> rootdbs
>> >> > > > > crw-rw---- 1 informix informix 64 0x010005 Mar 20 2003
>> rrootdbs
>> >> > > > > crw-rw---- 1 informix informix 64 0x010001 Mar 20 2003 rtasa
>> >> > > > > crw-r----- 1 informix informix 64 0x010006 Mar 27 2003
>> rtasa1
>> >> > > > > crw-rw---- 1 informix informix 64 0x010004 Mar 20 2003
>> >> rtasablob
>> >> > > > > crw-rw---- 1 informix informix 64 0x010003 Mar 20 2003
>> rtasalog
>> >> > > > > crw-rw---- 1 informix informix 64 0x010002 Mar 20 2003
>> >> rtasatemp
>> >> > > > > brw-rw---- 1 informix informix 64 0x010001 Apr 22 14:18 tasa
>> >> > > > > brw-rw---- 1 informix informix 64 0x010006 Apr 22 14:26
>> tasa1
>> >> > > > > brw-rw---- 1 informix informix 64 0x010004 Apr 22 13:03
>> >> tasablob
>> >> > > > > brw-rw---- 1 informix informix 64 0x010003 Apr 20 13:00
>> tasalog
>> >> > > > > brw-rw---- 1 informix informix 64 0x010002 Apr 20 13:02
>> >> tasatemp
>> >> > > > >
>> >> > > > > # ls -lL
>> >> > > > > total 0
>> >> > > > > crw-rw---- 1 informix informix 64 0x010000 Mar 20 2003 group
>> >> > > > > brw-rw---- 1 informix informix 64 0x010005 Apr 22 13:03
>> rootdbs
>> >> > > > > crw-rw---- 1 informix informix 64 0x010005 Mar 20 2003
>> rrootdbs
>> >> > > > > crw-rw---- 1 informix informix 64 0x010001 Mar 20 2003 rtasa
>> >> > > > > crw-r----- 1 informix informix 64 0x010006 Mar 27 2003
>> rtasa1
>> >> > > > > crw-rw---- 1 informix informix 64 0x010004 Mar 20 2003
>> >> rtasablob
>> >> > > > > crw-rw---- 1 informix informix 64 0x010003 Mar 20 2003
>> rtasalog
>> >> > > > > crw-rw---- 1 informix informix 64 0x010002 Mar 20 2003
>> >> rtasatemp
>> >> > > > > brw-rw---- 1 informix informix 64 0x010001 Apr 22 14:18 tasa
>> >> > > > > brw-rw---- 1 informix informix 64 0x010006 Apr 22 14:26
>> tasa1
>> >> > > > > brw-rw---- 1 informix informix 64 0x010004 Apr 22 13:03
>> >> tasablob
>> >> > > > > brw-rw---- 1 informix informix 64 0x010003 Apr 20 13:00
>> tasalog
>> >> > > > > brw-rw---- 1 informix informix 64 0x010002 Apr 20 13:02
>> >> tasatemp
>> >> > > > >
>> >> > > > > 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: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
>> >> > Behalf Of
>> >> > > > Art
>> >> > > > > Kagel
>> >> > > > > Sent: Thursday, April 22, 2010 3:19 PM
>> >> > > > > To: ids@iiug.org
>> >> > > > > Subject: Re: Physical restore failed [19798]
>> >> > > > >
>> >> > > > > Post the entire output from the ontape -r and ls -l and ls -
>> lL
>> >> > listings
>> >> > > > of
>> >> > > >
>> >> > > > > the chunk files.
>> >> > > > >
>> >> > > > > 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 Thu, Apr 22, 2010 at 5:28 PM, Tang, Wally, CTR, DMA-
>> Riv/IT <
>> >> > > > > Wally.Tang.CTR@dma.mil> wrote:
>> >> > > > >
>> >> > > > > > FYI, the older backup file got the same error:
>> >> > > > > >
>> >> > > > > > 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
>> >> > > > > >
>> >> > > > > > Program over.
>> >> > > > > >
>> >> > > > > > 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: Thursday, April 22, 2010 2:20 PM
>> >> > > > > > To: ids@iiug.org
>> >> > > > > > Subject: Re: Physical restore failed [19794]
>> >> > > > > >
>> >> > > > > > Not clear what you are asking. Did the second restore also
>> >> > fail? Did
>> >> > > > you
>> >> > > >
>> >> > > > > > try the newer archive set again or just fallback to the
>> older
>> >> > one?
>> >> > > Can
>> >> > >
>> >> > > > > you
>> >> > > > >
>> >> > > > > > roll forward your logical logs to get back to current?
>> >> > > > > >
>> >> > > > > > 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 Thu, Apr 22, 2010 at 4:48 PM, Tang, Wally, CTR, DMA-
>> Riv/IT
>> >> <
>> >> > > > > > Wally.Tang.CTR@dma.mil> wrote:
>> >> > > > > >
>> >> > > > > > > Thanks, Art. I verified all the chunks are owned by
>> >> Informix
>> >> > > Informix
>> >> > > > > and
>> >> > > > > > > have 660 permissions. I had copied the backups from the
>> >> last
>> >> > > > successful
>> >> > > > > > > restore and executed the restore process; hopefully, the
>> >> > backup
>> >> > > file
>> >> > >
>> >> > > > is
>> >> > > > > > > corrupted?
>> >> > > > > > >
>> >> > > > > > > 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: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]
>> On
>> >> > Behalf
>> >> > > > Of
>> >> > > > > > Art
>> >> > > > > > > Kagel
>> >> > > > > > > Sent: Thursday, April 22, 2010 1:40 PM
>> >> > > > > > > To: ids@iiug.org
>> >> > > > > > > Subject: Re: Physical restore failed [19792]
>> >> > > > > > >
>> >> > > > > > > Errno 2 is privileges on files. Check that all of the
>> >> chunks
>> >> > (the
>> >> > > > chunk
>> >> > > > > > > list should have printed out when you started the
>> restore)
>> >> > are
>> >> > > owned
>> >> > >
>> >> > > > by
>> >> > > > > > > user
>> >> > > > > > >
>> >> > > > > > > informix group informix and have 660 permissions. If you
>> >> fix
>> >> > that,
>> >> > > > try
>> >> > > >
>> >> > > > > > the
>> >> > > > > >
>> >> > > > > > > restore again.
>> >> > > > > > >
>> >> > > > > > > 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 Thu, Apr 22, 2010 at 4:32 PM, Tang, Wally, CTR, DMA-
>> >> Riv/IT
>> >> > <
>> >> > > > > > > Wally.Tang.CTR@dma.mil> wrote:
>> >> > > > > > >
>> >> > > > > > > > Needed help, we have IDS 7.31 on HPUX 11.0.
>> >> > > > > > > >
>> >> > > > > > > > We are currently encounter error message while
>> restoring
>> >> > our
>> >> > > > > production
>> >> > > > > > > > database:
>> >> > > > > > > >
>> >> > > > > > > > Physical restore failed - function read archive backup
>> >> > failed
>> >> > > code
>> >> > >
>> >> > > > -2
>> >> > > > > > > errno
>> >> > > > > > > > 0
>> >> > > > > > > >
>> >> > > > > > > > And when I viewed the online.log, it said
>> >> > > > > > > >
>> >> > > > > > > > 12:01:00 Aborting physical restore of ROOT DBSpace
>> >> > > > > > > >
>> >> > > > > > > > 12:01:00 Aborted by client.
>> >> > > > > > > >
>> >> > > > > > > > 12:01:00 Informix Dynamic Server Stopped.
>> >> > > > > > > >
>> >> > > > > > > > The last successful restore was two days ago.
>> >> > > > > > > >
>> >> > > > > > > > Please advice.
>> >> > > > > > > >
>> >> > > > > > > > Wally Tang
>> >> > > > > > > >
>> >> > > > > > > >
>> >> > > > > > > >
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.