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?

Hi,

imported restore using onbar and ISM is described in "IBM Informix Storage
Manager Administrator's Guide" chapter "Transferring Data with the
Imported Restore". It can be found at following URL:
http://publib.boulder.ibm.com/infoce...doc/ism107.htm

Andreas


On Wednesday 28 December 2005 01:31, you wrote:

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 (AT) iiug (DOT) org
[mailto:informix-list-bounces (AT) iiug (DOT) org]On Behalf Of david (AT) smooth1 (DOT) co.uk
Sent: Tuesday, December 27, 2005 6:31 PM
To: informix-list (AT) iiug (DOT) 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 (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Thanks for that.

I was looking at

http://publib.boulder.ibm.com/infoce.../barmst156.htm

"To perform the imported restore...

Storage-manager configuration files, if any
The storage-manager configuration files might need updating."

"The storage-manager configuation files might need updating" ?? How
clear is that?

We need examples for ISM, Tivoli (an IBM product) and Veritas NetBackup
as least.

Also...

http://publib.boulder.ibm.com/infoce...doc/ism128.htm

"For information on using nsr commands with ISM, see your Legato
NetWorker documentation."

WTF?? What Legato Networker documentation?

As a matter of interest which ISM versions match what Legato Networker
versions?

On Thursday 29 December 2005 00:55, david (AT) smooth1 (DOT) co.uk wrote:
choose "IBM Informix Storage Manager Administrator's Guide" chapter
"Transferring Data with the Imported Restore". It can be found at
following URL:
http://publib.boulder.ibm.com/infoce...doc/ism107.htm

step by step tutorial (next pages of the URL above):
Step 1: Backing Up the Source Database Server to ISM
http://publib.boulder.ibm.com/infoce...doc/ism108.htm

Step 2: Porting ISM to Your Target Database Server
http://publib.boulder.ibm.com/infoce...doc/ism109.htm

Step 3: Restoring Data from ISM to the Target Database
http://publib.boulder.ibm.com/infoce...doc/ism110.htm

to allow local operation only and backup to 4 devices only. Therefore some
"Legato Networker" commands are delivered with ISM. Most of them has ISM
wrappers (ism* commands).

Andreas