ontape -r failed: code -1 errno 2
After a server crash, the poster tried 'ontape -r' on Windows and got "Physical restore failed - function read archive backup failed code -1 errno 2". It turned out the backup was taken on IDS 9.30.TC2 but was being restored onto a 9.40.TC5 instance; several replies confirmed an archive can only be restored to the same server version (and OS), and errno 2 simply means the file wasn't found. The poster accepted this as the cause. A follow-up question about -1213 conversion errors on some rows was answered with advice to locate the rowids and dump the pages with oncheck -pp, but it was taken offline with no recorded outcome.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
I'm new in these newsgroup.
I habe a big problem!
Our server is crashing yesterday and I can't restore the database.
I copy the last backup and the act. onconfig on the server and start
C:\\ifmxbkup>ontape -r
Please mount tape 1 on C:\\ifmxbkup\\archbkup.bak and press Return to
continue ...
Physical restore failed - function read archive backup failed code -1
errno 2
I create the chunk with type nul > ....
What I make wrong?
Thanks
Marco
Old server 9.30 TC2 new Server 9.40 TC5 is that the problem? Thanks Marco
You can only restore with the SAME Informix versions and OS.
MW
-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
On Behalf Of Marco Schwarz
Sent: Sunday, 26 November 2006 10:18 p.m.
To: informix-list@iiug.org
Subject: Re: ontape -r failed: code -1 errno 2
Old server 9.30 TC2 new Server 9.40 TC5 is that the problem?
Thanks
Marco
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
"Marco Schwarz" <marco.schwarz@rolmail.net> wrote in message news:iK2dnQDxludBxvTYRVnyhA@kpnqwest.it... > Old server 9.30 TC2 new Server 9.40 TC5 is that the problem? Bet your life on it! Well, to be pedantic, there may be something else wrong too. But you will not be able to restore a 9.30 backup to a 9.40 instance.
On Sun, 26 Nov 2006 10:12:28 +0100, Marco Schwarz
<marco.schwarz@rolmail.net> wrote:
>Hi,
>
>I'm new in these newsgroup.
>
>I habe a big problem!
>
>Our server is crashing yesterday and I can't restore the database.
>
>I copy the last backup and the act. onconfig on the server and start
>
>C:\\ifmxbkup>ontape -r
>
>Please mount tape 1 on C:\\ifmxbkup\\archbkup.bak and press Return to
>continue ...
>Physical restore failed - function read archive backup failed code -1
>errno 2
>
>I create the chunk with type nul > ....
>
>What I make wrong?
Does a legitimate backup file exist at C:/ifmxbkup/archbkup.bak?
What are the permissions?
I don't have a system handy to remember what error number 2 is. In
fact, I can't guarantee that the error codes are the same between Unix
and Windows. . . . .
JWC
On Sun, 26 Nov 2006 10:18:14 +0100, Marco Schwarz <marco.schwarz@rolmail.net> wrote: >Old server 9.30 TC2 new Server 9.40 TC5 is that the problem? Could be. Restoring a older archive to a newer version isn't allowed. JWC
Errno 2: The system cannot find the file specified.
Thanks the reason ontape 9.3 ist different ontape 9.4!
But now I have a other problem since the crash some row of a table give
me the error -1213
Have someone an idea?
Server Env:
...
set CLIENT_LOCALE=DE_DE.1252
set DB_LOCALE=DE_DE.1252set SERVER_LOCALE=EN_US.CP1252
set DBLANG=EN_US.CP1252
set DBMONEY=,.
set DBDATE=DMY4/
Client Env:
the same
How I can see the value in the table without the error -1213?
Andreas Legner schrieb:
> Errno 2: The system cannot find the file specified.
1. find out the rows' rowids by 'select rowid where <something that identifies your bad row(s)>;'
2. for each rowid: oncheck -pp <db>:<table> <rowid>
-> this will dump the page(s) affected in data slot hex format.
-> Match this with your table schema and indetify your data/error.
Presumably your PERSONAL_LOCALE is de_de.1252 or similar as well, as mine is too, so... we could continue offline on this.