Restore + Logical log - caution

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

Excuse any misunderstanding on my part however... Isn't expected behavior such that the actual archive process will back up any logs that it needs to be able to restore as of the archive checkpoint taken at the beginning of the archive? I do not believe what you are explaining is expected behavior at all and would escalate that PMR to the next level. I just do not believe what you were told and would love to know where this went from here as I am sure others would also. Thanx, Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar Inacio Martins Sent: Friday, January 20, 2012 6:54 AM To: ids@iiug.org Subject: Restore + Logical log - caution [25984] 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 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Dan, Well... this is just the facts. The support was reproduced this behave and this is the final answer what I received. Particularity , I agree with you. For me this is wrong but I don't have time and patience any more to discuss with support, so I just request a correction over the documentation what is easily to do. On my situation I can workaround just keeping better documented and instructing better the support team on the company where I work to keep the logical log tapes safe... the APAR created: IC80912 HTTP://PUBLIB.BOULDER.IBM.COM/INFOCENTER/IDSHELP/V115/INDEX.JSP?TOPIC=%2FCOM.IBM .BAR.DOC%2FIDS_BAR_479.HTM NEEDS TO BE UPDATED According to this document we recommend gathering logical-log tapes from the backup after the latest level-0 backup but there are certain scenarios where we need logical-log tapes before the level-0 backup. At the time of the archive checkpoint, if there was an open transaction that started in a logical log, ontape asks for the logical log prior to the archive ckpt for the logical log roll forward. Project IDS-11.50.xC10 Regards Cesar On 20/1/2012 10:05, Dan Mueller wrote: > Excuse any misunderstanding on my part however... Isn't expected behavior such > that the actual archive process will back up any logs that it needs to be able > to restore as of the archive checkpoint taken at the beginning of the archive? > I do not believe what you are explaining is expected behavior at all and would > escalate that PMR to the next level. I just do not believe what you were told > and would love to know where this went from here as I am sure others would > also. > > Thanx, > Dan > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Cesar > Inacio Martins > Sent: Friday, January 20, 2012 6:54 AM > To: ids@iiug.org > Subject: Restore + Logical log - caution [25984] > > 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 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >