Re: Continuous log restore

What's possible in IDS 10 is... using ontape (not onbar), you could suspend log restore manually (by doing ctrl+c and select suspend option), and resume log restore when next set of logs are available. Once all logs are restored, system will be in quiescent mode. In IDS 11, both ontape and onbar has command line option -C to perform continuous log restore, and -X to finish continuous log restore and bring system to quiescent mode. HTH, Nilesh "Mohit Anchlia" <mohitanchlia@gmail.com> wrote on 10/18/2007 09:36:28 PM: > I am aware of v11 supporting this, but How come redbooks for v10 ( > www.redbooks.ibm.com/redbooks/pdfs/sg247319.pdf) say that this is > possible. I also recently attended session at IBM's site and they > mentioned the same thing that it's possible with IDS 10 to perform > continuous log restore > On 10/18/07, Nilesh Ozarkar <nilesho@us.ibm.com> wrote: > > You could use either ontape or onbar to perform Continuous Log > Restore and this feature is available in IDS 11, not in IDS 10. > > ontape --- http://publib.boulder.ibm.com/infocenter/idshelp/v111/ > index.jsp?topic=/com.ibm.bar.doc/bar317.htm > onbar --- http://publib.boulder.ibm.com/infocenter/idshelp/v111/ > index.jsp?topic=/com.ibm.bar.doc/bar149.htm > > Regards, > > Nilesh > > > > > mohitanchlia@gmail.com > Sent by: informix-list-bounces@iiug.org > 10/18/2007 01:16 PM > > To > > informix-list@iiug.org > > cc > > Subject > > Continuous log restore > > > > > Version IDS 10 > > I read in IBM's redbook for version 10 that continuous log restore can > be used. I wanted to know the following: > > 1. Can onbar be used for backup and restore ? > 2. What commands can be run to setup continuous log restore ? There is > not enough information available about this in the manual for V10. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

Hi, You can do continuous log restore using onbar under Version 10 with a little hack (but I am not sure this is really what you want). Check the ixbar.<SERVERNUM> file, and place a "duff entry" for the next logical log in the ixbar file. When you run onbar -r -p - this will complete the physical restore (use the -p to prevent log salvage from the target restore instance). Then (ensure you have a duff entry in the ixbar for the next log) run onbar -r -l. Logical restore will then suspend when it hits the duffentry. When the next log is available from the source instance, enter it's details in the ixbar.<SERVERNUM> file for the target instance, place a duff entry for the next logical log, and issue onbar -r -l. Keep doing this until you want to finish continuous log restore. BUT ... what are you actually trying to do? Have you reviewed HDR? Basically a primary instance and a secondary instance which is getting the logs from the primary instance and rolling them forward - and the secondary is available for read-only activities. Nilesh Ozarkar wrote: > What's possible in IDS 10 is... using ontape (not onbar), you could > suspend log restore manually (by doing ctrl+c and select suspend > option), and resume log restore when next set of logs are available. > Once all logs are restored, system will be in quiescent mode. > > In IDS 11, both ontape and onbar has command line option -C to perform > continuous log restore, and -X to finish continuous log restore and > bring system to quiescent mode. > > HTH, > > Nilesh > > > "Mohit Anchlia" <mohitanchlia@gmail.com> wrote on 10/18/2007 09:36:28 PM: > > > I am aware of v11 supporting this, but How come redbooks for v10 ( > > www.redbooks.ibm.com/redbooks/pdfs/sg247319.pdf) say that this is > > possible. I also recently attended session at IBM's site and they > > mentioned the same thing that it's possible with IDS 10 to perform > > continuous log restore > > > On 10/18/07, Nilesh Ozarkar <nilesho@us.ibm.com> wrote: > > > > You could use either ontape or onbar to perform Continuous Log > > Restore and this feature is available in IDS 11, not in IDS 10. > > > > ontape --- http://publib.boulder.ibm.com/infocenter/idshelp/v111/ > > index.jsp?topic=/com.ibm.bar.doc/bar317.htm > > onbar --- http://publib.boulder.ibm.com/infocenter/idshelp/v111/ > > index.jsp?topic=/com.ibm.bar.doc/bar149.htm > > > > Regards, > > > > Nilesh > > > > > > > > > > > mohitanchlia@gmail.com > > Sent by: informix-list-bounces@iiug.org > > 10/18/2007 01:16 PM > > > > To > > > > informix-list@iiug.org > > > > cc > > > > Subject > > > > Continuous log restore > > > > > > > > > > Version IDS 10 > > > > I read in IBM's redbook for version 10 that continuous log restore can > > be used. I wanted to know the following: > > > > 1. Can onbar be used for backup and restore ? > > 2. What commands can be run to setup continuous log restore ? There is > > not enough information available about this in the manual for V10. > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list >