archecker and BACKUP_FILTER
User reports archecker fails with "AC_RESTORE_FILTER is set. Must do physical restore only" error when attempting point-in-time restore with BACKUP_FILTER/RESTORE_FILTER enabled for compression. Expert confirms bug in archecker preventing compatibility with BACKUP_FILTER; upgrading from 11.70.UC1IE to 11.70.UC5IE did not resolve it. No fix identified; user advised to open support case with IBM.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Please excuse if asked and answered before:
My BACKUP_FILTER AND RESTORE_FILTER in $ONCONFIG are set:
BACKUP_FILTER /bin/gzip
RESTORE_FILTER /bin/gunzip
When I wish to do a restore to a "point in time" with archecker, I get the
response as set out below. Is this then to say that if one is compressing
one's backup then one is automatically excluded from restoring a table to a
certain point in time, but either one has to restore up to last physical
backup, or restore entire backup until current time?
[root@laverna ThisDir]# archecker -tvs -f /home/bob/unloads/ac_cmdfile1
IBM Informix Dynamic Server Version 11.70.UC1IE
Program Name: archecker
Version: 8.0
Released: 2010-09-30 14:29:15
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.UN629
Compiled: 09/30/10 14:29 on Linux 2.6.18-128.el5PAE #1 SMP Wed Dec 17 12:02:33
EST 2008
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /u/Backup/ThisDir/
AC_TAPEBLOCK 32 KB
AC_LTAPEDEV /u/Backup/ThisDir/
AC_LTAPEBLOCK 32 KB
AC_RESTORE_FILTER /bin/gunzip
Dropping old log control tables
AC_RESTORE_FILTER is set. Must do physical restore only.
CRITICAL ERROR: Unable to initialize extraction
There was a bug in archecker that prevented it from working with an archive
that was made using BACKUP_FILTER. It was eventually fixed, Your release
of 11.70 is a couple of years old. You probably should upgrade to a recent
release which will likely have the fix. You are on Innovator Edition, so
you can just download the latest and greatest and install it.
Art
Art S. Kagel
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 Mon, Oct 22, 2012 at 5:30 AM, ROB KOTTLER <robk@ethniks.co.za> wrote:
> Please excuse if asked and answered before:
>
> My BACKUP_FILTER AND RESTORE_FILTER in $ONCONFIG are set:
> BACKUP_FILTER /bin/gzip
> RESTORE_FILTER /bin/gunzip>
> When I wish to do a restore to a "point in time" with archecker, I get the
> response as set out below. Is this then to say that if one is compressing
> one's backup then one is automatically excluded from restoring a table to a
> certain point in time, but either one has to restore up to last physical
> backup, or restore entire backup until current time?
>
> [root@laverna ThisDir]# archecker -tvs -f /home/bob/unloads/ac_cmdfile1
> IBM Informix Dynamic Server Version 11.70.UC1IE
> Program Name: archecker
> Version: 8.0
> Released: 2010-09-30 14:29:15
> CSDK: IBM Informix CSDK Version 3.50
> ESQL: IBM Informix-ESQL Version 3.50.UN629
> Compiled: 09/30/10 14:29 on Linux 2.6.18-128.el5PAE #1 SMP Wed Dec 17
> 12:02:33
> EST 2008
>
> AC_STORAGE /tmp
> AC_MSGPATH /tmp/ac_msg.log
> AC_VERBOSE on
> AC_TAPEDEV /u/Backup/ThisDir/
> AC_TAPEBLOCK 32 KB
> AC_LTAPEDEV /u/Backup/ThisDir/
> AC_LTAPEBLOCK 32 KB
> AC_RESTORE_FILTER /bin/gunzip
> Dropping old log control tables
> AC_RESTORE_FILTER is set. Must do physical restore only.
> CRITICAL ERROR: Unable to initialize extraction
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--90e6ba6e8e1c89a56504cca5fde7
Hi I took your advice and re-installed - with IDS11.7.UC5IE .... and went through all the motions of updating the databases and was good to go. I did a level 0 backup (with BACKUP/RESTORE_FILTER set). Made note of time. Then I did a little bit if deleting, and made note of time. I backed up some more logs so that there were logs past the point in time I wanted to restore to. And I ran my command : and BAM !!! Same problem ..... I see same version :( Is there a later version [root@Server6 Backup]# archecker -tvs -f /home/bob/unloads/ac_cmdfile1 IBM Informix Dynamic Server Version 11.70.UC5IE Program Name: archecker Version: 8.0 Released: 2012-06-19 22:09:01 CSDK: IBM Informix CSDK Version 3.50 ESQL: IBM Informix-ESQL Version 3.50.UN629 Compiled: 06/19/12 22:09 on Linux 2.6.18-128.el5PAE #1 SMP Wed Dec 17 12:02:33 EST 2008 AC_STORAGE /tmp AC_MSGPATH /tmp/ac_msg.log AC_VERBOSE on AC_TAPEDEV /u/Backup/Willy/ AC_TAPEBLOCK 32 KB AC_LTAPEDEV /u/Backup/Willy/ AC_LTAPEBLOCK 32 KB AC_RESTORE_FILTER /bin/gunzip Dropping old log control tables AC_RESTORE_FILTER is set. Must do physical restore only. CRITICAL ERROR: Unable to initialize extraction Please help !
Yeah. I double checked this then forgot to post it. The problem was never fixed. You should open a case. Art On Oct 25, 2012 8:11 AM, "ROB KOTTLER" <robk@ethniks.co.za> wrote: > Hi > I took your advice and re-installed - with IDS11.7.UC5IE .... and went > through > all the motions of updating the databases and was good to go. > I did a level 0 backup (with BACKUP/RESTORE_FILTER set). Made note of time. > Then I did a little bit if deleting, and made note of time. > I backed up some more logs so that there were logs past the point in time I > wanted to restore to. > > And I ran my command : and BAM !!! Same problem ..... I see same version :( > Is there a later version > [root@Server6 Backup]# archecker -tvs -f /home/bob/unloads/ac_cmdfile1 > IBM Informix Dynamic Server Version 11.70.UC5IE > Program Name: archecker > Version: 8.0 > Released: 2012-06-19 22:09:01 > CSDK: IBM Informix CSDK Version 3.50 > ESQL: IBM Informix-ESQL Version 3.50.UN629 > Compiled: 06/19/12 22:09 on Linux 2.6.18-128.el5PAE #1 SMP Wed Dec 17 > 12:02:33 > EST 2008 > > AC_STORAGE /tmp > AC_MSGPATH /tmp/ac_msg.log > AC_VERBOSE on > AC_TAPEDEV /u/Backup/Willy/ > AC_TAPEBLOCK 32 KB > AC_LTAPEDEV /u/Backup/Willy/ > AC_LTAPEBLOCK 32 KB > AC_RESTORE_FILTER /bin/gunzip > Dropping old log control tables > AC_RESTORE_FILTER is set. Must do physical restore only. > CRITICAL ERROR: Unable to initialize extraction > > Please help ! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93407472ba3ce04cce40377
How do I open a case - with IBM ?? It can't be that they don't know about it since September 2010?
They know about it, they just don't know how many users are affected. They may need a business case to be able to schedule developer time to fix it. Art Art S. Kagel 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 Thu, Oct 25, 2012 at 12:08 PM, ROB KOTTLER <robk@ethniks.co.za> wrote: > How do I open a case - with IBM ?? > > It can't be that they don't know about it since September 2010? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93411db07d86104cce78b70