Re: Restore + Logical log - caution

I will try to check this. Thanks for the APAR. I don't understand it... You can backup the logical log with an open transaction, but it will not be re-used... As such, it's in the level 0... Why do you need to provide something that's still in the engine? I suppose I'm missing something.... If anybody spots what it is,don't hesitate to clarify... meanwhile I'll take a look at the APAR... Regards On Fri, Jan 20, 2012 at 12:26 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > 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. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --00248c769136d0879e04b6fa26b7

Cesar: When you say "restore" can you explain the sequence of commands you used? Thanks! On Fri, Jan 20, 2012 at 6:50 PM, Fernando Nunes <domusonline@gmail.com>wrote: > I will try to check this. Thanks for the APAR. I don't understand it... You > can backup the logical log with an open transaction, but it will not be > re-used... As such, it's in the level 0... > Why do you need to provide something that's still in the engine? > I suppose I'm missing something.... If anybody spots what it is,don't > hesitate to clarify... meanwhile I'll take a look at the APAR... > > Regards > > On Fri, Jan 20, 2012 at 12:26 PM, Cesar Inacio Martins < > cesar_inacio_martins@yahoo.com.br> wrote: > > > 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. > > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --00248c769136d0879e04b6fa26b7 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf303b42d39a035e04b6faad0b

I will comment/answering the messages of Fernando , Madson and Art... Fernando, I will try keep simple... When you take a Archive Level 0 , as far I know the idea is, all logical logs backuped (file/tape) before this archive could be lost and you don`t need to worry because all you need is inside of your archive level 0 (physical and logical logs). But when you restore your database with logs, the engine reclaim for logical logs backuped before the archive (the same logical logs what already is inside of the same archive level 0). So if you don`t have the tape/files of this logical logs you will have a big problem... Madson, I understand what you said and I agree, but the logical log requested by the ontape (during the logical log restore) already is available on archive restored (I checked with onstat -l + onlog)... so why reclaim for a tape/file what you already have? Art, on my situation I checked and all logical logs from the "oldest" open TX are available when the physical restore finished (checked with onstat -l + onlog)... so , what Madson says will works fine. The problemis, if you want continue restoring more logical logs backuped after this archive, you will need the files/tapes of logical logs backuped since the "oldest" TX open (here is the problem) and this logs you already have restored and available... On 01/20/2012 05:28 PM, Fernando Nunes wrote: > Cesar: When you say "restore" can you explain the sequence of commands you > used? > Thanks! > > On Fri, Jan 20, 2012 at 6:50 PM, Fernando Nunes<domusonline@gmail.com>wrote: > >> I will try to check this. Thanks for the APAR. I don't understand it... You >> can backup the logical log with an open transaction, but it will not be >> re-used... As such, it's in the level 0... >> Why do you need to provide something that's still in the engine? >> I suppose I'm missing something.... If anybody spots what it is,don't >> hesitate to clarify... meanwhile I'll take a look at the APAR... >> >> Regards >> >> On Fri, Jan 20, 2012 at 12:26 PM, Cesar Inacio Martins< >> cesar_inacio_martins@yahoo.com.br> wrote: >> >>> 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. >>>> >>>> >>>> >>> >> >

Cesar.... sorry.... But what commands did you run? AFAIK a simple "ontape -r" will restore and will not ask for the tape where the "old" log is. It will ask you if you have more log tapes... I'd like to understand how the restore is being done... It was not clear to me on the PMR, but I confess it is a bit long and I was working on something while looking into this... Regards On Fri, Jan 20, 2012 at 9:59 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > I will comment/answering the messages of Fernando , Madson and Art... > > Fernando, I will try keep simple... > When you take a Archive Level 0 , as far I know the idea is, all logical > logs backuped (file/tape) before this archive could be lost and you > don`t need to worry because all you need is inside of your archive level > 0 (physical and logical logs). > But when you restore your database with logs, the engine reclaim for > logical logs backuped before the archive (the same logical logs what > already is inside of the same archive level 0). So if you don`t have the > tape/files of this logical logs you will have a big problem... > > Madson, I understand what you said and I agree, but the logical log > requested by the ontape (during the logical log restore) already is > available on archive restored (I checked with onstat -l + onlog)... so > why reclaim for a tape/file what you already have? > > Art, on my situation I checked and all logical logs from the "oldest" > open TX are available when the physical restore finished (checked with > onstat -l + onlog)... so , what Madson says will works fine. The problem> is, if you want continue restoring more logical logs backuped after this > archive, you will need the files/tapes of logical logs backuped since > the "oldest" TX open (here is the problem) and this logs you already > have restored and available... > > On 01/20/2012 05:28 PM, Fernando Nunes wrote: > > Cesar: When you say "restore" can you explain the sequence of commands > you > > used? > > Thanks! > > > > On Fri, Jan 20, 2012 at 6:50 PM, Fernando Nunes<domusonline@gmail.com > >wrote: > > > >> I will try to check this. Thanks for the APAR. I don't understand it... > You > >> can backup the logical log with an open transaction, but it will not be > >> re-used... As such, it's in the level 0... > >> Why do you need to provide something that's still in the engine? > >> I suppose I'm missing something.... If anybody spots what it is,don't > >> hesitate to clarify... meanwhile I'll take a look at the APAR... > >> > >> Regards > >> > >> On Fri, Jan 20, 2012 at 12:26 PM, Cesar Inacio Martins< > >> cesar_inacio_martins@yahoo.com.br> wrote: > >> > >>> 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. > >>>> > >>>

Hi Fernando, I test all situations. At first, I get the situation trying to do a CLR ... ontape -p + ontape -l -CThen I try a Physical Restore + log restore ontape -p + ontape -lThen I try a full restore.. in this case I answer No for restore level 1 and Yes to restore the Logical Log. ontape -r In all situations the engine request the backup of logical log take before the archive level 0. The log where the oldest transactions was opened... I don' t try simulate manually because I have the situation over the production constantly . Anyway appear be easy to simulate... - open a session + a transaction , keep it opened. - force with some way fill new logical logs - take a archive level 0 (here , all logical logs , since the open transaction should be included into the archive). - try restore this archive level 0 and see what logical log the engine will effective request. I just don' t found any way to continue the restore without give to them the logs requested... ________________________________ De: Fernando Nunes <domusonline@gmail.com> Para: ids@iiug.org Enviadas: Sexta-feira, 20 de Janeiro de 2012 21:58 Assunto: Re: Restore + Logical log - caution [26010] Cesar.... sorry.... But what commands did you run? AFAIK a simple "ontape -r" will restore and will not ask for the tape where the "old" log is. It will ask you if you have more log tapes... I'd like to understand how the restore is being done... It was not clear to me on the PMR, but I confess it is a bit long and I was working on something while looking into this... Regards On Fri, Jan 20, 2012 at 9:59 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > I will comment/answering the messages of Fernando , Madson and Art... > > Fernando, I will try keep simple... > When you take a Archive Level 0 , as far I know the idea is, all logical > logs backuped (file/tape) before this archive could be lost and you > don`t need to worry because all you need is inside of your archive level > 0 (physical and logical logs). > But when you restore your database with logs, the engine reclaim for > logical logs backuped before the archive (the same logical logs what > already is inside of the same archive level 0). So if you don`t have the > tape/files of this logical logs you will have a big problem... > > Madson, I understand what you said and I agree, but the logical log > requested by the ontape (during the logical log restore) already is > available on archive restored (I checked with onstat -l + onlog)... so > why reclaim for a tape/file what you already have? > > Art, on my situation I checked and all logical logs from the "oldest" > open TX are available when the physical restore finished (checked with > onstat -l + onlog)... so , what Madson says will works fine. The problem> is, if you want continue restoring more logical logs backuped after this > archive, you will need the files/tapes of logical logs backuped since > the "oldest" TX open (here is the problem) and this logs you already > have restored and available... > > On 01/20/2012 05:28 PM, Fernando Nunes wrote: > > Cesar: When you say "restore" can you explain the sequence of commands > you > > used? > > Thanks! > > > > On Fri, Jan 20, 2012 at 6:50 PM, Fernando Nunes<domusonline@gmail.com > >wrote: > > > >> I will try to check this. Thanks for the APAR. I don't understand it... > You > >> can backup the logical log with an open transaction, but it will not be > >> re-used... As such, it's in the level 0... > >> Why do you need to provide something that's still in the engine? > >> I suppose I'm missing something.... If anybody spots what it is,don't > >> hesitate to clarify... meanwhile I'll take a look at the APAR... > >> > >> Regards > >> > >> On Fri, Jan 20, 2012 at 12:26 PM, Cesar Inacio Martins< > >> cesar_inacio_martins@yahoo.com.br> wrote: > >> > >>> 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 >