IDS Forum

Re: Logical Log backup

Posted By: medkba
Date: Wednesday, 27 November 2013, at 3:43 a.m.

In Response To: Re: Logical Log backup (Khaled BENTEBAL)

IDS 11.50 FC9.

I may be use ontape due to we don't have TSM

On Wed, Nov 27, 2013 at 3:52 PM, Khaled BENTEBAL <
khaled.bentebal@consult-ix.fr> wrote:

> If you need point in time, you need to use onbar instead of ontape.
> Ontape can only recover full logs.
>
> In that case you need to set up a lot more things to use onbar and do you
> have
> a third party tool such as TSM or something else.
>
> What version of IDS are you using and what tool are you using to perform
> your
> backups?
>
> Khaled Bentebal de mon portable
>
> Le 27 nov. 2013 à 02:09, "medkba" <medkba@gmail.com> a écrit :
>
> > Art, Sorry, I didn't update this part. I am taking daily L0 backup
> > currently. We need to recover point in time that's why need to enable
> > logical log backup as well
> >
> > Thank you very much
> >
> > On Wed, Nov 27, 2013 at 12:46 AM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> >> If you only back up your logical logs once a day, then how will you
> recover
> >> if the server crashes hard? If it does that shortly before the script
> >> would have run, you will lose a full day's transactions when you restore
> >> your last full archive and cannot roll forward the logical logs to the
> last
> >> few minutes before the crash. Can your company afford that kind of data
> >> loss?
> >>
> >> Art
> >>
> >> Art S. Kagel, Principal Consultant
> >>
> >> Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Tue, Nov 26, 2013 at 11:37 AM, medkba <medkba@gmail.com> wrote:
> >>
> >>> Thank you very much
> >>>
> >>> I need to clarify below
> >>>
> >>> if i don't use alarmprogrm, Am I able to run shell script once a day?
> Is
> >> it
> >>> fine or still I need to set alaramprogram for this
> >>>
> >>> On Wed, Nov 27, 2013 at 12:03 AM, Marcus Haarmann <
> >>> marcus.haarmann@midoco.de
> >>>> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> we are using alarmprogram for such an action. That way, we do not have
> >> to
> >>>> worry about full logs:
> >>>> First, set the LTAPEDEV to a directory, make sure informix user can
> >> write
> >>>> to
> >>>> the dir.
> >>>>
> >>>> Modify the alarmprogram to call an external script (like
> >>>> /mylocation/backup_logs.sh).
> >>>> BACKUP_CMD="/mylocation/backup_logs.sh"
> >>>> BACKUPLOGS=Y
> >>>>
> >>>> In backup_logs.sh, you will get the correct environment
> >>>> (INFORMIXSERVER/INFORMIXDIR)
> >>>> and you can then call ontape -a:
> >>>> #!/bin/bash
> >>>> export PATH=${PATH}:${INFORMIXDIR}/bin
> >>>> LOGNO=$1
> >>>> (ontape -a -d 2>&1) > /tmp/backup.out.${LOGNO}
> >>>>
> >>>> This should backup your logs in a file whenever a log file becomes
> >> full.
> >>>> You can analyze the /tmp/backup.out.${LOGNO} file for errors and
> >> initiate
> >>>> a mail to admin in case of any problem.
> >>>>
> >>>> Hope this helps.
> >>>>
> >>>> Best regards,
> >>>>
> >>>> Marcus Haarmann
> >>>>
> >>>> ----- Ursprüngliche Mail -----
> >>>>
> >>>> Von: "medkba" <medkba@gmail.com>
> >>>> An: ids@iiug.org
> >>>> Gesendet: Dienstag, 26. November 2013 16:52:05
> >>>> Betreff: Logical Log backup [32030]
> >>>>
> >>>> I would like to take logical log backup and I have given ontape -c L
> >> and
> >>> it
> >>>> is taking continuous backup but I would like to run cron job and needs
> >> to
> >>>> complete job if any logical backup. May I use ontape -a L? I need to
> >> run
> >>>> once a day. If in case may be logical logs more after I have taken
> >> backup
> >>>> and how to run this ontap -a L
> >>>>
> >>>> Thank you very much
> >>>>
> >>>> --089e0122aefef7cd3504ec1675d3
> >
>
> *******************************************************************************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> *******************************************************************************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>> --089e012279a2090fe204ec16b3b7
> >
>
> *******************************************************************************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >> --001a1135e9d6c6005e04ec172597
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > --089e012279a2e0711f04ec1e3dae
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c2f7742de83e04ec2497a4

Messages In This Thread

• Logical Log backup
  medkba -- Tuesday, 26 November 2013, at 10:52 a.m.
  • Re: Logical Log backup
    Marcus Haarmann -- Tuesday, 26 November 2013, at 11:03 a.m.
    • Re: Logical Log backup
      medkba -- Tuesday, 26 November 2013, at 11:37 a.m.
      • Re: Logical Log backup
        Paul Watson -- Tuesday, 26 November 2013, at 11:39 a.m.
      • Re: Logical Log backup
        Art Kagel -- Tuesday, 26 November 2013, at 11:46 a.m.
        • Re: Logical Log backup
          medkba -- Tuesday, 26 November 2013, at 8:09 p.m.
          • Re: Logical Log backup
            Art Kagel -- Tuesday, 26 November 2013, at 8:48 p.m.
          • Re: Logical Log backup
            Khaled BENTEBAL -- Wednesday, 27 November 2013, at 2:52 a.m.
            • Re: Logical Log backup
              medkba -- Wednesday, 27 November 2013, at 3:43 a.m.
              • Re: Logical Log backup
                Lloyd S -- Wednesday, 27 November 2013, at 4:12 a.m.
      • Re: Logical Log backup
        Khaled Bentebal -- Tuesday, 26 November 2013, at 5:55 p.m.
        • Re: Logical Log backup
          medkba -- Tuesday, 26 November 2013, at 11:21 p.m.
          • Re: Logical Log backup
            Marcus Haarmann -- Wednesday, 27 November 2013, at 2:05 a.m.
          • Re: Logical Log backup
            Khaled BENTEBAL -- Wednesday, 27 November 2013, at 2:45 a.m.
          • Re: Logical Log backup
            Art Kagel -- Wednesday, 27 November 2013, at 6:25 a.m.
  • Re: Logical Log backup
    Art Kagel -- Tuesday, 26 November 2013, at 11:14 a.m.
    • Re: Logical Log backup
      medkba -- Tuesday, 26 November 2013, at 11:22 a.m.
      • Re: Logical Log backup
        Paul Watson -- Tuesday, 26 November 2013, at 11:27 a.m.
        • Re: Logical Log backup
          medkba -- Tuesday, 26 November 2013, at 11:31 a.m.
          • Re: Logical Log backup
            Paul Watson -- Tuesday, 26 November 2013, at 12:08 p.m.
      • Re: Logical Log backup
        Art Kagel -- Tuesday, 26 November 2013, at 11:30 a.m.
  • Re: Logical Log backup
    SMITH JOHN -- Friday, 24 January 2014, at 4:24 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.