Automated Logical Backup using Netbackup Policy
Jack asked how Informix triggers automatic logical log backups and where the NetBackup policy for them comes from. Art explained that ALARMPROGRAM (log_full.sh) runs on engine events — event 23 = log full/complete — and that the shipped script must be edited (enable the backup variables, and adapt it if using ontape rather than onbar). Paul advised setting INFXBSA_POLICY/INFXBSA_LOGICAL_POLICY inside log_full.sh to override bp.conf so logs go to a separate policy, testing with onmode -l and onmode -c. Jack confirmed this eventually worked.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All, Can someone explain how the automatic logical backup is working? As far as i know, there's a ALARMPROGRAM variable and the value is "$INFORMIXDIR/etc/log_full.sh. Once the threshold is reached, it will automatically kick the logical backup. 1. Where does informix get the policy to backup the logical logs?
You will need to set this export INFXBSA_LOGICAL_POLICY=? somewhere -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Wednesday, 7 April 2010 1:21 PM To: ids@iiug.org Subject: Automated Logical Backup using Netbackup Policy [19520] Hi All, Can someone explain how the automatic logical backup is working? As far as i know, there's a ALARMPROGRAM variable and the value is "$INFORMIXDIR/etc/log_full.sh. Once the threshold is reached, it will automatically kick the logical backup. 1. Where does informix get the policy to backup the logical logs? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
The alarmprogram script is executed whenever any 'event' happens. Logical
log completed is event # 23. If the onconfig is set up to trap all events,
and the script is set up properly (there are variables in the default script
that need to be changed to enable the backup - also the default script is
set up to use onbar to back up the logs, if you are using ontape you have to
modify the script further). Once set up every time a log fills up and the
engine switches to the next log, the script backs it up.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
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, Apr 6, 2010 at 11:20 PM, JACK PAPA <informix2009@gmail.com> wrote:
> Hi All,
>
> Can someone explain how the automatic logical backup is working? As far as
> i
> know, there's a ALARMPROGRAM variable and the value is
> "$INFORMIXDIR/etc/log_full.sh. Once the threshold is reached, it will
> automatically kick the logical backup.
>
> 1. Where does informix get the policy to backup the logical logs?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5bfcc3f6d0904839dfbed
Thank you... I've done some research and i'm planning to put in log_full.sh since it is the value set in ALARMPROGRAM. I will add INFXBSA_POLICY=POLICY_NAME_LOG so that it will be picked up on Netbackup side. POLICY_NAME_LOG is the policy name in Netbackup also. Hope this will work. Thanks again guys.
Hi, I did try to add the variables inside the log_full.sh and alarmprogram.sh but didn't work. I want to bypass the bp.conf (as it is using another INFXBSA_POLICY to backup the db). I want to backup the logical logs into a separate policy. Any idea where to put the INFXBSA_POLICY=netbackup_policy_logs? thanks,
Adding INFXBSA_POLICY=netbackup_policy_logs into log_full.sh should do it.
Do a "onmode -l" & "onmode -c" it should trigger the log backup via
log_full.sh.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA
Sent: Wednesday, 7 April 2010 4:29 PM
To: ids@iiug.org
Subject: Re: Automated Logical Backup using Netbackup Polic [19525]
Hi,
I did try to add the variables inside the log_full.sh and alarmprogram.sh but
didn't work. I want to bypass the bp.conf (as it is using another
INFXBSA_POLICY to backup the db). I want to backup the logical logs into a
separate policy. Any idea where to put the
INFXBSA_POLICY=netbackup_policy_logs?
thanks,
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks a lot!!! It worked after so many scenarios.