onbar -r -rename -f mapfile -p problems...
Posted in 2006
Topics: Backup & Restore, Storage & Space Management, Platform-Specific Issues
Have any of you successfully done this? I have an IDS10FC4, AIX 5.3 system with 351 chunks. I am trying to have multiple instances of the same system on one large box for testing (so changing links only works for one restore). 2006-04-11 11:12:57 438288 287472 /opt/informix/informix/bin/onbar_d -r -rename -f ./rename_map.txt -p 2006-04-11 11:12:58 438288 287472 (-43024) Chunk rename failed: Error at line 15 in input file ./rename_map.txt. . 2006-04-11 11:12:58 438288 287472 /opt/informix/informix/bin/onbar_d complete, returning 182 (0xb6) mapfile >snip< /dev/i/0/vol19 0 /dev/i/6/vol19 0 /dev/i/0/vol19 125000 /dev/i/6/vol19 125000 <==size of this chunk is 6250 /dev/i/0/vol19 131250 /dev/i/6/vol19 131250 <==this is line 15 /dev/i/0/vol21 0 /dev/i/6/vol21 0 /dev/i/0/vol21 75000 /dev/i/6/vol21 75000 >snip< I have also tried one monster long command line rename of all chunks...same error, same place. Tech support is working on it.... Have any of you successfully renamed all the chunks in a restore? Thanks! Sam ==== Sam Gentsch Database Administrator InterCall: A Subsidiary of West Corporation office (706)634-3612 cell (706)289-6710 fax (706)634-3950 email sgentsch@intercall.com url www.intercall.com
Apologies in advance for asking the obvious Sam. Are you certain that
/dev/i/6/vol19 is the same size as /dev/i/0/vol19 and has the proper
permissions? Do you have another lv you can use instead of vol19 for all 3
dbspaces or just the last dbspace without the offset? Are you sure there
are no stray characters in your map file? I'm also going to assume that
this is a normal dbspace and not a temp dbspace.
I've done these in the past without this issue. It's a tremendous
improvement over relative pathing.
>From: "Gentsch, Sam" <sgentsch@intercall.com>
>Reply-To: ids@iiug.org
>To: ids@iiug.org
>Subject: onbar -r -rename -f mapfile -p problems... [6562]
>Date: Tue, 11 Apr 2006 11:40:09 -0400 (EDT)
>
>Have any of you successfully done this?
>
>I have an IDS10FC4, AIX 5.3 system with 351 chunks.
>
>I am trying to have multiple instances of the same system on one large box
>for
>testing (so changing links only works for one restore).
>
>2006-04-11 11:12:57 438288 287472 /opt/informix/informix/bin/onbar_d -r
>-rename -f ./rename_map.txt -p
>2006-04-11 11:12:58 438288 287472 (-43024) Chunk rename failed: Error at
>line
>15 in input file ./rename_map.txt. .
>2006-04-11 11:12:58 438288 287472 /opt/informix/informix/bin/onbar_d
>complete,
>returning 182 (0xb6)
>
>mapfile
> >snip<
>/dev/i/0/vol19 0 /dev/i/6/vol19 0
>/dev/i/0/vol19 125000 /dev/i/6/vol19 125000 <==size of this chunk is 6250
>/dev/i/0/vol19 131250 /dev/i/6/vol19 131250 <==this is line 15
>/dev/i/0/vol21 0 /dev/i/6/vol21 0
>/dev/i/0/vol21 75000 /dev/i/6/vol21 75000
> >snip<
>
>I have also tried one monster long command line rename of all chunks...same
>error, same place.
>
>Tech support is working on it....
>
>Have any of you successfully renamed all the chunks in a restore?
>
>Thanks!
>
>Sam
>
>====
>
>Sam Gentsch
>Database Administrator
>InterCall: A Subsidiary of West Corporation
>office (706)634-3612
>cell (706)289-6710
>fax (706)634-3950
>email sgentsch@intercall.com
>url www.intercall.com
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>Are you certain that /dev/i/6/vol19 is the same size as /dev/i/0/vol19 and has the proper permissions? Same size, same perms 660 informix:informix..checked again to be sure. >Do you have another lv you can use instead of vol19 for all 3 >dbspaces or just the last dbspace without the offset? Good idea, still does not like that line, it has to be the original portion 700000161a866a8 13 13 0 125000 124947 PO-B /dev/i/0/vol19 700000161a86848 14 14 125000 6250 2447 PO-B /dev/i/0/vol19 700000161a869e8 15 15 131250 6250 5601 PO-B /dev/i/0/vol19 lines up with : /dev/i/0/vol19 0 /dev/i/6/vol60 0 /dev/i/0/vol19 125000 /dev/i/6/vol60 125000 /dev/i/0/vol19 131250 /dev/i/6/vol60 131250 >Are you sure there are no stray characters in your map file? cat -vet not showing anything...that was my first thought. >I'm also going to assume that this is a normal dbspace and not a temp dbspace. oddly, the tempdbspaces worked...I removed them and failed in the same spot. >I've done these in the past without this issue. It's a tremendous improvement over relative pathing. It would be wonderful... Thanks for the reply...great suggestions...
More info is always helpful. It looks like your using pages in your
mapfile. I believe this is a case were you have to use kb. Your offset is
too big when you hit the third dbspace.
>From: "Gentsch, Sam " <sgentsch@intercall.com>
>To: "Barry Leb" <bjleb@hotmail.com>, <ids@iiug.org>
>Subject: RE: onbar -r -rename -f mapfile -p problems... [6562]
>Date: Tue, 11 Apr 2006 13:09:38 -0400
>
>
>
> >Are you certain that /dev/i/6/vol19 is the same size as /dev/i/0/vol19
>and has the proper
>permissions?
>
>Same size, same perms 660 informix:informix..checked again to be sure.
>
> >Do you have another lv you can use instead of vol19 for all 3
> >dbspaces or just the last dbspace without the offset?
>
>Good idea, still does not like that line, it has to be the original portion
>
>700000161a866a8 13 13 0 125000 124947
>PO-B /dev/i/0/vol19
>700000161a86848 14 14 125000 6250 2447
>PO-B /dev/i/0/vol19
>700000161a869e8 15 15 131250 6250 5601
>PO-B /dev/i/0/vol19
>
>lines up with :
>
>/dev/i/0/vol19 0 /dev/i/6/vol60 0
>/dev/i/0/vol19 125000 /dev/i/6/vol60 125000
>/dev/i/0/vol19 131250 /dev/i/6/vol60 131250
>
> >Are you sure there are no stray characters in your map file?
>
>cat -vet not showing anything...that was my first thought.
>
> >I'm also going to assume that this is a normal dbspace and not a temp
>dbspace.
>oddly, the tempdbspaces worked...I removed them and failed in the same
>spot.
>
>
> >I've done these in the past without this issue. It's a tremendous
>improvement over relative pathing.
>
>It would be wonderful...
>
>Thanks for the reply...great suggestions...
>
>
>
Oh, man, I am an idiot! Shuddup OTC. This worked...you always talk to the DB in K...duh! Thank you very much! >More info is always helpful. It looks like your using pages in your mapfile. I believe this is a case were you have to use kb. Your offset is too big when you hit the third dbspace.