 |
IDS Forum
RE: Physical restore failed
Posted By: Tang, Wally, CTR, DMA-Riv/IT
Date: Monday, 26 April 2010, at 9:29 a.m.
In Response To: Re: Physical restore failed (Art Kagel)
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.
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 -- Monday, 26 April 2010, at 9:29 a.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.
|
|
