Re: I LOVE INFORMIX: failed tape restore

Dear Alex, Same happened to us, several times. We are using 5.08 UD1 on Solaris 2.5. There is no way, BUT relying on several archives, PLUS using tbcheck regulary. OnLine 5.0x is extremely vulnerable in this regard. OnLine's archive mechanism neither check data consistency nor backup media... :-( -- Ali Azarkar. > From alex.barilo@phila.gov Wed Jul 21 19:54:29 1999 > X-Authentication-Warning: iiug.iiug.org: majordom set sender to owner-informix-list@iiug.org using -f > From: alex.barilo@phila.gov (Alex Barilo) > To: informix-list@iiug.org > Subject: I LOVE INFORMIX: failed tape restore > Date: Wed, 21 Jul 1999 13:13:30 GMT > X-List-Gateway: comp.databases.informix > X-MDaemon-Deliver-To: azarkar@tmcso.com > X-Return-Path: owner-informix-list@iiug.org > > Hi folks, > > Here is my success story: > > Recently, our Informix On-Line 5.07.UC1 wouldn't get up and I got > these messages in its log file: > tblspace header error: > <memory dump> > -- Fail Consistency Check... > Cannot Open Dbspace 3 > ... > > so I decided to restore from tape. After several hours I got the > message: Error reading from tape device, Error No = 5 > and the shell prompt. > > Anyway, I tried to tbinit and, to my huge astonishment, after going > through phisical recovery, the thing DID GO UP!!! Yahoo! > > WOW! This is impressive! I WOULD expect any serious DBMS behaive that > smart but in fact, I DID NOT expect it, I only hoped. :) > > So, thank you Informix guys! Great job! > > Alex. > -------- > Before the accident, I could not even spell UNIX > > PS I'd love to hear similar stories about other DBMS's otherwise if > someone asks me what's the best DBMS - you know the answer, right ;) > > > >