How to Restore Level 1 backup after level 0

Hi, let assume, today is Friday and i have level zero backup of Monday and level 1 backup of Wednesday. Now i restored Level 0 backup on an instance via ontape -r, it was done successfully.Now i also want to restore level 1 backup. How is it possible? to restore level 1 backup after successful completion of level 0. Thanks.

If you ran ontape -r, then when it has completed the Level 0 restore, it will prompt you whether you want to restore a Level 1. If you used the "-d" option to restore from a directory, then ontape will look for the Level 1 archive file in the TAPEDEV directory - same as with the Level 0. If it exists, then ontape will restore from the Level 1 archive when the Level 0 is done. Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUNAWAR AHMED Sent: Friday, February 16, 2018 5:44 AM To: ids@iiug.org Subject: How to Restore Level 1 backup after level 0 [40693] Hi, let assume, today is Friday and i have level zero backup of Monday and level 1 backup of Wednesday. Now i restored Level 0 backup on an instance via ontape -r, it was done successfully.Now i also want to restore level 1 backup. How is it possible? to restore level 1 backup after successful completion of level 0. Thanks. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Its means if i restore level 0 via ontape -r,and it completed successful. now after sometime someone said to restore level 1 too. i can do it via ontape -d ?

No, unfortunately not. Once the instance has been brought up following the restore it will have written to logs, and any level 1 archive is no longer valid. Also ontape does not have an option to restore only a Level 1 (unlike the backup which, of course, allows you specify the level). -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUNAWAR AHMED Sent: Friday, February 16, 2018 6:33 AM To: ids@iiug.org Subject: Re: How to Restore Level 1 backup after level 0 [40695] Its means if i restore level 0 via ontape -r,and it completed successful. now after sometime someone said to restore level 1 too. i can do it via ontape -d ? **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, see Mike Walker's answer. A little bit of (simplified) background: Backup is divided into backup of dbspaces and backup of logical logs. The backup of dbspaces can be of level 0, 1 or 2. The backup of logical logs is recommended but not strictly necessary. In a similar way, the restore is divided into two parts: physical restore and logical restore. You need to start a restore with the physical restore of a level 0 backup. This copies the data in the level 0 backup to disk. After this you can restore a level 1 (or a level 2) backup. Once this is done, the data is on disk, but it's state is not logically consistent. This is because at the time of the backup there may have been some open transaction(s). Therefore the logical part of the restore is necessary. At a minimum this needs to check whether there were open transactions ... and roll them back. However, there is the option to first restore logical logs that have been backed up after the level 0, 1 or 2 backup of dbaspaces was done. This way it is not only possible to restore the system just to the point when the last level 0, 1 or 2 backup of dbspaces was done. Provided logical logs were backed up afterwards (i.e. as they were filled by ongoing transactions), these logical logs can be restored. Their log records (of those ongoing transactions) can be rolled forward. Once there are no more logical logs to restore, the same thing needs to happen to finish the restore: check whether there are open transactions and roll them back. With that the system then is logically consistent and can be used again. The "catch" with this system is: all physical restore parts (level 0, 1 and 2) must be done before the system starts to treat logical log records, either to roll forward log records from restored logical logs, or just to rollback open transactions (without restore of logical logs). Once the system starts with the logical log record part (even if there is nothing to do because there were no open transactions at the time of the backup) ... it is no longer possible to do a physical restore of any level 1 or 2 backup. That's why in manual operation "ontape" asks for any level 1 (or level 2) restore before it starts looking at logical log records. Any level 1 (or level 2) backup must be restored at this point. Regards, Martin -- Martin Fuerderer Informix Development Germany e-mail: martin.furderer@hcl.com HCL Technologies Germany GmbH Frankfurter Ring 17 80807 Munich, Germany http://www.hcltech.com/de --DISCLAIMER-- -------------------------------------------------------------------------------- ---------------------------- This document is intended for transmission to the named recipient only. If you are not that person, you should note that legal rights reside in this document and you are not authorized to access, read, disclose, copy, use or otherwise deal with it and any such actions are prohibited and may be unlawful. The views expressed in this document are not necessarily those of HCL Technologies Ltd. Notice is hereby given that no representation, contract or other binding obligation shall be created by this e-mail, which must be interpreted accordingly. Any representations, contractual rights or obligations shall be separately communicated in writing and signed in the original by a duly authorized officer of the relevant company. -------------------------------------------------------------------------------- ---------------------------- ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of MUNAWAR AHMED <mahmed04@i2cinc.com> Sent: Friday, February 16, 2018 13:43 To: ids@iiug.org Subject: How to Restore Level 1 backup after level 0 [40693] Hi, let assume, today is Friday and i have level zero backup of Monday and level 1 backup of Wednesday. Now i restored Level 0 backup on an instance via ontape -r, it was done successfully.Now i also want to restore level 1 backup. How is it possible? to restore level 1 backup after successful completion of level 0. Thanks. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ::DISCLAIMER:: -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects. -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------