 |
IDS Forum
Re: Physical restore failed
Posted By: Roger Kee
Date: Tuesday, 27 April 2010, at 9:48 a.m.
In Response To: RE: Physical restore failed (Tang, Wally, CTR, DMA-Riv/IT)
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.
> > > > > >
> > > > > >
> > > > >
> > > > > --001636e0a70fafd2740484d9519b
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> ****************************************************************************
>
> >
> > >
> > > >
> > > > > ***
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> ****************************************************************************
>
> >
> > >
> > > > ***
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --001636e1f7ac1c43020484d9e025
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> ****************************************************************************
>
> >
> > >
> > > > ***
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> ****************************************************************************
>
> >
> > > ***
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001636e1fb61c154df0484dab3e3
> > >
> > >
> > >
> >
> >
>
> ****************************************************************************
>
> >
> > > ***
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> > >
> >
> >
>
> ****************************************************************************
>
> > ***
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --000e0cd32eaa9b14c40484f00421
> >
> >
> >
>
> ****************************************************************************
>
> > ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --000e0cd2e05c9869a904852f42d9
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd13bd4ed5c2004853826a2
Messages In This Thread
- Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Thursday, 22 April 2010, at 4:32 p.m.
- Re: Physical restore failed
Art Kagel -- Thursday, 22 April 2010, at 4:40 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Thursday, 22 April 2010, at 4:48 p.m.
- Re: Physical restore failed
Art Kagel -- Thursday, 22 April 2010, at 5:20 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Thursday, 22 April 2010, at 5:24 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Thursday, 22 April 2010, at 5:28 p.m.
- Re: Physical restore failed
Art Kagel -- Thursday, 22 April 2010, at 6:19 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 23 April 2010, at 9:25 a.m.
- Re: Physical restore failed
Roger Kee -- Friday, 23 April 2010, at 2:08 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 23 April 2010, at 2:16 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 23 April 2010, at 4:04 p.m.
- Re: RE: Physical restore failed
jack.parker4@verizon.net -- Friday, 23 April 2010, at 5:33 p.m.
- Re: Physical restore failed
Art Kagel -- Friday, 23 April 2010, at 7:45 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 23 April 2010, at 2:09 p.m.
- RE: Physical restore failed
Everett Mills -- Thursday, 22 April 2010, at 5:35 p.m.
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
