onbar -r -n hangs in cold restore of rootdbs

Hi, I'm moving a 1.1 TB SAP database from an old EMC DMX san to new EMC CX4 san. I have 535 2 GB chunks. We connected to the new CX4 and are restoring the data using onbar/Legato. onbar -r -n 203915 I get the following message in the bar_act.log 2009-05-16 10:30:46 16123 16121 /informix/PRD/bin/onbar_d -r -n 203915 2009-05-16 10:37:12 16123 16121 Successfully connected to Storage Manager. 2009-05-16 10:40:10 16123 16121 Begin cold level 0 restore rootdbs (Storage Ma ager copy ID: 1242421162 1242421163). We see in Legato that it restored some data. But, no dbspaces are restoring. It's been over an hour. We see cpu cycles for onbar_d. Has anyone see anything like this. Informix Version is 10.00.FC6 on HP-UX 11.11 Regards, Paul Sullivan paul.sullivan@compucom.com

Paul: Just an idea, but informix SAP systems generally have a large amount of space dedicated to physical and logical logs. During the restore process informix must fill the log file with zeros (this is so it does not see old ghost recovery data as valid data). I would check an onstat -g iof or a iostat to see if you have I/O going to those spaces/disks. Hope this helps. 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 05/16/2009 08:54:53 AM: > [image removed] > > onbar -r -n hangs in cold restore of rootdbs [15797]> > PAUL SULLIVAN > > to: > > ids > > 05/16/2009 08:55 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi, > > I'm moving a 1.1 TB SAP database from an old EMC DMX san to new EMC > CX4 san. I > have 535 2 GB chunks. We connected to the new CX4 and are restoring the data > using onbar/Legato. onbar -r -n 203915 > > I get the following message in the bar_act.log > 2009-05-16 10:30:46 16123 16121 /informix/PRD/bin/onbar_d -r -n 203915 > 2009-05-16 10:37:12 16123 16121 Successfully connected to Storage Manager. > 2009-05-16 10:40:10 16123 16121 Begin cold level 0 restore rootdbs > (Storage Ma > ager copy ID: 1242421162 1242421163). > > We see in Legato that it restored some data. But, no dbspaces are restoring. > It's been over an hour. We see cpu cycles for onbar_d. Has anyone > see anything > like this. Informix Version is 10.00.FC6 on HP-UX 11.11 > > Regards, > > Paul Sullivan > paul.sullivan@compucom.com > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi John, Finally after about 1 1/2 hours the restore kicked in and is now restoring the dbspaces. Thank you for replying so quick. Regards, Paul Sullivan

I have encountered the same issue before with onbar. Here's what I did to fix the problem: *vi the ixbar.0 ( not supported or encouraged by IBM)* (assumes you want last archive in file and has to search through entire file which causes the slowness) * Move the end of the file * search up for rootdbs * write down the logical log needed by rootdbs * scroll up to several above that logical log number * remove the top of the file ( d1 shift g) * start your restore Michael Wiggins Informix/Oracle Database Administrator > Hi John, > > Finally after about 1 1/2 hours the restore kicked in and is now restoring the > dbspaces. > > Thank you for replying so quick. > > Regards, > > Paul Sullivan > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > >