OnLine tbtape restore - ISAM Format Error

Hi, we have our server down after hardware failure. It is old server Pentium I with SCO Unix 5.0.4 and Informix OnLine 5. I installed specified OS and Informix to other computer, new computer has Celeron (333MHz) processor. There is also second difference - on new "server" I didn't create separate partitions for informix data, I used normal OS files (the length of files is 2048000 bytes). Here is list of files: -rw-rw---- 1 informix informix 2048000000 Jun 15 15:54 online1 -rw-rw---- 1 informix informix 2048000000 Jun 15 16:16 online2 Restoring from tape with "tbtape -r" was successful (no error message). Restore entire INFORMIX-OnLine system. Please mount the first system archive tape and press Return to continue... Restoring system control information, please wait... CHUNKS THAT WILL BE RESTORED Full Pathname Of The Chunk Offset Size /dev/rdsk/online2 0 2000000 /dev/rdsk/online1 0 2000000 Verifiying physical disk space, please wait... Verifiying physical disk space, please wait... Restoring dbspaces/BLOBSpaces, please wait... Do you have another level of tapes to restore? (y/n) n Initializing, please wait... Roll forward should start wih log number 730 Is there a logical log tape to restore? (y/n) n When I try to work with databases I get "Bad ISAM File format". First of two databases display names of some (not all) tables, second does not display nothing with "Cannot access system catalog". Tbcheck returns "Bad ISAM File format". In online.log are many records: 14:35:36 bfcheck: bad page: pg_addr 0 != bp->bf_pagenum 1000b0, userp = 80001bcc, pid = 622, uid = 201 14:35:36 -- WARNING: Fail Consistency Check -- pthdrpage:ptalloc:bad partn page -- pid=622 user=201 us=80001bcc What is wrong? I see three possible reasons: - wrong tapes (but I tested 3 different tapes)? - Celeron <> PentiumI (but OS and Informix are the same?) - chunks are in normal files, not in separate partitions (but it worked after installation without problems) Do you have some tips? Thank you very much. Leos

contact TS, you may suffer from missing pages in backup. what is the exact version of online 5.??? run tbcheck on your database(s); what does it say; if you are lucky and have prev backups restore those first (fingers crossed..) (make sure they all end up in the same file on disk!!!) then when the prev backups are restored; restore your last backup..... you may get lucky that a prev backup contains all or some of the missing pages so in the end you may have a sort of working system.... contact TS!!!! Superboer. URBAN Leos schreef: > Hi, > we have our server down after hardware failure. > It is old server Pentium I with SCO Unix 5.0.4 and Informix OnLine 5. > > I installed specified OS and Informix to other computer, new computer > has Celeron (333MHz) processor. There is also second difference - on new > "server" I didn't create separate partitions for informix data, I used > normal OS files (the length of files is 2048000 bytes). > > Here is list of files: > -rw-rw---- 1 informix informix 2048000000 Jun 15 15:54 online1 > -rw-rw---- 1 informix informix 2048000000 Jun 15 16:16 online2 > > Restoring from tape with "tbtape -r" was successful (no error message). > > Restore entire INFORMIX-OnLine system. > Please mount the first system archive tape and press Return to continue... > Restoring system control information, please wait... > CHUNKS THAT WILL BE RESTORED > Full Pathname Of The Chunk Offset Size > /dev/rdsk/online2 0 2000000 > /dev/rdsk/online1 0 2000000 > Verifiying physical disk space, please wait... > Verifiying physical disk space, please wait... > Restoring dbspaces/BLOBSpaces, please wait... > Do you have another level of tapes to restore? (y/n) n > Initializing, please wait... > Roll forward should start wih log number 730 > Is there a logical log tape to restore? (y/n) n > > When I try to work with databases I get "Bad ISAM File format". > First of two databases display names of some (not all) tables, second > does not display nothing with "Cannot access system catalog". > > Tbcheck returns "Bad ISAM File format". > > In online.log are many records: > 14:35:36 bfcheck: bad page: pg_addr 0 != bp->bf_pagenum 1000b0, userp = > 80001bcc, pid = 622, uid = 201 > 14:35:36 -- WARNING: Fail Consistency Check -- pthdrpage:ptalloc:bad > partn page -- pid=622 user=201 us=80001bcc> > What is wrong? I see three possible reasons: > > - wrong tapes (but I tested 3 different tapes)? > - Celeron <> PentiumI (but OS and Informix are the same?) > - chunks are in normal files, not in separate partitions (but it worked > after installation without problems) > > Do you have some tips? > > Thank you very much. > Leos

Superboer napsal(a): > contact TS, you may suffer from missing pages in backup. > what is the exact version of online 5.??? 5.06.UC1 > run tbcheck on your database(s); what does it say; > then when the prev backups are restored; restore your last backup..... > you may get lucky that a prev backup contains all or some of the > missing pages > so in the end you may have a sort of working system.... Tape Level 0 does not contain all pages ?? If all pages are contained then last restore overwrite any previous restore. You mean that problem is in wrong tapes? Thanks, Leos Note: failed server contained archive data only - they are not important for us. And I also hope that data on "informix" disks are correct because failed system disks only. I tried to restore data from tapes to other computer because we only need the data and it is more easy than get new hotswap disk for 8 (?) years old server. But for now I see that "easy" way failed. We will try to start old server.

> 5.06.UC1 this version -- should be ok; contact TS > Tape Level 0 does not contain all pages ?? there are bugs out there that Level 0 does not contain all pages.... > If all pages are contained then last restore overwrite any previous restore. again 506 should be ok as far as i know, however if a previous archive has a page in it which misses in the current archive then you could be lucky. > > You mean that problem is in wrong tapes? no. assuming also that your backup created was a complete and successfull backup!! > Note: failed server contained archive data only - they are not important > for us. And I also hope that data on "informix" disks are correct > because failed system disks only. if you have the old chunks somewhere available you may consider using dd to copy them to a file and use it on your new system. make sure you use the correct pathnames on your new server, maybe use sym links in order to acomplish that. > I tried to restore data from tapes to other computer because we only > need the data and it is more easy than get new hotswap disk for 8 (?) > years old server. But for now I see that "easy" way failed. We will try > to start old server. Fingers crossed. good luck Superboer Contact TS.