Logical log restore from disk error

I am new at this (thanks to attrition) and am currently moving the db backups from tape to disk. During a test restore of a level 0 archive and a logical log I encountered an "Unexpected end of log tape (errno 0), continuing..." error when restoring from the logical log file (see end of post). Is this typical for a disk restore? Also, I ran a second restore test in an attempt to restore from multiple logical log files after a level 0 restore. In a nutshell these were my steps: - ontape -r - successfully restored from level 0 file - successfully backed up the logs - moved first logical log file to restore file location (onconfig filename) - answered "y" to logical log restore - got "Unexpected end of log tape (errno 0), continuing..." error - no delay - moved second logical log file to restore file location - answered "y" to another logical log restore - again got "Unexpected end of log tape (errno 0), continuing..." error - no delay - answered "n" to another logical log restore - program delayed as it appeared to be "working" - program completed The result of all this is that it successfully restored the level 0 archive and the first logical log. But if failed to restore the second logical log. Any ideas? Thanks, Brian Continue restore? (y/n)y Do you want to back up the logs? (y/n)n Restore a level 1 archive (y/n) N Do you want to restore log tapes? (y/n)Y Roll forward should start with log number 1627 Please mount tape 1 on /usr/informix/backup/logical_logs/logical.log and press Return to continue ... Unexpected end of log tape (errno 0), continuing... Do you want to restore another log tape? (y/n)n Program over.

Hi, that's NOT typical for a disk restore! Contains the file /usr/informix/backup/logical_logs/logical.log really the correct/complete logical log 1627? Do a strings or something else on the file. Regards, Andreas > ------------------------------------------- SPAR Österreichische Warenhandels-AG Hauptzentrale A - 5015 Salzburg, Europastrasse 3 FN 34170 a Tel: +43 662 4470 24223 Mobile: +43 664 6259575 E-Mail: Andreas.KUTSCHE@spar.at Internet: http://www.spar.at Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche und rechtlich geschützte Informationen, insbesondere Betriebs- oder Geschäftsgeheimnisse, enthalten, zu deren Geheimhaltung der Empfänger verpflichtet ist. Die Informationen in dieser E-Mail sind ausschließlich für den Adressaten bestimmt. Sollten Sie die E-Mail irrtümlich erhalten haben so ersuchen wir Sie, die Nachricht von Ihrem System zu löschen und sich mit uns in Verbindung zu setzen. Über das Internet versandte E-Mails können leicht manipuliert oder unter fremdem Namen erstellt werden. Daher schließen wir die rechtliche Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlich bestätigt und gezeichnet wird. Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die Zusendung von E-Mails ein Virus in Ihre Systeme gelangen, haften wir nicht für evtl. hieraus entstehende Schäden. Wir danken für Ihr Verständnis. Important notice: The contents of this e-mail may contain confidential and legally protected information that is in particular related to operational and trade secrets, which the recipient is obliged to treat as confidential. The information in this e-mail is made available exclusively for use by the addressee. In the event that the e-mail may have been sent to you in error, we would ask you to kindly delete this communication from your system and to contact us. E-mails sent via the Internet can be easily manipulated or sent out under someone else's name. We therefore do not accept legal liability for the information contained in this communication. The contents of the e-mail are only legally binding if they have been confirmed and signed by us in writing. If, in spite of our using Antivirus protection software, a virus may have penetrated your system through the sending of this e-mail, we do not accept liability for any damage that may possibly arise as a result of this. We trust that you appreciate our position. ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im Auftrag von > INGALLS BRIAN > Gesendet: Mittwoch, 12. September 2007 17:17 > An: ids@iiug.org > Betreff: Logical log restore from disk error [9944] > > > I am new at this (thanks to attrition) and am currently > moving the db backups > from tape to disk. During a test restore of a level 0 archive > and a logical > log I encountered an "Unexpected end of log tape (errno 0), > continuing..." > error when restoring from the logical log file (see end of > post). Is this > typical for a disk restore? > > Also, I ran a second restore test in an attempt to restore > from multiple > logical log files after a level 0 restore. In a nutshell > these were my steps: > - ontape -r > - successfully restored from level 0 file > - successfully backed up the logs > - moved first logical log file to restore file location > (onconfig filename) > - answered "y" to logical log restore > - got "Unexpected end of log tape (errno 0), continuing..." error > - no delay > - moved second logical log file to restore file location > - answered "y" to another logical log restore > - again got "Unexpected end of log tape (errno 0), > continuing..." error > - no delay > - answered "n" to another logical log restore > - program delayed as it appeared to be "working" > - program completed > > The result of all this is that it successfully restored the > level 0 archive > and the first logical log. But if failed to restore the > second logical log. > Any ideas? > > Thanks, > Brian > > Continue restore? (y/n)y > Do you want to back up the logs? (y/n)n > Restore a level 1 archive (y/n) N > Do you want to restore log tapes? (y/n)Y > > Roll forward should start with log number 1627 > > Please mount tape 1 on > /usr/informix/backup/logical_logs/logical.log and press > Return to continue ... > Unexpected end of log tape (errno 0), continuing... > Do you want to restore another log tape? (y/n)n > > Program over. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Good morning Brian, Just my 2 cents,=20 You might have had a bad block on your tape, which is a possibility. Also, you might have receive an "end-of-media" from the tape drive, which ontape doesn't know how to handle. You might want to check your settings in the ONCONFIG file for TAPEDEV and LTAPEDEV. You'll have to tell ontape how much data can fit on a tape. I highly recommend specifying the native (uncompressed) capacity of your tape drive, because it's always difficult t= o gage how much data will really compress well. Here is an example of my settings (my system is HPUX 11.23): TAPEDEV /dev/rmt/1m # Tape device path TAPEBLK 32 # Tape block size (Kbytes) TAPESIZE 100000000 # Maximum amount of data to put on tap=e (Kbytes) The archive device /dev/rmt/1m is an HP Ultrium LTO-1 drive. It's capable of 200Gb compressed, but I've set TAPESIZE to be just shy of 100Gb (uncompressed capacity) so that I don't hit the end-of-media problem with ontape. Hope that helps! Jonathan B. Smaby DBSA Pomona College, ITS-AISO Office jonathan.smaby@pomona.edu Tel. (909) 621-8506 Web. http://aiso.pomona.edu -- =B3The greatest mistake we make is living in constant fear that we will make one. =B2 ~John C. Maxwell > From: INGALLS BRIAN <brian.ingalls@idt.com> > Reply-To: <ids@iiug.org> > Date: Wed, 12 Sep 2007 11:16:54 -0400 (EDT) > To: <ids@iiug.org> > Subject: Logical log restore from disk error [9944] >=20 > I am new at this (thanks to attrition) and am currently moving the db bac= kups > from tape to disk. During a test restore of a level 0 archive and a logic= al > log I encountered an "Unexpected end of log tape (errno 0), continuing...= " > error when restoring from the logical log file (see end of post). Is this > typical for a disk restore? >=20 > Also, I ran a second restore test in an attempt to restore from multiple > logical log files after a level 0 restore. In a nutshell these were my st= eps: > - ontape -r=20 > - successfully restored from level 0 file > - successfully backed up the logs > - moved first logical log file to restore file location (onconfig filenam= e) > - answered "y" to logical log restore > - got "Unexpected end of log tape (errno 0), continuing..." error > - no delay=20 > - moved second logical log file to restore file location > - answered "y" to another logical log restore > - again got "Unexpected end of log tape (errno 0), continuing..." error > - no delay=20 > - answered "n" to another logical log restore > - program delayed as it appeared to be "working" > - program completed >=20 > The result of all this is that it successfully restored the level 0 archi= ve > and the first logical log. But if failed to restore the second logical lo= g. > Any ideas?=20 >=20 > Thanks,=20 > Brian=20 >=20 > Continue restore? (y/n)y > Do you want to back up the logs? (y/n)n > Restore a level 1 archive (y/n) N > Do you want to restore log tapes? (y/n)Y >=20 > Roll forward should start with log number 1627 >=20 > Please mount tape 1 on /usr/informix/backup/logical_logs/logical.log and = press > Return to continue ... > Unexpected end of log tape (errno 0), continuing... > Do you want to restore another log tape? (y/n)n >=20 > Program over.=20 >=20 >=20 > *************************************************************************= ***** > *=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. =0D

What's probably happening is that the copy from tape to disk has left the disk file with a small trailer of garbage since the tape drive only reads/writes fixed length blocks. When reading a tape IDS looks for the EOT marker at the logical end of the file on tape. When reading from disk it expects to find a physical end of file after a complete logical log record. The small piece disk following the last logical log record before the end of file is what looks short. Art ----- Original Message ----- From: Ingalls Brian <ids@iiug.org> To: ids@iiug.org At: 9/12 11:17:19 I am new at this (thanks to attrition) and am currently moving the db backups from tape to disk. During a test restore of a level 0 archive and a logical log I encountered an "Unexpected end of log tape (errno 0), continuing..." error when restoring from the logical log file (see end of post). Is this typical for a disk restore? Also, I ran a second restore test in an attempt to restore from multiple logical log files after a level 0 restore. In a nutshell these were my steps: - ontape -r - successfully restored from level 0 file - successfully backed up the logs - moved first logical log file to restore file location (onconfig filename) - answered "y" to logical log restore - got "Unexpected end of log tape (errno 0), continuing..." error - no delay - moved second logical log file to restore file location - answered "y" to another logical log restore - again got "Unexpected end of log tape (errno 0), continuing..." error - no delay - answered "n" to another logical log restore - program delayed as it appeared to be "working" - program completed The result of all this is that it successfully restored the level 0 archive and the first logical log. But if failed to restore the second logical log. Any ideas? Thanks, Brian Continue restore? (y/n)y Do you want to back up the logs? (y/n)n Restore a level 1 archive (y/n) N Do you want to restore log tapes? (y/n)Y Roll forward should start with log number 1627 Please mount tape 1 on /usr/informix/backup/logical_logs/logical.log and press Return to continue ... Unexpected end of log tape (errno 0), continuing... Do you want to restore another log tape? (y/n)n Program over. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Oh good point. Also, since you're backing up to disk, it's possible that your file-system may have a file-size limit. With HPUX, I have to specific an option "large-files" to allow a volume to hold a file larger than 2Gb. Check with your O/S tech support on file size limitations. You might have a corrupt backup-file possibly due to file size limitations. Jonathan B. Smaby DBSA Pomona College, ITS-AISO Office jonathan.smaby@pomona.edu Tel. (909) 621-8506 Web. http://aiso.pomona.edu -- =B3The greatest mistake we make is living in constant fear that we will make one. =B2 ~John C. Maxwell > From: "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net> > Reply-To: <ids@iiug.org> > Date: Wed, 12 Sep 2007 12:07:26 -0400 (EDT) > To: <ids@iiug.org> > Subject: Re:Logical log restore from disk error [9947] >=20 > What's probably happening is that the copy from tape to disk has left the= disk > file with a small trailer of garbage since the tape drive only reads/writ= es > fixed length blocks. When reading a tape IDS looks for the EOT marker at = the > logical end of the file on tape. When reading from disk it expects to fin= d a > physical end of file after a complete logical log record. The small piece= disk > following the last logical log record before the end of file is what look= s > short.=20 >=20 > Art=20 >=20 > ----- Original Message ----- > From: Ingalls Brian <ids@iiug.org> > To: ids@iiug.org=20 > At: 9/12 11:17:19 >=20 > I am new at this (thanks to attrition) and am currently moving the db bac= kups > from tape to disk. During a test restore of a level 0 archive and a logic= al > log I encountered an "Unexpected end of log tape (errno 0), continuing...= " > error when restoring from the logical log file (see end of post). Is this > typical for a disk restore? >=20 > Also, I ran a second restore test in an attempt to restore from multiple > logical log files after a level 0 restore. In a nutshell these were my st= eps: > - ontape -r=20 > - successfully restored from level 0 file > - successfully backed up the logs > - moved first logical log file to restore file location (onconfig filenam= e) > - answered "y" to logical log restore > - got "Unexpected end of log tape (errno 0), continuing..." error > - no delay=20 > - moved second logical log file to restore file location > - answered "y" to another logical log restore > - again got "Unexpected end of log tape (errno 0), continuing..." error > - no delay=20 > - answered "n" to another logical log restore > - program delayed as it appeared to be "working" > - program completed >=20 > The result of all this is that it successfully restored the level 0 archi= ve > and the first logical log. But if failed to restore the second logical lo= g. > Any ideas?=20 >=20 > Thanks,=20 > Brian=20 >=20 > Continue restore? (y/n)y > Do you want to back up the logs? (y/n)n > Restore a level 1 archive (y/n) N > Do you want to restore log tapes? (y/n)Y >=20 > Roll forward should start with log number 1627 >=20 > Please mount tape 1 on /usr/informix/backup/logical_logs/logical.log and = press > Return to continue ... > Unexpected end of log tape (errno 0), continuing... > Do you want to restore another log tape? (y/n)n >=20 > Program over.=20 >=20 >=20 > *************************************************************************= ***** > *=20 > Forum Note: Use "Reply" to post a response in the discussion forum. >=20 >=20 > *************************************************************************= ***** > *=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. =0D

Thank you much for all of your input. I checked some things based on your recommendations. After reading your suggestions I suspected the files were having a problem with being gzipped and gunzipped (which I failed to mention before). So I created the backup files without zipping and restored from those. I got the same error when ontape read the files so that wasn't it. However, this time I verified that it successfully restored the transactions from each of the logical log files. So I guess I will presume that this is normal behavior from ontape since it was designed to restore from tape and not disk. It makes me nervous to see this error during a restore but since it worked I guess I will be able to cope. Regards, Brian

If you had backed up the logical logs to disk you would not get the error. You are getting this unexpected EOF because you backed up the logs to tape then copies the tape files to disk and are restoring them from there. Art S. Kagel ----- Original Message ----- From: Ingalls Brian <ids@iiug.org> To: ids@iiug.org At: 9/12 13:39:19 Thank you much for all of your input. I checked some things based on your recommendations. After reading your suggestions I suspected the files were having a problem with being gzipped and gunzipped (which I failed to mention before). So I created the backup files without zipping and restored from those. I got the same error when ontape read the files so that wasn't it. However, this time I verified that it successfully restored the transactions from each of the logical log files. So I guess I will presume that this is normal behavior from ontape since it was designed to restore from tape and not disk. It makes me nervous to see this error during a restore but since it worked I guess I will be able to cope. Regards, Brian ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.