Archecker question
Asked whether archecker table-level restores from ON-Bar backups (IDS 11.70 on Solaris) must run on the source instance or can be run elsewhere. Answer: archecker can run on any compatible machine, and running it on a non-production server is the recommended approach; if run on the source instance, just direct the extracted data into a different table so the original isn't touched. Follow-up questions about which config/ixbar files to copy were answered only by a pointer to the Backup and Restore Guide, plus confirmation that the usual ON-Bar restore environment variables are needed.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Informix 11.70.FC2
Sun Solaris
This is a general question about archecker.
I want to recover a table using onbar from 5 different daily backups to see
the state of it at a certain time. So far so good. Do I have to issue the
archecker command from the server / instance the backup was taken from or can
I do this from any server? I would prefer to run the command from a
non-production server if possible. I assume even though the source file is
described the content of the table will not be affected in any way if I do run
it from the source instance / database?
Regards
Andy G
Yes you can run it from other instance and that woul be my suggestion...
Regards
On Sep 11, 2012 11:32 AM, "Andrew Grantham" <agrantha@hotmail.com> wrote:
> Informix 11.70.FC2
> Sun Solaris
>
> This is a general question about archecker.
>
> I want to recover a table using onbar from 5 different daily backups to see
> the state of it at a certain time. So far so good. Do I have to issue the
> archecker command from the server / instance the backup was taken from or
> can
> I do this from any server? I would prefer to run the command from a
> non-production server if possible. I assume even though the source file is
> described the content of the table will not be affected in any way if I do
> run
> it from the source instance / database?
>
> Regards
>
> Andy G
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00248c711bb913438504c96a9d7c
okay thanks for the quick answer. What files do I need to copy and/or
environment variables do I need to set to enable the process to work from a
different server/instance?
> To: ids@iiug.org
> From: domusonline@gmail.com
> Subject: Re: Archecker question [28277]
> Date: Tue, 11 Sep 2012 06:34:10 -0400
>
> Yes you can run it from other instance and that woul be my suggestion...
>
> Regards
> On Sep 11, 2012 11:32 AM, "Andrew Grantham" <agrantha@hotmail.com> wrote:
>
> > Informix 11.70.FC2
> > Sun Solaris
> >
> > This is a general question about archecker.
> >
> > I want to recover a table using onbar from 5 different daily backups to see
> > the state of it at a certain time. So far so good. Do I have to issue the
> > archecker command from the server / instance the backup was taken from or
> > can
> > I do this from any server? I would prefer to run the command from a
> > non-production server if possible. I assume even though the source file is
> > described the content of the table will not be affected in any way if I do
> > run
> > it from the source instance / database?
> >
> > Regards
> >
> > Andy G
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00248c711bb913438504c96a9d7c
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
You can run the archecker on any compatible machine, not just the source.
The data extraction procedure lets you specify what to do with the data.
If you run it on the source machine with INFORMIXSERVER pointed to the
source instance, you just have to be careful to specify that the data be
inserted into a different table than the source table for this experiment.
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 Tue, Sep 11, 2012 at 6:31 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
> Informix 11.70.FC2
> Sun Solaris
>
> This is a general question about archecker.
>
> I want to recover a table using onbar from 5 different daily backups to see
> the state of it at a certain time. So far so good. Do I have to issue the
> archecker command from the server / instance the backup was taken from or
> can
> I do this from any server? I would prefer to run the command from a
> non-production server if possible. I assume even though the source file is
> described the content of the table will not be affected in any way if I do
> run
> it from the source instance / database?
>
> Regards
>
> Andy G
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f502ff87bd0f204c96b186f
Art,
Thanks for the information. However a supplimental question if you please? I
would rather perform the restore on a non-production server using onbar. What
configuration files, ixbar files etc etc do I need to copy over so onbar knows
what to look for?
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: Archecker question [28279]
> Date: Tue, 11 Sep 2012 07:08:41 -0400
>
> You can run the archecker on any compatible machine, not just the source.
> The data extraction procedure lets you specify what to do with the data.
> If you run it on the source machine with INFORMIXSERVER pointed to the
> source instance, you just have to be careful to specify that the data be
> inserted into a different table than the source table for this experiment.
>
> 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 Tue, Sep 11, 2012 at 6:31 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
>
> > Informix 11.70.FC2
> > Sun Solaris
> >
> > This is a general question about archecker.
> >
> > I want to recover a table using onbar from 5 different daily backups to see
> > the state of it at a certain time. So far so good. Do I have to issue the
> > archecker command from the server / instance the backup was taken from or
> > can
> > I do this from any server? I would prefer to run the command from a
> > non-production server if possible. I assume even though the source file is
> > described the content of the table will not be affected in any way if I do
> > run
> > it from the source instance / database?
> >
> > Regards
> >
> > Andy G
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --e89a8f502ff87bd0f204c96b186f
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
This is documented in the Backup and Restore Guide more fully than I could
treat it here.
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 Tue, Sep 11, 2012 at 7:58 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
> Art,
>
> Thanks for the information. However a supplimental question if you please?
> I
> would rather perform the restore on a non-production server using onbar.
> What
> configuration files, ixbar files etc etc do I need to copy over so onbar
> knows
> what to look for?
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: Archecker question [28279]
> > Date: Tue, 11 Sep 2012 07:08:41 -0400
> >
> > You can run the archecker on any compatible machine, not just the source.
> > The data extraction procedure lets you specify what to do with the data.
> > If you run it on the source machine with INFORMIXSERVER pointed to the
> > source instance, you just have to be careful to specify that the data be
> > inserted into a different table than the source table for this
> experiment.
> >
> > 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 Tue, Sep 11, 2012 at 6:31 AM, Andrew Grantham
> <agrantha@hotmail.com>wrote:
> >
> > > Informix 11.70.FC2
> > > Sun Solaris
> > >
> > > This is a general question about archecker.
> > >
> > > I want to recover a table using onbar from 5 different daily backups to
> see
> > > the state of it at a certain time. So far so good. Do I have to issue
> the
> > > archecker command from the server / instance the backup was taken from
> or
> > > can
> > > I do this from any server? I would prefer to run the command from a
> > > non-production server if possible. I assume even though the source
> file is
> > > described the content of the table will not be affected in any way if
> I do
> > > run
> > > it from the source instance / database?
> > >
> > > Regards
> > >
> > > Andy G
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --e89a8f502ff87bd0f204c96b186f
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec5186d6848434604c96ca663
One last question about archecker and onbar. To use onbar and the archecker do
I need to set the same environment variables as I would if I was going to
restore an onbar backup?
Thanks
Andy G
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: Archecker question [28281]
> Date: Tue, 11 Sep 2012 08:59:55 -0400
>
> This is documented in the Backup and Restore Guide more fully than I could
> treat it here.
>
> 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 Tue, Sep 11, 2012 at 7:58 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
>
> > Art,
> >
> > Thanks for the information. However a supplimental question if you please?
> > I
> > would rather perform the restore on a non-production server using onbar.
> > What
> > configuration files, ixbar files etc etc do I need to copy over so onbar
> > knows
> > what to look for?
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: Archecker question [28279]
> > > Date: Tue, 11 Sep 2012 07:08:41 -0400
> > >
> > > You can run the archecker on any compatible machine, not just the source.
> > > The data extraction procedure lets you specify what to do with the data.
> > > If you run it on the source machine with INFORMIXSERVER pointed to the
> > > source instance, you just have to be careful to specify that the data be
> > > inserted into a different table than the source table for this
> > experiment.
> > >
> > > 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 Tue, Sep 11, 2012 at 6:31 AM, Andrew Grantham
> > <agrantha@hotmail.com>wrote:
> > >
> > > > Informix 11.70.FC2
> > > > Sun Solaris
> > > >
> > > > This is a general question about archecker.
> > > >
> > > > I want to recover a table using onbar from 5 different daily backups to
> > see
> > > > the state of it at a certain time. So far so good. Do I have to issue
> > the
> > > > archecker command from the server / instance the backup was taken from
> > or
> > > > can
> > > > I do this from any server? I would prefer to run the command from a
> > > > non-production server if possible. I assume even though the source
> > file is
> > > > described the content of the table will not be affected in any way if
> > I do
> > > > run
> > > > it from the source instance / database?
> > > >
> > > > Regards
> > > >
> > > > Andy G
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --e89a8f502ff87bd0f204c96b186f
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --bcaec5186d6848434604c96ca663
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
IB so, yes.
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, Sep 24, 2012 at 5:30 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
> One last question about archecker and onbar. To use onbar and the
> archecker do
> I need to set the same environment variables as I would if I was going to
> restore an onbar backup?
>
> Thanks
>
> Andy G
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: Archecker question [28281]
> > Date: Tue, 11 Sep 2012 08:59:55 -0400
> >
> > This is documented in the Backup and Restore Guide more fully than I
> could
> > treat it here.
> >
> > 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 Tue, Sep 11, 2012 at 7:58 AM, Andrew Grantham
> <agrantha@hotmail.com>wrote:
> >
> > > Art,
> > >
> > > Thanks for the information. However a supplimental question if you
> please?
> > > I
> > > would rather perform the restore on a non-production server using
> onbar.
> > > What
> > > configuration files, ixbar files etc etc do I need to copy over so
> onbar> > > knows
> > > what to look for?
> > >
> > > > To: ids@iiug.org
> > > > From: art.kagel@gmail.com
> > > > Subject: Re: Archecker question [28279]
> > > > Date: Tue, 11 Sep 2012 07:08:41 -0400
> > > >
> > > > You can run the archecker on any compatible machine, not just the
> source.
> > > > The data extraction procedure lets you specify what to do with the
> data.
> > > > If you run it on the source machine with INFORMIXSERVER pointed to
> the
> > > > source instance, you just have to be careful to specify that the
> data be
> > > > inserted into a different table than the source table for this
> > > experiment.
> > > >
> > > > 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 Tue, Sep 11, 2012 at 6:31 AM, Andrew Grantham
> > > <agrantha@hotmail.com>wrote:
> > > >
> > > > > Informix 11.70.FC2
> > > > > Sun Solaris
> > > > >
> > > > > This is a general question about archecker.
> > > > >
> > > > > I want to recover a table using onbar from 5 different daily
> backups
> to
> > > see
> > > > > the state of it at a certain time. So far so good. Do I have to
> issue
> > > the
> > > > > archecker command from the server / instance the backup was taken
> from
> > > or
> > > > > can
> > > > > I do this from any server? I would prefer to run the command from a
> > > > > non-production server if possible. I assume even though the source
> > > file is
> > > > > described the content of the table will not be affected in any way
> if
> > > I do
> > > > > run
> > > > > it from the source instance / database?
> > > > >
> > > > > Regards
> > > > >
> > > > > Andy G
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --e89a8f502ff87bd0f204c96b186f
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --bcaec5186d6848434604c96ca663
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3bac1d46f66f04ca733b8c