 |
IDS Forum
Re: Physical restore failed
Posted By: James Young
Date: Friday, 23 April 2010, at 4:16 p.m.
In Response To: RE: Physical restore failed (Tang, Wally, CTR, DMA-Riv/IT)
Did you check to make sure that the owner and group are both "informix"?
On Fri, Apr 23, 2010 at 4:04 PM, Tang, Wally, CTR, DMA-Riv/IT <
Wally.Tang.CTR@dma.mil> wrote:
> Hi Roger,
>
> I changed permission of /dev/ifx/rtasa1 to "660", but when I restored with
> ontape -r, I still got 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
>
> 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
> Roger
> Kee
> Sent: Friday, April 23, 2010 11:08 AM
> To: ids@iiug.org
> Subject: Re: Physical restore failed [19829]
>
> Wally,
>
> Have you tried setting the permissions for /dev/ifx/rtasa1 to be like the
> other chunk devices (660)?
>
> 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.
> >
> >
>
> --000e0cd15402eeea6f0484eb4e86
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636e90995d41cf10484ed18f9
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: Physical restore failed
James Young -- Friday, 23 April 2010, at 4:16 p.m.
- Re: Physical restore failed
James Young -- Friday, 23 April 2010, at 4:17 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.
|
|
