Re: Restore + Logical log - caution

if a paralel backup was taken i can understand it, however it seems to be an ontape and afaik you need the llogs since the lvl 0. i would say you are looking at a bug here not a doc bug but a real bug,,,, Superboer. On 20 jan, 12:52, Cesar Inacio Martins <cesar_inacio_mart...@yahoo.com.br> wrote: > The last weeks I discovery a behave of the engine what is something new > for me. > I believe others will be surprised too... > > IFX 11.50 FC9 > > When you restore an archive with logical logs , maybe you needed the > files/tapes of logical logs backuped before the Archive Level 0. > > The reason is open transactions. > > I have a situation here where for some reason a session keep they > transaction opened up to 4 hours (probably a application failure over > the control of the transaction). When was executed the Archive Level 0 > this sessions was idle (with TX open) from 3 hour before. > The "lag" between the logical log what this TX was opened and Archive > are take is at least 100 Logical Logs (30 MB each = 3GB of Logs). > > So, during the restore the engine request all logical logs since this > open TX. > > The engine include this logical logs on the archive and show the number > of this logs when the Archive Level 0 is finished, anyway you still > needed the tapes/files created before this archive to restore the > logical backuped after this archive. > > e.g. when the the archive bellow start running, the current log is > 129634 , the log 129537 was backuped 5 hours early. If I try restore > this Archive with logical logs, the engine will request the files/tapes > since log 129537. > >      Please enter the level of archive to be performed (0, 1, or 2) 0 >      Please mount tape 1 on /dev/rmt0 and press Return to continue ... >      10 percent done. >      20 percent done. >      30 percent done. >      40 percent done. >      50 percent done. >      60 percent done. >      70 percent done. >      80 percent done. >      100 percent done. >      Read/Write End Of Medium enabled: blocks = 307955 >      Please label this tape as number 1 in the arc tape sequence. >      This tape contains the following logical logs: >       129537 - 129634 >      Program over. > > A PMR was opened over this behave and answered as expected behave. Was > created a APAR over the documentation (this behave wasn't documented > before). > > So, if you have any policy of discarding logical logs backups take > before your Archive... beware . > > Regards > Cesar