Re: archecker and BACKUP_FILTER
A user on IDS 11.70.UC7IE could run plain archecker verification of compressed backups (using BACKUP_FILTER/RESTORE_FILTER with gzip/gunzip), but table-level or point-in-time restores failed with "AC_RESTORE_FILTER is set. Must do physical restore only. CRITICAL ERROR: Unable to initialize extraction". Art Kagel noted the filter bug itself was fixed; John Miller identified the real cause: without an explicit clause the command file defaults to RESTORE TO CURRENT, which needs logical logs. Adding "RESTORE TO CURRENT WITH NO LOG;" (or a timestamp plus WITH NO LOG) solved it; the user called the error message misleadingly terse.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Just on the off-chance - was this problem ever resolved for IDS 11.7 and archecker?
IB that archecker now works correctly with the filters, yes. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Thu, Jun 19, 2014 at 8:44 AM, ROB KOTTLER <robk@ethniks.co.za> wrote: > Just on the off-chance - was this problem ever resolved for IDS 11.7 and > archecker? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3b5dc8dd00604fc306f81
To confirm : I am using IBM Informix Dynamic Server Version 11.70.UC7IE Program Name: archecker Version: 8.0 Released: 2012-11-27 21:53:03 CSDK: IBM Informix CSDK Version 3.70 ESQL: IBM Informix-ESQL Version 3.70.UC6 Compiled: 11/27/12 21:53 on Linux 2.6.18-128.el5PAE #1 SMP Wed Dec 17 12:02:33 EST 2008 I can do vanilla #archecker -tdvs (without the d it reports 750million missing pages!) but I still cannot table level restore, or point in time for that matter - is this your understnading too, is there perhaps a later version of archecker ? I have tried to google latest version but find nothing to tell me. I am stuck on 11.70.UC7IE, cannot upgrade, v12 too restrictive Thanks
If vanilla works then whatever problem you are having has nothing to do with the BACKUP_FILTER or RESTORE_FILTER since those are used for the vanilla checking as well which used to fail with a filter configured. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Thu, Jun 19, 2014 at 9:42 AM, ROB KOTTLER <robk@ethniks.co.za> wrote: > To confirm : > I am using > IBM Informix Dynamic Server Version 11.70.UC7IE > Program Name: archecker > Version: 8.0 > Released: 2012-11-27 21:53:03 > CSDK: IBM Informix CSDK Version 3.70 > ESQL: IBM Informix-ESQL Version 3.70.UC6 > Compiled: 11/27/12 21:53 on Linux 2.6.18-128.el5PAE #1 SMP Wed Dec 17 > 12:02:33 > EST 2008 > > I can do vanilla > #archecker -tdvs (without the d it reports 750million missing pages!) > > but I still cannot table level restore, or point in time for that matter - > is > this your understnading too, is there perhaps a later version of archecker > ? > I have tried to google latest version but find nothing to tell me. > > I am stuck on 11.70.UC7IE, cannot upgrade, v12 too restrictive > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3715cbdff0b04fc30dc67
Sorry to monopolise your time ..
This is what archecker reports:
[root@mordor /tmp ]archecker -tvs -f /tmp/ac_cmdfile1
IBM Informix Dynamic Server Version 11.70.UC7IE
Program Name: archecker
Version: 8.0
Released: 2012-11-27 21:53:03
CSDK: IBM Informix CSDK Version 3.70
ESQL: IBM Informix-ESQL Version 3.70.UC6
Compiled: 11/27/12 21:53 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/UniBackup/UniDBS/
AC_TAPEBLOCK 32 KB
AC_LTAPEDEV /u/UniBackup/UniDBS/
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
[root@mordor /tmp ]
So I suppose we will never be able do a table level restore when zipping.
My problem is disk space.
I can do "ontape -r" and copy the WHOLE dbs in, but that is inadequate.
If I gzip manually or " -f STDIO | gzip " then the archecker will fails to be
able to check it.
If I use the BACKUP_FILTER then I can test validity of backup, but I cannot
table level - which from time to time is required, for reasons best left
unstated ....
If I have an L0, and a couple of L1 backups, to your knowledge, does archecker
check the L1's sequentially, or the last one, or any L1's at all.
Documentation on archecker seems limited, even on the internet.
Thanks
In you command file "/tmp/ac_cmdfile1" to you have the line
"RESTORE WITH NO LOG"
This will tell archecker you only want to restore the table without the
logical logs. If this line is omitted
then archecker will assume "RESTORE TO CURRENT" as the default which will
require logical logs.
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 06/19/2014 07:20:54 AM:
> From: "ROB KOTTLER" <robk@ethniks.co.za>
> To: ids@iiug.org,
> Date: 06/19/2014 07:21 AM
> Subject: Re: archecker and BACKUP_FILTER [33245]
> Sent by: ids-bounces@iiug.org
>
> Sorry to monopolise your time ..
>
> This is what archecker reports:
>
> [root@mordor /tmp ]archecker -tvs -f /tmp/ac_cmdfile1
> IBM Informix Dynamic Server Version 11.70.UC7IE
> Program Name: archecker
> Version: 8.0
> Released: 2012-11-27 21:53:03
> CSDK: IBM Informix CSDK Version 3.70
> ESQL: IBM Informix-ESQL Version 3.70.UC6
> Compiled: 11/27/12 21:53 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/UniBackup/UniDBS/
> AC_TAPEBLOCK 32 KB
> AC_LTAPEDEV /u/UniBackup/UniDBS/
> 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
> [root@mordor /tmp ]
>
> So I suppose we will never be able do a table level restore when zipping.
> My problem is disk space.
>
> I can do "ontape -r" and copy the WHOLE dbs in, but that is inadequate.
>
> If I gzip manually or " -f STDIO | gzip " then the archecker will fails
to be
> able to check it.
>
> If I use the BACKUP_FILTER then I can test validity of backup, but I
cannot
> table level - which from time to time is required, for reasons best left
> unstated ....
>
> If I have an L0, and a couple of L1 backups, to your knowledge,
doesarchecker
> check the L1's sequentially, or the last one, or any L1's at all.
> Documentation on archecker seems limited, even on the internet.
>
> Thanks
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
ta-daaaaa : Solved Thank you Gentlemen (Art and John) for again pulling the fat out the fire on IIUG. The line to add was RESTORE TO CURRENT WITH NO LOG ; or RESTORE TO "2017-06-10 14:32:00" WITH NO LOG ; and then all was happy - as was I. Spurious error message, or maybe too terse