Restore + Logical log - caution
Posted in 2012
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