RE: Informix manuals - imported restore

i used to do the imported restore couple of years ago, below are the steps that i used to follow (for informix version 9.21) 1) copy the ism backup directory from source machine to target machine 2) initialize the ism on the target machine 3) remove the default device from the target machine (using ism_rm command) 4) ism data files have hostname embedded in it, you will need to run the nsradmin with -s and -i options to change it. here are the commands how to do it, Step #1) create /tmp/tempfile file as below and then run nsradmin command, (you have to enter the source and target machine names in the echo statement wherever you see <enter your source/target machine name here>. echo "create type: NSR client; name: <enter your source machine name here>; remote access: root@<enter your target machine name here>, informix@<enter your target machine name here>" > /tmp/tempfile Step #2) issue the following command nsradmin -s <enter your target machine name here> -i /tmp/tempfile 5) recreate the ism catalog data using the ism_catalog -recreate_from <backup_dir_name> command 6) sync the media using nsrim -v command 7) make device appendable using ism_op command 8) replace source instance name with target instance name in ixbar on the target machine 9) copy oncfg file from source machine to target machine 10) start the restore -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of david@smooth1.co.uk Sent: Tuesday, December 27, 2005 6:31 PM To: informix-list@iiug.org Subject: Informix manuals - imported restore Has anyone done an imported restore using onbar and ISM? Apparently you can a) use onbar/Ism on one host to backup to disk b) restore onto another host (possibly without copying everything over) The restore involves logging into the new host with INFORMIXSERVER set to the old servername and ISM_CLIENT/ISM_SERVER environment variables set... The manual (Backup and Recovery Guide) has a section on Imported Restore and it is crap. No details on how to do it via ISM. Or if you can restore from a remote ISM setup. I've seen something on there (39 steps) but sections are unclear e.g. set INFORMIXSERVER etc but to the source or target INFORMIXSERVER name? and this involves copying everything over that I'm not sure is required. Also these steps (from Malcolm Wellans) include ISM_CLIENT and ISM_SERVER env vars that are not in the manuals. Anyone? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list