Splitting logical logs

IDS 9.4 WE, Sola'ris 9 Hi everybody, we use to back up our logical logs using "ontape -c", for example in a file named "trans.log". As a consequence, when restoring a Level-0 backup using ontape -r, we can only restore *all* logical logs contained in the trans.log or *no* logical log. Assume, the trans.log contains the logical logs 500 - 600. Is there a way to - restore just the logical logs 500 - 590 or - to split the trans.log in 101 different log-files (500-600) in order to restore the logical logs 500 - 590 sequential? Thanks for any answer! Best Regards Markus

Use dd with an appropriate count to output a truncated copy of trans.log to trans_short.log. "news.arcor.de" <mb@worxbox.com> wrote in message news:45e989db$0$20294$9b4e6d93@newsspool3.arcor-online.net... > IDS 9.4 WE, Sola'ris 9 > > Hi everybody, > > we use to back up our logical logs using "ontape -c", for example in a > file named "trans.log". > As a consequence, when restoring a Level-0 backup using ontape -r, we can > only restore *all* logical logs contained in the trans.log or *no* logical > log. > > Assume, the trans.log contains the logical logs 500 - 600. > Is there a way to > > - restore just the logical logs 500 - 590 > > or > > - to split the trans.log in 101 different log-files (500-600) in order to > restore the logical logs 500 - 590 sequential? > > > Thanks for any answer! > > > Best Regards > Markus > > > > >

Hi Neil, thanks for your answer! What do you mean by "an appropriate count"? Is it sure, that each logical-log file has exactly the same size? Using dd, I think it's hard to find the correct truncation-point. Regards Markus "Neil Truby" <neil.truby@ardenta.com> schrieb im Newsbeitrag news:54vh2lF22ua1uU1@mid.individual.net... > Use dd with an appropriate count to output a truncated copy of trans.log > to trans_short.log. > > "news.arcor.de" <mb@worxbox.com> wrote in message > news:45e989db$0$20294$9b4e6d93@newsspool3.arcor-online.net... >> IDS 9.4 WE, Sola'ris 9 >> >> Hi everybody, >> >> we use to back up our logical logs using "ontape -c", for example in a >> file named "trans.log". >> As a consequence, when restoring a Level-0 backup using ontape -r, we can >> only restore *all* logical logs contained in the trans.log or *no* >> logical log. >> >> Assume, the trans.log contains the logical logs 500 - 600. >> Is there a way to >> >> - restore just the logical logs 500 - 590 >> >> or >> >> - to split the trans.log in 101 different log-files (500-600) in order to >> restore the logical logs 500 - 590 sequential? >> >> >> Thanks for any answer! >> >> >> Best Regards >> Markus >> >> >> >> >> > >

Hi, no, logical log backups are not all the same size. It is possible, but only under specific circumstances. What you can do (and I guess what Neil means) is that you simply can "truncate" the log backup to some arbitrary size. With that the restore will recognize that the logical log is "finished" and will at that point stop, rollback open transactions and bring the server to quiescent mode. However, it would be rather difficult to do the truncation just at the actual boundary between 2 logical log backups. Thus, with the "trick" from Neil is is possible to cut short the log restore, but in general it will not be at a discrete point. What you want to achive is quite easy with ON-Bar, the alternative backup/restore tool for IDS. For restore you can specify, up to which log unique ID logs shall be restored. You can even use a timestamp (rather then log unique ID) where the time stamp can be "in the middle of a log file". You can read more about ON-Bar in the "Backup and Restore Guide" manual. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Sorry, but the following text is now required by German law: IBM Deutschland GmbH Vorsitzender des Aufsichtsrats: Hans Ulrich Maerki Geschäftsführung: Martin Jetter (Vorsitzender), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Andreas Kerstan Sitz der Gesellschaft: Stuttgart Registergericht: Amtsgericht Stuttgart, HRB 14562 WEEE-Reg.-Nr. DE 99369940 informix-list-bounces@iiug.org wrote on 04.03.2007 11:36:39: > Hi Neil, > > thanks for your answer! > What do you mean by "an appropriate count"? > Is it sure, that each logical-log file has exactly the same size? > Using dd, I think it's hard to find the correct truncation-point. > > Regards > Markus > > > "Neil Truby" <neil.truby@ardenta.com> schrieb im Newsbeitrag > news:54vh2lF22ua1uU1@mid.individual.net... > > Use dd with an appropriate count to output a truncated copy of trans.log > > to trans_short.log. > > > > "news.arcor.de" <mb@worxbox.com> wrote in message > > news:45e989db$0$20294$9b4e6d93@newsspool3.arcor-online.net... > >> IDS 9.4 WE, Sola´ris 9 > >> > >> Hi everybody, > >> > >> we use to back up our logical logs using "ontape -c", for example in a > >> file named "trans.log". > >> As a consequence, when restoring a Level-0 backup using ontape -r, we can > >> only restore *all* logical logs contained in the trans.log or *no* > >> logical log. > >> > >> Assume, the trans.log contains the logical logs 500 - 600. > >> Is there a way to > >> > >> - restore just the logical logs 500 - 590 > >> > >> or > >> > >> - to split the trans.log in 101 different log-files (500-600) in order to > >> restore the logical logs 500 - 590 sequential? > >> > >> > >> Thanks for any answer! > >> > >> > >> Best Regards > >> Markus > >> > >> > >> > >> > >> > > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list