IDS Forum

Re: RE: Restoring Level 0 Backup Without Logs

Posted By: Art Kagel
Date: Saturday, 31 January 2015, at 6:49 p.m.

In Response To: RE: RE: Restoring Level 0 Backup Without Logs (Ekstrand, Pamela A. -ND)

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

Messages In This Thread

• Restoring Level 0 Backup Without Logs
  Ekstrand, Pamela A. -ND -- Thursday, 29 January 2015, at 4:54 p.m.
  • Re: Restoring Level 0 Backup Without Logs
    Keith Simmons -- Thursday, 29 January 2015, at 5:32 p.m.
    • RE: Restoring Level 0 Backup Without Logs
      Ekstrand, Pamela A. -ND -- Thursday, 29 January 2015, at 5:41 p.m.
      • Re: Restoring Level 0 Backup Without Logs
        Keith Simmons -- Thursday, 29 January 2015, at 5:55 p.m.
        • Re: Restoring Level 0 Backup Without Logs
          Art Kagel -- Thursday, 29 January 2015, at 6:06 p.m.
          • RE: Restoring Level 0 Backup Without Logs
            Ekstrand, Pamela A. -ND -- Thursday, 29 January 2015, at 6:13 p.m.
            • Re: Restoring Level 0 Backup Without Logs
              Malc P -- Thursday, 29 January 2015, at 7:15 p.m.
            • Re: RE: Restoring Level 0 Backup Without Logs
              MARK JALKIEWICZ -- Friday, 30 January 2015, at 11:49 a.m.
              • RE: RE: Restoring Level 0 Backup Without Logs
                Ekstrand, Pamela A. -ND -- Friday, 30 January 2015, at 12:13 p.m.
              • RE: RE: Restoring Level 0 Backup Without Logs
                Ekstrand, Pamela A. -ND -- Friday, 30 January 2015, at 6:10 p.m.
                • Re: RE: Restoring Level 0 Backup Without Logs
                  Art Kagel -- Saturday, 31 January 2015, at 6:49 p.m.
    • RE: Restoring Level 0 Backup Without Logs
      Ekstrand, Pamela A. -ND -- Thursday, 29 January 2015, at 5:43 p.m.
      • Re: Restoring Level 0 Backup Without Logs
        Art Kagel -- Thursday, 29 January 2015, at 5:51 p.m.
  • Re: Restoring Level 0 Backup Without Logs
    Art Kagel -- Thursday, 29 January 2015, at 5:38 p.m.
    • RE: Restoring Level 0 Backup Without Logs
      Ekstrand, Pamela A. -ND -- Thursday, 29 January 2015, at 5:46 p.m.
      • Re: Restoring Level 0 Backup Without Logs
        Art Kagel -- Thursday, 29 January 2015, at 5:55 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.