onbar

Hi All, I've encountered I/O error in informix and it needs a full-restore "onbar -r -p". While performing restore, it encountered problem due to some network issues. Is there a way the onbar command will start on the location it stopped? This is to mininize the downtime of the DB and make it online as soon as possible. Thanks,

Hi, yes. "onbar -RESTART" is the command. But the prerequisite is that you already had the onconfig parameter RESTARTABLE_RESTORE set to the value ON before starting the first attempt of restore (that got interrupted). If you have not set this yet to ON, then this may be a good time to set it for future restore attempts. If it is not working correctly, i.e. restore still is not restartable, then you are on a rather old version of IDS. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Erich Baier Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 ids-bounces@iiug.org wrote on 10/14/2009 03:57:19 AM: > > Hi All, > > I've encountered I/O error in informix and it needs a full-restore"onbar -r > -p". While performing restore, it encountered problem due to some network > issues. Is there a way the onbar command will start on the location it > stopped? > > This is to mininize the downtime of the DB and make it online as soon as > possible. > > Thanks, > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

Jack: If you have enabled restartable restore feature in the oncnfig file it will not re-do any dbspaces which have completed, but re-start with the dbspaces that were actively being restored when the interruption occurred. Note restartable restore will also work with logical recovery. RESTARTABLE_RESTORE ON Just run onbar -RESTART John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 10/13/2009 06:57:19 PM: > [image removed] > > onbar [17530] > > JACK PAPA > > to: > > ids > > 10/13/2009 06:58 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi All, > > I've encountered I/O error in informix and it needs a full-restore "onbar -r > -p". While performing restore, it encountered problem due to some network > issues. Is there a way the onbar command will start on the location it > stopped? > > This is to mininize the downtime of the DB and make it online as soon as > possible. > > Thanks, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Great thanks.. Appreciated very much. I asked as my colleague told me that RMAN backup in oracle can do such things. Again, thank you.