Restoring Level 0 Backup Without Logs ✗ Answered: red (solid confidence) — After multiple attempted approaches (onbar -r, hand-edited ixbar, archecker, oninit -r/-PHY) all failed to bring the instance up without the missing logical logs, the thread ends on Art Kagel's untested 'might work' suggestion (onmode -m) with no confirmed success.

Advisory only.

All, We have an instance that was decommissioned 6 months ago, and now there is a need for it again. We have the level 0 backup, but the logs are not saved that long. This is not a whole system backup with the -w flag. The engine was running under version 10, which of course is no longer supported. Does anyone have any ideas as to whether there is any possible way to get this data restored and bring up the engine without the logs and without IBM dialing in to override the need for the logs? Thanks. Pam

Pam How was this backup taken ? If it was using ontape then a straight restore will get back to the position at the start of the original archive and there is no requirement to roll logs forward (but of course the last thing you did before shutting the engine down was to take a final archive wasn't it :-) ). Of course you need to have the original engine software installed and the correct number and size of chunks available. Keith On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > All, > > We have an instance that was decommissioned 6 months ago, and now there is > a > need for it again. > > We have the level 0 backup, but the logs are not saved that long. This is > not > a whole system backup with the -w flag. > > The engine was running under version 10, which of course is no longer > supported. > > Does anyone have any ideas as to whether there is any possible way to get > this > data restored and bring up the engine without the logs and without IBM > dialing > in to override the need for the logs? > > Thanks. > > Pam > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11352e2ac35dfb050dd20e24

Do you need the whole server or just a table or two? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 29, 2015 at 4:54 PM, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > All, > > We have an instance that was decommissioned 6 months ago, and now there is > a > need for it again. > > We have the level 0 backup, but the logs are not saved that long. This is > not > a whole system backup with the -w flag. > > The engine was running under version 10, which of course is no longer > supported. > > Does anyone have any ideas as to whether there is any possible way to get > this > data restored and bring up the engine without the logs and without IBM > dialing > in to override the need for the logs? > > Thanks. > > Pam > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c315e85cc819050dd22554

Keith, The backup was taken with onbar. We do still have the software installed, and the storage is available. Thanks. ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith Simmons [smiley73@gmail.com] Sent: Thursday, January 29, 2015 5:32 PM To: ids@iiug.org Subject: Re: Restoring Level 0 Backup Without Logs [34537] Pam How was this backup taken ? If it was using ontape then a straight restore will get back to the position at the start of the original archive and there is no requirement to roll logs forward (but of course the last thing you did before shutting the engine down was to take a final archive wasn't it :-) ). Of course you need to have the original engine software installed and the correct number and size of chunks available. Keith On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > All, > > We have an instance that was decommissioned 6 months ago, and now there is > a > need for it again. > > We have the level 0 backup, but the logs are not saved that long. This is > not > a whole system backup with the -w flag. > > The engine was running under version 10, which of course is no longer > supported. > > Does anyone have any ideas as to whether there is any possible way to get > this > data restored and bring up the engine without the logs and without IBM > dialing > in to override the need for the logs? > > Thanks. > > Pam > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11352e2ac35dfb050dd20e24 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Also wondering if archecker could be used to restore the instance, without providing the original schema? It looks like you can do a physical only restore with archecker. Thanks for your quick replies. ________________________________________ From: Ekstrand, Pamela A. -ND Sent: Thursday, January 29, 2015 5:39 PM To: ids@iiug.org Subject: RE: Restoring Level 0 Backup Without Logs [34537] Keith, The backup was taken with onbar. We do still have the software installed, and the storage is available. Thanks. ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith Simmons [smiley73@gmail.com] Sent: Thursday, January 29, 2015 5:32 PM To: ids@iiug.org Subject: Re: Restoring Level 0 Backup Without Logs [34537] Pam How was this backup taken ? If it was using ontape then a straight restore will get back to the position at the start of the original archive and there is no requirement to roll logs forward (but of course the last thing you did before shutting the engine down was to take a final archive wasn't it :-) ). Of course you need to have the original engine software installed and the correct number and size of chunks available. Keith On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > All, > > We have an instance that was decommissioned 6 months ago, and now there is > a > need for it again. > > We have the level 0 backup, but the logs are not saved that long. This is > not > a whole system backup with the -w flag. > > The engine was running under version 10, which of course is no longer > supported. > > Does anyone have any ideas as to whether there is any possible way to get > this > data restored and bring up the engine without the logs and without IBM > dialing > in to override the need for the logs? > > Thanks. > > Pam > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11352e2ac35dfb050dd20e24 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Art, I need the whole instance. Could I use the physical only option of archecker to restore it? Thanks. ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Art Kagel [art.kagel@gmail.com] Sent: Thursday, January 29, 2015 5:38 PM To: ids@iiug.org Subject: Re: Restoring Level 0 Backup Without Logs [34538] Do you need the whole server or just a table or two? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 29, 2015 at 4:54 PM, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > All, > > We have an instance that was decommissioned 6 months ago, and now there is > a > need for it again. > > We have the level 0 backup, but the logs are not saved that long. This is > not > a whole system backup with the -w flag. > > The engine was running under version 10, which of course is no longer > supported. > > Does anyone have any ideas as to whether there is any possible way to get > this > data restored and bring up the engine without the logs and without IBM > dialing > in to override the need for the logs? > > Thanks. > > Pam > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c315e85cc819050dd22554 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Yes, Pam. That's where my question came in. It's not practical to restore many many tables using archecker (though possible) but if there are only a few tables required it can be done. You would set up a new, clean instance and use archecker to extract data from the archive to new tables. You will need to know the schema of the tables you need to recover however. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 29, 2015 at 5:43 PM, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > Also wondering if archecker could be used to restore the instance, without > providing the original schema? It looks like you can do a physical only > restore with archecker. > > Thanks for your quick replies. > > ________________________________________ > From: Ekstrand, Pamela A. -ND > Sent: Thursday, January 29, 2015 5:39 PM > To: ids@iiug.org > Subject: RE: Restoring Level 0 Backup Without Logs [34537] > > Keith, > > The backup was taken with onbar. We do still have the software installed, > and > the storage is available. > > Thanks. > > ________________________________________ > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith > Simmons > [smiley73@gmail.com] > Sent: Thursday, January 29, 2015 5:32 PM > To: ids@iiug.org > Subject: Re: Restoring Level 0 Backup Without Logs [34537] > > Pam > > How was this backup taken ? If it was using ontape then a straight restore > will get back to the position at the start of the original archive and > there is no requirement to roll logs forward (but of course the last thing > you did before shutting the engine down was to take a final archive wasn't > it :-) ). > Of course you need to have the original engine software installed and the > correct number and size of chunks available. > > Keith > > On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > All, > > > > We have an instance that was decommissioned 6 months ago, and now there > is > > a > > need for it again. > > > > We have the level 0 backup, but the logs are not saved that long. This is > > not > > a whole system backup with the -w flag. > > > > The engine was running under version 10, which of course is no longer > > supported. > > > > Does anyone have any ideas as to whether there is any possible way to get > > this > > data restored and bring up the engine without the logs and without IBM > > dialing > > in to override the need for the logs? > > > > Thanks. > > > > Pam > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11352e2ac35dfb050dd20e24 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3a819298924c050dd24f6a

You can, but it is tedious and time consuming. You have to create schemas for each table that archecker needs to recover and create a target table to hold the data for each source table in a clean database. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 29, 2015 at 5:46 PM, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > Art, > > I need the whole instance. > > Could I use the physical only option of archecker to restore it? > > Thanks. > ________________________________________ > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Art Kagel > [art.kagel@gmail.com] > Sent: Thursday, January 29, 2015 5:38 PM > To: ids@iiug.org > Subject: Re: Restoring Level 0 Backup Without Logs [34538] > > Do you need the whole server or just a table or two? > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Thu, Jan 29, 2015 at 4:54 PM, Ekstrand, Pamela A. -ND < > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > All, > > > > We have an instance that was decommissioned 6 months ago, and now there > is > > a > > need for it again. > > > > We have the level 0 backup, but the logs are not saved that long. This is > > not > > a whole system backup with the -w flag. > > > > The engine was running under version 10, which of course is no longer > > supported. > > > > Does anyone have any ideas as to whether there is any possible way to get > > this > > data restored and bring up the engine without the logs and without IBM > > dialing > > in to override the need for the logs? > > > > Thanks. > > > > Pam > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c315e85cc819050dd22554 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1132f49aa68b6e050dd25c8f

Pam Sorry, not an onbar user but I believe the same principle cn be applied, just restore the whole server and you need not roll logs in if they are not available. Keith On 29 January 2015 at 22:41, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > Keith, > > The backup was taken with onbar. We do still have the software installed, > and > the storage is available. > > Thanks. > > ________________________________________ > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith > Simmons > [smiley73@gmail.com] > Sent: Thursday, January 29, 2015 5:32 PM > To: ids@iiug.org > Subject: Re: Restoring Level 0 Backup Without Logs [34537] > > Pam > > How was this backup taken ? If it was using ontape then a straight restore > will get back to the position at the start of the original archive and > there is no requirement to roll logs forward (but of course the last thing > you did before shutting the engine down was to take a final archive wasn't > it :-) ). > Of course you need to have the original engine software installed and the > correct number and size of chunks available. > > Keith > > On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > All, > > > > We have an instance that was decommissioned 6 months ago, and now there > is > > a > > need for it again. > > > > We have the level 0 backup, but the logs are not saved that long. This is > > not > > a whole system backup with the -w flag. > > > > The engine was running under version 10, which of course is no longer > > supported. > > > > Does anyone have any ideas as to whether there is any possible way to get > > this > > data restored and bring up the engine without the logs and without IBM > > dialing > > in to override the need for the logs? > > > > Thanks. > > > > Pam > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11352e2ac35dfb050dd20e24 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1134b562dac5ae050dd25f76

Not so simple Keith. Pam indicates that the archive was not a full server archive (ie with -w) so each dbspace was archived at a different timestamp and onbar depends on the logs to sync them to the same point in time on restore. Unlike ontape or an onbar restore of a -w archive, a dbspace archive from onbar cannot be restored to create a working server without logical logs available. Pam: Because of the nature of the archive, after you restore the tables with archecker, there will be inconsistencies (orphaned child records) that you will have to resolve if any tables in one dbspace depended on tables in another dbspace. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 29, 2015 at 5:55 PM, Keith Simmons <smiley73@gmail.com> wrote: > Pam > > Sorry, not an onbar user but I believe the same principle cn be applied, > just restore the whole server and you need not roll logs in if they are not > available. > > Keith > > On 29 January 2015 at 22:41, Ekstrand, Pamela A. -ND < > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > Keith, > > > > The backup was taken with onbar. We do still have the software installed, > > and > > the storage is available. > > > > Thanks. > > > > ________________________________________ > > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith > > Simmons > > [smiley73@gmail.com] > > Sent: Thursday, January 29, 2015 5:32 PM > > To: ids@iiug.org > > Subject: Re: Restoring Level 0 Backup Without Logs [34537] > > > > Pam > > > > How was this backup taken ? If it was using ontape then a straight > restore > > will get back to the position at the start of the original archive and > > there is no requirement to roll logs forward (but of course the last > thing > > you did before shutting the engine down was to take a final archive > wasn't > > it :-) ). > > Of course you need to have the original engine software installed and the > > correct number and size of chunks available. > > > > Keith > > > > On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < > > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > > > All, > > > > > > We have an instance that was decommissioned 6 months ago, and now there > > is > > > a > > > need for it again. > > > > > > We have the level 0 backup, but the logs are not saved that long. This > is > > > not > > > a whole system backup with the -w flag. > > > > > > The engine was running under version 10, which of course is no longer > > > supported. > > > > > > Does anyone have any ideas as to whether there is any possible way to > get > > > this > > > data restored and bring up the engine without the logs and without IBM > > > dialing > > > in to override the need for the logs? > > > > > > Thanks. > > > > > > Pam > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a11352e2ac35dfb050dd20e24 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1134b562dac5ae050dd25f76 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1132f49aacdf1f050dd28524

Interesting, IBM just advised me that onbar -r should work, even without the logs. I won't have the tapes until tomorrow to try anything, but any and all suggestions are welcome. Thanks again, all. ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Art Kagel [art.kagel@gmail.com] Sent: Thursday, January 29, 2015 6:06 PM To: ids@iiug.org Subject: Re: Restoring Level 0 Backup Without Logs [34545] Not so simple Keith. Pam indicates that the archive was not a full server archive (ie with -w) so each dbspace was archived at a different timestamp and onbar depends on the logs to sync them to the same point in time on restore. Unlike ontape or an onbar restore of a -w archive, a dbspace archive from onbar cannot be restored to create a working server without logical logs available. Pam: Because of the nature of the archive, after you restore the tables with archecker, there will be inconsistencies (orphaned child records) that you will have to resolve if any tables in one dbspace depended on tables in another dbspace. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jan 29, 2015 at 5:55 PM, Keith Simmons <smiley73@gmail.com> wrote: > Pam > > Sorry, not an onbar user but I believe the same principle cn be applied, > just restore the whole server and you need not roll logs in if they are not > available. > > Keith > > On 29 January 2015 at 22:41, Ekstrand, Pamela A. -ND < > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > Keith, > > > > The backup was taken with onbar. We do still have the software installed, > > and > > the storage is available. > > > > Thanks. > > > > ________________________________________ > > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith > > Simmons > > [smiley73@gmail.com] > > Sent: Thursday, January 29, 2015 5:32 PM > > To: ids@iiug.org > > Subject: Re: Restoring Level 0 Backup Without Logs [34537] > > > > Pam > > > > How was this backup taken ? If it was using ontape then a straight > restore > > will get back to the position at the start of the original archive and > > there is no requirement to roll logs forward (but of course the last > thing > > you did before shutting the engine down was to take a final archive > wasn't > > it :-) ). > > Of course you need to have the original engine software installed and the > > correct number and size of chunks available. > > > > Keith > > > > On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < > > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > > > All, > > > > > > We have an instance that was decommissioned 6 months ago, and now there > > is > > > a > > > need for it again. > > > > > > We have the level 0 backup, but the logs are not saved that long. This > is > > > not > > > a whole system backup with the -w flag. > > > > > > The engine was running under version 10, which of course is no longer > > > supported. > > > > > > Does anyone have any ideas as to whether there is any possible way to > get > > > this > > > data restored and bring up the engine without the logs and without IBM > > > dialing > > > in to override the need for the logs? > > > > > > Thanks. > > > > > > Pam > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a11352e2ac35dfb050dd20e24 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1134b562dac5ae050dd25f76 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1132f49aacdf1f050dd28524 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Can you not use "-r -p" for physical-only restore? On Thu, Jan 29, 2015 at 11:13 PM, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > Interesting, IBM just advised me that onbar -r should work, even without > the > logs. > > I won't have the tapes until tomorrow to try anything, but any and all > suggestions are welcome. > > Thanks again, all. > ________________________________________ > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Art Kagel > [art.kagel@gmail.com] > Sent: Thursday, January 29, 2015 6:06 PM > To: ids@iiug.org > Subject: Re: Restoring Level 0 Backup Without Logs [34545] > > Not so simple Keith. Pam indicates that the archive was not a full server > archive (ie with -w) so each dbspace was archived at a different timestamp > and onbar depends on the logs to sync them to the same point in time on > restore. Unlike ontape or an onbar restore of a -w archive, a dbspace > archive from onbar cannot be restored to create a working server without > logical logs available. > > Pam: Because of the nature of the archive, after you restore the tables > with archecker, there will be inconsistencies (orphaned child records) that > you will have to resolve if any tables in one dbspace depended on tables in > another dbspace. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Thu, Jan 29, 2015 at 5:55 PM, Keith Simmons <smiley73@gmail.com> wrote: > > > Pam > > > > Sorry, not an onbar user but I believe the same principle cn be applied, > > just restore the whole server and you need not roll logs in if they are > not > > available. > > > > Keith > > > > On 29 January 2015 at 22:41, Ekstrand, Pamela A. -ND < > > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > > > Keith, > > > > > > The backup was taken with onbar. We do still have the software > installed, > > > and > > > the storage is available. > > > > > > Thanks. > > > > > > ________________________________________ > > > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Keith > > > Simmons > > > [smiley73@gmail.com] > > > Sent: Thursday, January 29, 2015 5:32 PM > > > To: ids@iiug.org > > > Subject: Re: Restoring Level 0 Backup Without Logs [34537] > > > > > > Pam > > > > > > How was this backup taken ? If it was using ontape then a straight > > restore > > > will get back to the position at the start of the original archive and > > > there is no requirement to roll logs forward (but of course the last > > thing > > > you did before shutting the engine down was to take a final archive > > wasn't > > > it :-) ). > > > Of course you need to have the original engine software installed and > the > > > correct number and size of chunks available. > > > > > > Keith > > > > > > On 29 January 2015 at 21:54, Ekstrand, Pamela A. -ND < > > > Pamela.A.Ekstrand.-ND@disney.com> wrote: > > > > > > > All, > > > > > > > > We have an instance that was decommissioned 6 months ago, and now > there > > > is > > > > a > > > > need for it again. > > > > > > > > We have the level 0 backup, but the logs are not saved that long. > This > > is > > > > not > > > > a whole system backup with the -w flag. > > > > > > > > The engine was running under version 10, which of course is no longer > > > > supported. > > > > > > > > Does anyone have any ideas as to whether there is any possible way to > > get > > > > this > > > > data restored and bring up the engine without the logs and without > IBM > > > > dialing > > > > in to override the need for the logs? > > > > > > > > Thanks. > > > > > > > > Pam > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --001a11352e2ac35dfb050dd20e24 > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a1134b562dac5ae050dd25f76 > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1132f49aacdf1f050dd28524 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0434c0ba82beab050dd3819e

While supportiung SAP we did encounter similar issues occasionally. Hopefully someone from Informix AS can chime in here as I am stale with respect to onbar. Carefull with onbar -r. With that version onbar -r will parse the ixbar.xxx file and want all logs in that file after the level 0 that is used. You will need to edit that file (back it up first) and remove all the logical logs that were backed up but you not longer have. Essentially all you want in that file are ALL the level 0 dbspaces objects and the logs up to the logical log that was current when the last dbspace was backed up for that level 0 event. There should be something in the ixbar file that indicates what the log id # was/is. Issue either onbar -r -n xxxx (log # form above) and hopefully after the last dbspace is restored onbar should only roll forward till the log # you enter. This may work since the engine places on the physical portion of the tape all the logical logs that have open transactions when the archive begins. Since dbspaces are backed up in parallel there is a outside chance that the log you need to roll forward to was part of that set of logs (the restore process should laydown those logs in the logdbs after restoring the critical dbspaces). So you should know quick enough if this will work by issuing an onstat -l after the critical dbspaces are restored. If you see that log thengreat. If not then that means that too many logs were filled from when the critical dbspaces were backed up and the last dbspace backup began. You can test this first by issuing an onbar -r -p <the three critical dbspaces only> and see what gets put in logdbs. If the log is there then redo the entire restore using onbar -r -n xxxx (omit the 'p'). Good luck, Mark

Thanks, Mark. I am still waiting for the tapes for the level 0 to get back onsite. We do not have any of the log backups. However, this is an instance that was very rarely updated, so I am hoping that ontape -r will work, but I guess we will see. I have edited a copy of the ixbar file to have only the entries for the dbspaces. Pam ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of MARK JALKIEWICZ [mark.jalkiewicz@verizon.net] Sent: Friday, January 30, 2015 11:49 AM To: ids@iiug.org Subject: Re: RE: Restoring Level 0 Backup Without Logs [34548] While supportiung SAP we did encounter similar issues occasionally. Hopefully someone from Informix AS can chime in here as I am stale with respect to onbar. Carefull with onbar -r. With that version onbar -r will parse the ixbar.xxx file and want all logs in that file after the level 0 that is used. You will need to edit that file (back it up first) and remove all the logical logs that were backed up but you not longer have. Essentially all you want in that file are ALL the level 0 dbspaces objects and the logs up to the logical log that was current when the last dbspace was backed up for that level 0 event. There should be something in the ixbar file that indicates what the log id # was/is. Issue either onbar -r -n xxxx (log # form above) and hopefully after the last dbspace is restored onbar should only roll forward till the log # you enter. This may work since the engine places on the physical portion of the tape all the logical logs that have open transactions when the archive begins. Since dbspaces are backed up in parallel there is a outside chance that the log you need to roll forward to was part of that set of logs (the restore process should laydown those logs in the logdbs after restoring the critical dbspaces). So you should know quick enough if this will work by issuing an onstat -l after the critical dbspaces are restored. If you see that log thengreat. If not then that means that too many logs were filled from when the critical dbspaces were backed up and the last dbspace backup began. You can test this first by issuing an onbar -r -p <the three critical dbspaces only> and see what gets put in logdbs. If the log is there then redo the entire restore using onbar -r -n xxxx (omit the 'p'). Good luck, Mark ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

When I tried the restore with no log entries in the ixbar file, I immediately got a return code 126. I added the line for the log, and the physical part of the restore with onbar -r completed, but, as some have said, it is wanting the log to be restored, and we have no logs. I then tried shutting the instance down and then running oninit -r. It comes up in fast recovery in a blocked checkpoint, and the last line in the message log says it is in recovery mode. I also tried oninit -PHY after first bringing it down Does anyone know of anything else I can try, keeping in mind this is version 10? Thanks. ________________________________________ From: Ekstrand, Pamela A. -ND Sent: Friday, January 30, 2015 12:12 PM To: ids@iiug.org Subject: RE: RE: Restoring Level 0 Backup Without Logs [34548] Thanks, Mark. I am still waiting for the tapes for the level 0 to get back onsite. We do not have any of the log backups. However, this is an instance that was very rarely updated, so I am hoping that ontape -r will work, but I guess we will see. I have edited a copy of the ixbar file to have only the entries for the dbspaces. Pam ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of MARK JALKIEWICZ [mark.jalkiewicz@verizon.net] Sent: Friday, January 30, 2015 11:49 AM To: ids@iiug.org Subject: Re: RE: Restoring Level 0 Backup Without Logs [34548] While supportiung SAP we did encounter similar issues occasionally. Hopefully someone from Informix AS can chime in here as I am stale with respect to onbar. Carefull with onbar -r. With that version onbar -r will parse the ixbar.xxx file and want all logs in that file after the level 0 that is used. You will need to edit that file (back it up first) and remove all the logical logs that were backed up but you not longer have. Essentially all you want in that file are ALL the level 0 dbspaces objects and the logs up to the logical log that was current when the last dbspace was backed up for that level 0 event. There should be something in the ixbar file that indicates what the log id # was/is. Issue either onbar -r -n xxxx (log # form above) and hopefully after the last dbspace is restored onbar should only roll forward till the log # you enter. This may work since the engine places on the physical portion of the tape all the logical logs that have open transactions when the archive begins. Since dbspaces are backed up in parallel there is a outside chance that the log you need to roll forward to was part of that set of logs (the restore process should laydown those logs in the logdbs after restoring the critical dbspaces). So you should know quick enough if this will work by issuing an onstat -l after the critical dbspaces are restored. If you see that log thengreat. If not then that means that too many logs were filled from when the critical dbspaces were backed up and the last dbspace backup began. You can test this first by issuing an onbar -r -p <the three critical dbspaces only> and see what gets put in logdbs. If the log is there then redo the entire restore using onbar -r -n xxxx (omit the 'p'). Good luck, Mark ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

The only thing that MIGHT work would be to run onmode -m as soon as the restore finishes before doing anything else. With ontape that will usually force the server into fast recovery and mark the chunks online. Once you've shutdown the instance and tried to restart it that won't work. To try this you will have to go through the restore again. As I said, I don't know if this will work because of the parallel archive instead of a full server archive, but it's worth a try. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Jan 30, 2015 at 6:10 PM, Ekstrand, Pamela A. -ND < Pamela.A.Ekstrand.-ND@disney.com> wrote: > When I tried the restore with no log entries in the ixbar file, I > immediately > got a return code 126. I added the line for the log, and the physical part > of > the restore with onbar -r completed, but, as some have said, it is wanting > the > log to be restored, and we have no logs. > > I then tried shutting the instance down and then running oninit -r. It > comes > up in fast recovery in a blocked checkpoint, and the last line in the > message > log says it is in recovery mode. I also tried oninit -PHY after first > bringing > it down > > Does anyone know of anything else I can try, keeping in mind this is > version > 10? > > Thanks. > > ________________________________________ > From: Ekstrand, Pamela A. -ND > Sent: Friday, January 30, 2015 12:12 PM > To: ids@iiug.org > Subject: RE: RE: Restoring Level 0 Backup Without Logs [34548] > > Thanks, Mark. I am still waiting for the tapes for the level 0 to get back > onsite. > > We do not have any of the log backups. However, this is an instance that > was > very rarely updated, so I am hoping that ontape -r will work, but I guess > we > will see. I have edited a copy of the ixbar file to have only the entries > for > the dbspaces. > > Pam > > ________________________________________ > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of MARK > JALKIEWICZ > [mark.jalkiewicz@verizon.net] > Sent: Friday, January 30, 2015 11:49 AM > To: ids@iiug.org > Subject: Re: RE: Restoring Level 0 Backup Without Logs [34548] > > While supportiung SAP we did encounter similar issues occasionally. > Hopefully > someone from Informix AS can chime in here as I am stale with respect to > onbar. > > Carefull with onbar -r. With that version onbar -r will parse the ixbar.xxx > file and want all logs in that file after the level 0 that is used. You > will > need to edit that file (back it up first) and remove all the logical logs > that > were backed up but you not longer have. Essentially all you want in that > file > are ALL the level 0 dbspaces objects and the logs up to the logical log > that > was current when the last dbspace was backed up for that level 0 event. > There > should be something in the ixbar file that indicates what the log id # > was/is. > > Issue either onbar -r -n xxxx (log # form above) and hopefully after the > last > dbspace is restored onbar should only roll forward till the log # you > enter. > This may work since the engine places on the physical portion of the tape > all > the logical logs that have open transactions when the archive begins. Since > dbspaces are backed up in parallel there is a outside chance that the log > you > need to roll forward to was part of that set of logs (the restore process > should laydown those logs in the logdbs after restoring the critical > dbspaces). So you should know quick enough if this will work by issuing an > onstat -l after the critical dbspaces are restored. If you see that log> then > great. If not then that means that too many logs were filled from when the > critical dbspaces were backed up and the last dbspace backup began. You can > test this first by issuing an onbar -r -p <the three critical dbspaces > only> > and see what gets put in logdbs. If the log is there then redo the entire > restore using onbar -r -n xxxx (omit the 'p'). > > Good luck, > > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1134882ec7ecf1050dfb5f4a