|
IDS Forum
RE: Physical restore failed
Posted By: Everett Mills Date: Friday, 23 April 2010, at 4:48 p.m.
In Response To: RE: Physical restore failed (Tang, Wally, CTR, DMA-Riv/IT)
Wally-
What are the permissions on the directory that the devices live in? Maybe Informix doesn't have permission to find its devices in /dev/ifx. Post ls -l /dev | grep ifx
--EEM
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Tang, Wally, CTR, DMA-Riv/IT
> Sent: Friday, April 23, 2010 3:18 PM
> To: ids@iiug.org
> Subject: RE: Physical restore failed [19837]
>
> Yes, the owner and group are both "Informix".
>
> 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
> James
> Young
> Sent: Friday, April 23, 2010 1:16 PM
> To: ids@iiug.org
> Subject: Re: Physical restore failed [19835]
>
> 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
>
> ***********************************************************************
> *****
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ***********************************************************************
> ********
> 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: Physical restore failed
James Young -- Friday, 23 April 2010, at 4:16 p.m.
- RE: Physical restore failed
Tang, Wally, CTR, DMA-Riv/IT -- Friday, 23 April 2010, at 4:18 p.m.
- RE: Physical restore failed
Everett Mills -- Friday, 23 April 2010, at 4:48 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.
|
|