Re: Ontape restore to different machine

Yes, you could do that. Both instances currently share some link names, so you'd have to change those links before doing the restore. Tony Flaherty wrote in message <910349504.13831.0.nnrp-11.c1ed1f69@news.demon.co.uk>... >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 >>> >>> >> >> >