IDS Forum

RE: RE: Continous logical log backup stuck - p....

Posted By: Mike Walker
Date: Thursday, 22 February 2018, at 12:26 p.m.

In Response To: Re: RE: Continous logical log backup stuck - prima (STEVEN AB)

Yes, ontape -a -d will back up any logs used and not backed up, and then
quit.

The "F" in the flags means that it is Free - it hasn't been used. There is
no need to back up this log, as it doesn't contain any transactional
information. You'll see an "F" if you have recently restored the instance
or if you just haven't used the logs yet, and it's okay. You won't
encounter any problem with not moving past a Free log, because as soon as it
is written to it won't be Free anymore.

When transactions are written to a logical log, then the flag will switch to
a "U" - Used. When the current log (marked with a "C" in position 5)
switches to the next one, and the previous log gets backed up, then you'll
see "U-B----".

What you don't want to see if a lot of logs marked as Used and NOT backed up
(U------), as that will lead to problems.

You said that you are backing up to a directory, so make sure that LTAPEDEV
references the directory (and owner and permissions are correct). Make sure
that alarmprogram has BACKUPLOGS=Y, and that BACKUP_CMD="ontape -a -d". To
test, switch logs manually with "onmode -l; onmode -c". You should see a
message in the online log that a log has filled, and that a backup has
begun. You'll soon see a new file created in the directory referred to by
LTAPEDEV. Running onstat -l will show that you have no logs with the flags
"U------". If this isn't working as described, then let us know what
problem you are seeing.

Mike

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of STEVEN
AB
Sent: Thursday, February 22, 2018 10:09 AM
To: ids@iiug.org
Subject: Re: RE: Continous logical log backup stuck - p.... [40745]

So you're saying that ontape -a -d will backup only the logical logs that
are filled ?
Didn't knew that. When I was using it it was always backing up all logs so I
took it like that :) All the logs are marked with F flag and I wanted to
mark them with U and B.

It's been a while since I've made a new informix setup but I think I
remember that it won't pass to the next log if it's marked as F and most
issue an onmode -l for each logical log to be marked as used. Correct me if
I'm wrong.

The automatic logical log backup is configured in alarmprogram.sh since this
can be considered mandatory.

Thank you,
Steven.

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Continous logical log backup stuck - primary
  STEVEN AB -- Thursday, 22 February 2018, at 3:55 a.m.
  • Re: Continous logical log backup stuck - primary
    Marcus Haarmann -- Thursday, 22 February 2018, at 4:20 a.m.
    • Re: Continous logical log backup stuck - primary
      STEVEN AB -- Thursday, 22 February 2018, at 4:35 a.m.
    • Re: Continous logical log backup stuck - primary
      STEVEN AB -- Thursday, 22 February 2018, at 4:37 a.m.
  • Re: Continous logical log backup stuck - primary
    STEVEN AB -- Thursday, 22 February 2018, at 4:21 a.m.
  • RE: Continous logical log backup stuck - primary
    Mike Walker -- Thursday, 22 February 2018, at 8:54 a.m.
    • Re: RE: Continous logical log backup stuck - prima
      STEVEN AB -- Thursday, 22 February 2018, at 12:09 p.m.
      • Re: RE: Continous logical log backup stuck - prima
        STEVEN AB -- Thursday, 22 February 2018, at 12:12 p.m.
      • RE: RE: Continous logical log backup stuck - p....
        Mike Walker -- Thursday, 22 February 2018, at 12:26 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.