If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > invalid archive tape (ontape -r)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-13-07, 04:13
Tomato Tomato is offline
Registered User
 
Join Date: Sep 2007
Posts: 1
invalid archive tape (ontape -r)

Hi there.

I got a customer who deleted a complete table by mistake. I decided to import his old ontape-backup, get that table from that backup and send an unload from the table back to my customer.

So I got his 2.5GB backup-file.

My test-Informix is newer than his. (9.40.TC7) his is: 7.31.TD7 (as it is saved in his backup-file)

I took all his onconfig-settings and tried to import vie "ontape -r" and also "ontape -p". But the only thing i get is:

Quote:
C:\Informix>ontape -r

Please mount tape 1 on f:\backup.dat and press Return to continue ...

Invalid archive tape
Restore a level 0 archive (y/n) y
Ready for level 0 tape

Please mount tape 1 on f:\backup.dat and press Return to continue ...
Any clues? (Both systems are Windows of course)

BTW: The Backup-File seems to be ok. At least I can read some information when doing a simple Type:
Quote:
(snip)
Archive Backup TapeInformix Dynamic Server Version 7.31.TD7 Tue Sep 11 20:00:00 2007AdministratorPIKRPI_AP_202
d:\ifmxbkup\backup.dat
(snip)
@
thx in advance
Reply With Quote
  #2 (permalink)  
Old 09-14-07, 09:18
Tyveleyn Tyveleyn is offline
Registered User
 
Join Date: Aug 2006
Location: The Netherlands
Posts: 248
Your TAPEDEV parameter in the onconfig-file has the value 'f:\' I presume. What if you created a 'ifmxbkup' dir on your local D:\ drive and copy the tapearchive as 'backup.dat' file to this directory? (Don't know exactly how; my experience is merely focussed on the UNIX environment.) Then you only have to change the TAPEDEV parameter in onconfig and the right archive can be approached. However I doubt that the 9.4 server can restore a 7.31 archive. Check it out yourself, e.g. in the "Backup and Restore Guide" or the "Migration Guide" in http://www-306.ibm.com/software/data...ry/ids_94.html
Regards
Reply With Quote
  #3 (permalink)  
Old 09-20-07, 13:35
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
No! You can not restore a backup from a differ version of IDS and differ plataform...

In this case, you must install IDS 7.31 32bits for Windows to restore...
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On