Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: Physical restore failed

Posted By: Tang, Wally, CTR, DMA-Riv/IT
Date: Friday, 23 April 2010, at 4:04 p.m.

In Response To: Re: Physical restore failed (Roger Kee)

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.

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.