INFORMIX Database Restore on LEGATO

[Guest_imported]

Hi,


Can somebody help me, how to restore informix database on a different server? Any advise will be appriciated.

Thanks...

 

[sherrie01]

Does the 'new' server have the same name as the old server ?

This will make a difference as to how to do the restore.

Let me know...

 

[schu]

Are you using onbar? if so ...

You will need the ixbar and oncfg_ files if you used onbar to backup the database. Important that the ixbar is renamed to the new server.

We use legato to store and restore on different instances without any problems.

 

[Guest_imported]

hi schu,

yap i'm using onbar.. is ixbar part of legato?

 

[gotik]

So?
What happened schu?

Tell us how you perform a Networker restore in a different machine.

 

[schu]

sorry, been away,

ixbar and oncfg are part of onbar output files.
They are in the format

$INFORMIXDIR/etc/ixbar.<servnum>
$INFORMIXDIR/etc/oncfg_<dbname>.<servnum>

every time you backup, it creates an extra entry in ixbar and saves your config of the backup in oncfg.

For exapmple if your source server is SERVNUM 1 and the target is SERVNUM 2

backup all ixbar.2 and oncfg_<dbanem>.2
cp ixbar.1 ixbar.2
and oncfg_<dbname1>.1 oncfg_<dbname2>.2

run
onbar_d -r -w -p &
to restore last backup

Notes:
make sure your Legato environment vars are set up
ie
NSR_CLIENT, NSR_SERVER, NSR_DATA_VOLUME_POOL, NSR_LOG_VOLUME_POOL

and also make sure the number and size of the dbspaces and logical logs are same for both instances.

hope it helps