Re: Copying databases using onarchive/ondatartr

ajb@bigbook.com ("Adrian Blakey") wrote: >I am having some trouble copying a database using the above combination. >I performed a level 0 archive of a database running on machine A, to disk. This >seems to have run correctly and produced several files in the tree specified in >the config.arc file's DEVICE parm. >Now comes the fun stuff... >I have moved the volumes over to another machine, remounted them at exactly the >same mount points as they were on the original, and tried to restore the whole >thing into an empty database in order to make a copy of the original. >I use ondatartr. >This is the console: >$ ondatartr >ON-Datartr Version 7.10 >Copyright (c) 1993,1994 - Informix Software, Inc. >ONDATARTR> retrieve/dbspaceset=*/disk=(/arc/arc1) >Executing... >What saveset ID is to be used on volume /arc/arc1?:00000003 >Level 0 physical restore started. >$ >It does nothing. >The following is what's on /arc/arc1. >ONDATARTR> list/disk=(/arc/arc1) > Listing of : arcbb > Volume no : 0001 > --------------------- >ONARCHIVE Version : ONARCHIVE VERSION 7.10 >Save-set file name : /arc/arc1/00000003.SAV >Archive date : 14-FEB-1996:19:25:01 >Save-set type : OS files >Operating system : PAGE4096 IEEEM BYTE32 >DBMS : IXARCDB_VER_07.10 LEVEL0 >Owner node : spiral >Owner name : informix >Archive command : ARCHIVE/DBSPACESET=*/VSET=arcbb/NOAPART/BLOCKSIZE=65536 > : /NOCOMPRESS/COPIES=1/NOENCRYPT/NOLOG/NONOTIFY/NOCRC/NOT > : RANSIT/NOEXPIRY_DATE/LEVEL=0/NOVERIFY/NOIMMEDIATE/NOAUT > : OVOP >File name : rootdbs >File number : 1 >File sequence : 1 >File name : blobspace1 >File number : 2 >File sequence : 1 >File name : dataspace1 >File number : 3 >File sequence : 1 >Is Informix being too clever? and validating stuff which stops the restore into >a different database? I have done the obvious -- ie. rename the host to the >same name as the original... >Any ideas? I am not clear on what host your referring to, but informix stores the machine hostname when you use onarchive. We had similar trouble running onarchive backups after the ip address changed. After talking to informix they said we could build alias of the old machine in /etc/hosts and /etc/services or we could redefine the archive sets. We got the message could not backup to a remote save set(or something like that its been a couple of months). We started back using ontape. We have successfully done what your trying to do several times with ontape.