Re: Splitting logical logs

news.arcor.de wrote: > 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? You can only restore partial logical log history if you are archiving logs as they fill using the ALARMPROGRAM to separate disk files, one per log (actually one per ontape -a execution, but that's almost always one per). Then you just provide the log files one at a time until the rough point in time that you want to stop. Art S. Kagel

That's what I used to do also in one instance where I only did ontape backups before: One file per logical log. The dd alternative is an option that you may want to explore if you are stuck and got nothing to lose. I've never done it so not sure if it'll work, but you can measure the size of your trans.log when it contains one logical log , two logical logs etc, then truncate your trans.log to a size where it'd contain 90 logical logs and try that .. ( provided all your logical logs are the same size ... or even if they are different just calculate the file size for 90 logs ) On 3/5/07, Art S. Kagel <kagel@bloomberg.net> wrote: > > news.arcor.de wrote: > > 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? > > You can only restore partial logical log history if you are archiving logs > as they fill using the ALARMPROGRAM to separate disk files, one per log > (actually one per ontape -a execution, but that's almost always one per). > > Then you just provide the log files one at a time until the rough point in > time that you want to stop. > > Art S. Kagel > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- The biggest oxymoron: common sense