PIT Recovery
A user on IDS 11.50 (Solaris) asked how to do point-in-time recovery and which backup methods support it. Art Kagel replied that only onbar provides true PIT restore (rolling forward to a specified moment); ontape can only approximate it, since you can stop after restoring a given logical log archive file. Onbar needs a storage manager (Veritas, etc., or the bundled but fiddly ISM) — see the Backup and Restore guide; no simpler guide was offered. On whether external/snapshot backups support PIT, Art said no, while Stuart McCann said yes, via 'onbar -r -e -t'. The contradiction is left unresolved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, We are using IDS 11.50 FC6 & FC7 on Solaris Sparc. How can we make sure that we perform PIT Recovery in Informix? What are the different backup technologies available that supports PIT ? Thanks.
Only the onbar utility supports true point in time recovery. You can
simulate a PIT restore using ontape, but the resolution is the point at
which each logical log file was closed and archived. During an ontape
restore you can stop rolling forward logical logs after restoring any single
logical log archive file (which could contain a single log or multiple
logical logs). This is not the same as the full PIT restore capability of
the onbar utility to which you can specify the moment to which you want to
roll forward and it will properly restore only logical log records written
up to that moment before beginning recovery.
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 Wed, May 11, 2011 at 6:51 PM, SHAHZAD SALAM KASI <skasi@i2cinc.com>wrote:
> Hi,
> We are using IDS 11.50 FC6 & FC7 on Solaris Sparc.
>
> How can we make sure that we perform PIT Recovery in Informix?
>
> What are the different backup technologies available that supports PIT ?
>
> Thanks.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3071d02e01063d04a3083a65
Thanks for the information.
Can you also guide me how to use (backup/re-store) using onbar process.
Thanks.
See the Backup and Restore guide. Onbar works with a storage manager like
IBM Tuxedo, Veritas, etc. but it does come with a simple storage manager
known as ISM. Instructions for setting up ISM are included in the docs, it
is more complex than using ontape.
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 Wed, May 11, 2011 at 7:23 PM, SHAHZAD SALAM KASI <skasi@i2cinc.com>wrote:
> Thanks for the information.
>
> Can you also guide me how to use (backup/re-store) using onbar process.
>
> Thanks.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3071d02eeb8d1704a3086d83
Yeh, that's why i asked for some simple solution, as its quite complex in doc's. If there is any simple guide then do let me know. Thanks.
one more thing to ask. Can we achieve PIT using external backups as well, like snapshot?
No. 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 Wed, May 11, 2011 at 7:49 PM, SHAHZAD SALAM KASI <skasi@i2cinc.com>wrote: > one more thing to ask. Can we achieve PIT using external backups as well, > like > snapshot? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf307abeed7d981704a30900ed
Yes Onbar -r -e -t Stuart McCann -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SHAHZAD SALAM KASI Sent: Thursday, 12 May 2011 9:49 AM To: ids@iiug.org Subject: Re: PIT Recovery [23661] one more thing to ask. Can we achieve PIT using external backups as well, like snapshot? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email.