 |
IDS Forum
Re: Physical restore failed
Posted By: James Young
Date: Friday, 23 April 2010, at 4:17 p.m.
In Response To: RE: Physical restore failed (Tang, Wally, CTR, DMA-Riv/IT)
Nevermind, I didn't read the whole post...
On Fri, Apr 23, 2010 at 4:16 PM, James Young <jamesyoung37@gmail.com> wrote:
> 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.
>>
>>
>
--000e0cd138decdbd700484ed1c50
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.
|
|
