Re: Ontape restore to different machine
Posted in 1998
Topics: Backup & Restore, Storage & Space Management, Server Administration, Platform-Specific Issues
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
>>>
>>>
>>
>>
>
Related threads
- IDS 10 table-level restore
- DBPATH & INFORMIXSERVER - HELP
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape