Re: Ontape restore to different machine

Ok, thanks for the advice, Er one thing, would it be possible to create a cooked file for the missing DBspace? Sorry if these questions are a little lame, DBA is not my "area of expertise" ;o) Tony Flaherty. Analyst Programmer Misys Financial Systems Change at to @ to reply by email Keith Moffatt wrote in message ... >The first thing a full restore does is copy the 12 reserved pages from the >archive tape into your rootdbs. This means that the system being restored >will be IDENTICAL to the one that was archived. One of three things will >happen if you do this restore: > >1. It will fail because it will try to open a link that doesn't exist on >this box (/dev/online_dbs2 would probably be the first one that would be >hit) > >2. It will find a device link with that name and error out because it isn't >big enough when it tries to write out a particular page > >3. It will over write whatever is on that device. > >Actually, #1 would be your best hope. Definitely not worth trying, unless >you can arrange devices with the right names and right sizes. >In that case, it would work, but the instance that is there now would be >gone, of course. since the root chunk would be overwritten. > Keith >Tony Flaherty wrote in message ><910266439.3268.1.nnrp-08.c1ed1f69@news.demon.co.uk>... >>I have two machines running hp-ux v10.01 online version 7.24.UC5 >> >>onstate -d for machine HPK200 >> >>Dbspaces >>address number flags fchunk nchunks flags owner name >>c651f108 1 1 1 1 N informix rootdbs >>c651fbf8 2 1 2 1 N informix dbs_llog >>c651fc68 3 1 3 1 N informix dbspace2 >>c651fcd8 4 1 4 1 N informix dbspace1 >>c651fd48 5 1 5 1 N informix dbs_mentor >>c651fdb8 6 1 6 1 N informix dbs_plog2 >>c651fe28 7 2001 7 1 N T informix dbs_temp >> 7 active, 2047 maximum >> >>Chunks >>address chk/dbs offset size free bpages flags pathname >>c651f178 1 1 0 50000 47821 PO- >>/dev/online_root >>c651f6e8 2 2 0 50000 29947 PO- >>/dev/online_llog >>c651f7c0 3 3 0 500000 268474 PO- /dev/online_dbs2 >>c651f898 4 4 0 750000 584193 PO- >>/dev/online_chunk1 >>c651f970 5 5 0 250000 29160 PO- >>/dev/online_mentor >>c651fa48 6 6 0 6000 1947 PO- >>/dev/online_plog2 >>c651fb20 7 7 0 125000 121143 PO- /dev/online_temp >> 7 active, 2047 maximum >> >> >>onstat -d for machine HPE25>> >>Dbspaces >>address number flags fchunk nchunks flags owner name >>c2260108 1 1 1 1 N informix rootdbs >>c2260940 2 1 2 1 N informix dbs_llog >>c22609b0 3 1 3 1 N informix dbs_plog2 >>c2260a20 4 1 4 1 N informix dbspace1 >>c2260a90 5 1 5 1 N informix dbs_mentor >>c2260b00 6 2001 6 1 N T informix dbs_temp >> 6 active, 2047 maximum >> >>Chunks >>address chk/dbs offset size free bpages flags pathname >>c2260178 1 1 0 50000 48431 PO- >/dev/online_root >>c2260508 2 2 0 50000 29947 PO- >/dev/online_llog >>c22605e0 3 3 0 6000 1947 PO- >>/dev/online_plog2 >>c22606b8 4 4 0 750000 343183 PO- >/dev/online_chunk1 >>c2260790 5 5 0 250000 210612 PO- >/dev/online_mentor >>c2260868 6 6 0 125000 124747 PO- /dev/online_temp >> 6 active, 2047 maximum >> >> >>I want to restore a level 0 archive from the first (hpk200) machine onto >the >>second (hpe25). I am happy not to restore dbspace2 as I only want 1 >>database from the restore and its on dbspace1 (I hope :) ) Ideally of >>course I'd like to just be able to restore a specified database. >> >>Is there anyway of doing this? >> >>Tony Flaherty. >>Analyst Programmer >>Misys Financial Systems >> >>Change at to @ to reply by email >> >> > >