Continuous Logical Log Restore

If a have (stand by) Informix server where periodically do continuous logical log restore (ontape -l -C), and server get down for some reason (power off, Informix crash ...), I wonder can I bring server back from Off-line to "Fast recovery" again, or even "On-line" mode ... oninit won't work, and if this happened, I must do level0 restore (ontape -p) from beginning ...

You can start the instance in physical recovery mode: "oninit -PHY" then proceed with CLR. Sent from my iPhone edcel barcena On 29/11/2012, at 7:41 PM, "Ivan Zavis DBA" <ivan.zavis@mi-system.co.rs> wrote: > If a have (stand by) Informix server where periodically do continuous > logical log restore (ontape -l -C), and server get down for some reason > (power off, Informix crash ...), I wonder can I bring server back from > Off-line to "Fast recovery" again, or even "On-line" mode ... oninit > won't work, and if this happened, I must do level0 restore (ontape -p) > from beginning ... > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

You should be able to restart the instance with the undocumented '-r' or recovery flag. This is how ontape starts it during a physical restore. 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, Nov 29, 2012 at 3:40 AM, Ivan Zavis DBA <ivan.zavis@mi-system.co.rs>wrote: > If a have (stand by) Informix server where periodically do continuous > logical log restore (ontape -l -C), and server get down for some reason > (power off, Informix crash ...), I wonder can I bring server back from > Off-line to "Fast recovery" again, or even "On-line" mode ... oninit > won't work, and if this happened, I must do level0 restore (ontape -p) > from beginning ... > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93411850c8b8904cfa1e390

Ahh yes, better to use the documented options. Forgot about this one. 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, Nov 29, 2012 at 5:39 AM, Edcel Barcena <edcel_barcena@hotmail.com>wrote: > You can start the instance in physical recovery mode: "oninit -PHY" then > proceed with CLR. > > Sent from my iPhone > edcel barcena > > On 29/11/2012, at 7:41 PM, "Ivan Zavis DBA" <ivan.zavis@mi-system.co.rs> > wrote: > > > If a have (stand by) Informix server where periodically do continuous > > logical log restore (ontape -l -C), and server get down for some reason > > (power off, Informix crash ...), I wonder can I bring server back from > > Off-line to "Fast recovery" again, or even "On-line" mode ... oninit > > won't work, and if this happened, I must do level0 restore (ontape -p) > > from beginning ... > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf3022399927e11f04cfa1e885

Both commands works just fine. Thank you guys ! On 29.11.2012 14:10, Art Kagel wrote: > Ahh yes, better to use the documented options. Forgot about this one. > > 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, Nov 29, 2012 at 5:39 AM, Edcel Barcena > <edcel_barcena@hotmail.com>wrote: > >> You can start the instance in physical recovery mode: "oninit -PHY" then >> proceed with CLR. >> >> Sent from my iPhone >> edcel barcena >> >> On 29/11/2012, at 7:41 PM, "Ivan Zavis DBA"<ivan.zavis@mi-system.co.rs> >> wrote: >> >>> If a have (stand by) Informix server where periodically do continuous >>> logical log restore (ontape -l -C), and server get down for some reason >>> (power off, Informix crash ...), I wonder can I bring server back from >>> Off-line to "Fast recovery" again, or even "On-line" mode ... oninit >>> won't work, and if this happened, I must do level0 restore (ontape -p) >>> from beginning ... >>> >>> >>> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --20cf3022399927e11f04cfa1e885 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >