All 12 messages in topic - view as tree
From: Marco Schwarz - view profile
Date: Sun, Nov 26 2006 11:12 am
Email: Marco Schwarz
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
Reply » Rate this post: Text for clearing space
From: Marco Schwarz - view profile
Date: Sun, Nov 26 2006 11:18 am
Email: Marco Schwarz
Old server 9.30 TC2 new Server 9.40 TC5 is that the problem?
Thanks
Marco
Reply » Rate this post: Text for clearing space
From:
Date: Sun, Nov 26 2006 10:07 pm
Email:
You can only restore with the SAME Informix versions and OS.
MW
- Hide quoted text -
- Show quoted text -
-----Original Message-----
From: informix-list-boun...@iiug.org [mailto:informix-list-boun...@iiug.org]
On Behalf Of Marco Schwarz
Sent: Sunday, 26 November 2006 10:18 p.m.
To: informix-l...@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-l...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Reply » Rate this post: Text for clearing space
From: John Carlson - view profile
Date: Sun, Nov 26 2006 10:12 pm
Email: John Carlson
On Sun, 26 Nov 2006 10:12:28 +0100, Marco Schwarz
- Hide quoted text -
- Show quoted text -
>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
Reply » Rate this post: Text for clearing space
From: John Carlson - view profile
Date: Sun, Nov 26 2006 10:13 pm
Email: John Carlson
On Sun, 26 Nov 2006 10:18:14 +0100, Marco Schwarz
>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
Reply » Rate this post: Text for clearing space
From: Captain Pedantic - view profile
Date: Sun, Nov 26 2006 10:12 pm
Email: "Captain Pedantic"
"Marco Schwarz"
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.
Reply » Rate this post: Text for clearing space
From: Andreas Legner - view profile
Date: Sun, Nov 26 2006 11:12 pm
Email: Andreas Legner
Errno 2: The system cannot find the file specified.
Reply » Rate this post: Text for clearing space
From: Marco Schwarz - view profile
Date: Mon, Nov 27 2006 12:22 pm
Email: Marco Schwarz
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.1252
set 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:
- Hide quoted text -
- Show quoted text -
> Errno 2: The system cannot find the file specified.
Reply » Rate this post: Text for clearing space
From: Andreas Legner - view profile
Date: Mon, Nov 27 2006 11:24 pm
Email: Andreas Legner
1. find out the rows' rowids by 'select rowid where
2. for each rowid: oncheck -pp
-> 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.
Reply » Rate this post: Text for clearing space
From: Art S. Kagel - view profile
Date: Wed, Nov 29 2006 12:52 am
Email: "Art S. Kagel"
- Hide quoted text -
- Show quoted text -
Marco Schwarz wrote:
> 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.1252
> set 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?
-1213 is a character to numeric conversion error. You don't specify what
front-end tool/development tool is getting the error. You are trying to
fetch a character column into an integer or floating point host variable and
the string is not convertable to a number. Try fetching it into a
string/char host variable.
Art S. Kagel
Reply » Rate this post: Text for clearing space
From: Marco Schwarz - view profile
Date: Wed, Nov 29 2006 10:24 am
Email: Marco Schwarz
Art S. Kagel schrieb:
- Hide quoted text -
- Show quoted text -
> Marco Schwarz wrote:
>> 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.1252
>> set 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?
> -1213 is a character to numeric conversion error. You don't specify
> what front-end tool/development tool is getting the error. You are
> trying to fetch a character column into an integer or floating point
> host variable and the string is not convertable to a number. Try
> fetching it into a string/char host variable.
> Art S. Kagel
I understand the error message, but the record are right before Informix
crashed. How this is possible?
Marco
Reply » Rate this post: Text for clearing space
From: Art S. Kagel - view profile
Date: Wed, Nov 29 2006 6:47 pm
Email: "Art S. Kagel"
Marco Schwarz wrote:
> Art S. Kagel schrieb:
>>>How I can see the value in the table without the error -1213?
>>-1213 is a character to numeric conversion error. You don't specify
>>what front-end tool/development tool is getting the error. You are
>>trying to fetch a character column into an integer or floating point
>>host variable and the string is not convertable to a number. Try
>>fetching it into a string/char host variable.
>>Art S. Kagel
> I understand the error message, but the record are right before Informix
> crashed. How this is possible?
Well, the server crashed and your restore also did not succeed. My guess is
that the data on this particular page is garbage. You did say this was a
new problem. You didn't say you were trying to read the data from the
database produced by a failed restore. Or am I misinterpreting?
Art S. Kagel
Reply » Rate this post: Text for clearing space
End of messages
No comments:
Post a Comment