<No Subject Supplied>

>From naomi Sat Jun 5 14:11:18 MST 1993 remote from qip From: naomi@qip (Naomi Walker) Message-Id: <9306052111.AA24659@qip> Received: from qip by misty.anasazi.com; Sat, 5 Jun 93 14:11:20 MST Received: by qip (5.61/1.2) (from naomi (Naomi Walker) to informix-list@rmy.emory.edu) id AA24659; Sat, 5 Jun 93 14:11:19 -0700 Subject: Mail Problems (still) To: informix-list@rmy.emory.edu (Informix List) Date: Sat, 5 Jun 93 14:11:18 MST X-Mailer: ELM [version 2.3 PL11] Content-Type: text Content-Length: 2514 Mike, I tried mailing this, but it didnt make it. If you mail be your telephone number, we can talk. Naomi Your mail to hpdmmfi.boi.hp.com is not yet delivered. ---------- unsent mail ---------- >From naomi Thu Jun 3 08:48:16 1993 remote from misty Subject: Informix Problems To: mikea@hpdmmfi.boi.hp.com Date: Thu, 3 Jun 93 8:48:15 MST X-Mailer: ELM [version 2.3 PL11] Content-Type: text Content-Length: 2193 > > I ran accross a major problem last night where I lost a > table in my database but couldn't restore because > somehow the logical logs were not up to date. I have > read where you have done some things with tblog. Have > you ever been able to skip logical logs,fake the engine > out or bypass restore alltogether to get to the data you > want in a logical log. Or have you used tblog to "load" > information back to the engine from your logical log > tape? > > Any ideas or help would be appreciated. > > Mikea > mikea@hpdmmfi.boi.hp.com > Mike, I sympathize. When you say you "lost" a table, do you mean it became unreadable? Had you restored? Can you tell me some more details, please. How were your logs not up to date? I have had situations where I had to restore, but my logical logs tapes were unreadable. In that case, I restored what I could, and was able to recreate data from a transaction log generated by our application. We ran these transaction through our dialtip as if the agent interface had created them. I doubt this would be of much help to you. Since running into the problems with unreadable tapes (1/4 cartridge), we have our operators check every tape with dd and/or tblog. This checks only readability, not content, but helps. I have also switched to using DAT drives for logging, as they seem to be much more reliable. I have never been able to pull small pieces out of the log, and just recreate that data. Even more frustrating, is not having the ability, when tape 27 of 39 is bad, to recreate just that much data. Typically, I was restoring from an archive because we had overflowed our logs or lock table. In this case, after bringing the engine offline and back up again, it looped forever in recovery. Informix has regency tools that they can use to tell the engine to bypass the information in the logs. -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. ---Mark Twain