I have some relative small informix servers, running independently.
They are configured identically, but each has its own different data.

All of them are IDS 7.31 TD1 on windows 2000.

All perform periodic onbar backups (level 0, level 1, and logs) with ISM. I performed restores, on the same server the backup was performed. I save for each backup all the needed files: onconfig, ixbar and ol_cnfg.

Since its production, I was thinking of keeping a backup server, and when one of the working servers is damaged, restore it on the backup server. This is called imported restore. I found on my release notes the following note:
d. Verify that the ONCONFIG parameter BAR_BSALIB_PATH is set to the ISM XBSA library.

This library must have the patch LGTpa09766 from Legato installed.
Without this patch, restore cannot be done from a backup on
a separate host.

Link /usr/lib/ibsad001.so to /usr/lib/libbsa.so.1.

Need less to say I can't perform the imported restore.

1) does any one have experience with the imported restore?
2) Does any one give me a clue where I find this patch?
3) If I can skip it - What shell I do?

thanks

Dafna

Hi,

I assume you installed informix and ism in the same directories as the other server?

What is the exact error while trying th eimported restore?

2002-10-07 18:39:20 2328 1960 d:\informix\bin\onbar_d -r
2002-10-07 18:39:43 2328 1960 Successfully connected to Storage Manager.
2002-10-07 18:39:43 2328 1960 XBSA Error (BSAQueryObject): Backup object does not exist in Storage Manager.
2002-10-07 18:39:43 2328 1960 WARNING: ON-Bar was unable to get backup record of rootdbs from
storage manager.
2002-10-07 18:39:43 2328 1960 Due to the previous error, logical restore will not be attempted.
2002-10-07 18:39:43 2328 1960 d:\informix\bin\onbar_d: process exit 100 (0x64)

On unix it works like this:

Source = jupiter
Target = quake

Make sure ISM_DATA_POOL and ISM_LOG_POOL in the onconfig are the same on both
instances.

SOURCE

onbar –b –L 0

ism_shutdown –q

As root cd /nsr
tar cvf nsr_source.tar index mm

Move volume (tape or disk) to target

cp -p ixbar.7 ixbar.9
cp –p oncfg_jupitertngshm.7 oncfg_quaketstshm.9

ism_startup

run “dbaccess sysutils sysutils_obj_act_ins.sql” to see what logical log would
be needed to restore the archive and whether or not you have the on the volume
that you are using to restore.

TARGET

export ISM_SERVER=quake
export ISM_CLIENT=Jupiter

oninit

As root
ism_startup
ism_show –devices
ism_op –unmount device_name

As root
ism_shutdown –q
As Informix
onmode –yuk

As root
cd /nsr
rm –rf index mm

ftp from jupiter /nsr/nsr_source.tar to /nsr directory as root
make sure you are in /nsr dir
tar xvf nsr_source.tar

cd $INFORMIXDIR/etc or /daylogs/Informix/TST/etc
ftp from jupiter as Informix /daylogs/Informix/TNG/etc/ixbar.7
ftp from jupiter as Informix /daylogs/Informix/TNG/etc/oncfg_jupitertngshm.7
mv ixbar.7 ixbar.9
mv oncfg_jupitertngshm.7 oncfg_quaketstshm.9
vi ixbar.9 and change jupitertngshm to quaketstshm

As root
ism_startup
check daemon.log ( You may have to run nsrck –c)

Mount devices
ism_op –mount /dev/rmt/5mnb
ism_op –mount /dev/rmt/0mnb

create nsr_client_env file with following content, all on one line:
create type: NSR client; name: jupiter; remote access: root@quake,
informix@quake


As Informix run:
nsradmin –s quake –i nsr_client_file
If this fails then run:
nsradmin
v
select
NSR Client
delete entry for jupiter
Retry: nsradmin –s quake –i nsr_client_file

Make sure env has ISM_SERVER and ISM_CLIENT set:
env | grep ISM
if not then, issue:
export ISM_SERVER=quake
export ISM_CLIENT=Jupiter

You may have to clean up ixbar.# file before starting the restore. You may
want to get rid of extra backups in the and just leave the one that you are
restoring.

onbar –r –p

Make sure env has ISM_SERVER and ISM_CLIENT set:
env | grep ISM
if not then, issue:
export ISM_SERVER=quake
export ISM_CLIENT=Jupiter

onbar –r –l –n ## or onbar –r –l –t “date-time”

Hi
I tried the script, but couldn't find the Windows format of:
export ISM_SERVER=quake
export ISM_CLIENT=Jupiter

there were some more places that it didn't work one to one.

I guess I need some Windows informix experience

Thanks anyway
Dafna

Isn't it something like:
set ISM_SERVER=quake
set ISM_CLIENT=jupiter