Hi Colleagues,

I need restore an instance in other machine, the backup is with onbar. The System Operative is Suse Linux Enterprise Server, IDS 11.50.

Somebody can tell me what is the procedure for restore an instance or database.

greetings.

Hi,

I have never done a restore on Linux, but I think, it should be similar to AIX (Machines, OS & Informix version should be identical ).

copy the ixbar.<servernum>, sqlhosts, onconfig to $INFORMIXDIR/etc
The new box should have exactly the same LVs (if you are using the raw devices) as on original box. Check the TSM connectivity, you should have the correct parameters in dsm.sys and dsm.opt to connect you to the TSM server where you backed up the DB.Also worth checking sm_versions. Once the connectivity is proven, I think, you can run the restore command (onbar -r) or point in time restore.

I might be forgetting something, but you can still give it a go and fix the issue on the run. :-)

Nitin

Hi nitin_math,

Thank you for you help, I have an instance in production with cooked file. The backup is with onbar and Informix Storage Manager (ISM). In production with the engine online i execute onbar -b -w, I define /home/dbspaces and /home/logfiles to save the backup in onconfig LTAPEDEV /home/logfiles to save logical log. then transfer the files from production to developer server.
also the files sm_versions, onconfig, sqlhosts, ixbar.server and oncfg.server_number and files from /home/dbspaces and files from /home/logfiles.

In developer server I define the same dbspaces with the same chunks but with raw devices. In this server developer I start ISM with the engine offline and also i have create the directory /usr/dbspaces and /usr/logfiles in this onconfig the parameter LTAPEDEV /usr/logfiles, in both server the servernum and servername are the same. Once time I have copy all files in server developer with engine offline as user informix i execute onbar -r -w in file bar_act.log are errors.

What is the form to execute the backup or restore with onbar?
In what mode will be the engine in server developer to do restore?
Any help is very appreciate,

Thank you for you help

Hi,

Please use the command "onbar -r" to restore when the informix server is offline.

Also, can you please post the copy of bar log & message log.

regards,
Nitin

Hi nitin_math,

This is the output bar_act.log

2010-04-09 17:01:06 26329 26327 /usr/informix/bin/onbar_d -r -w
2010-04-09 17:01:11 26329 26327 Successfully connected to Storage Manager.
2010-04-09 17:01:11 26329 26327 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
2010-04-09 17:01:11 26329 26327 Object information: bar_objdesc
obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 26 act_type 2 act_status 0
act_start '2010-04-09 17:01:11' act_end '2010-04-08 14:17:32'
ins_time 0 rsam_time 1718229 seal_time 1270729052 prev_seal_time 1270637890 level 0 copyid hi:lo 348743465:0 req_act_id 26
logstream 0 est_pages hi:lo 0:0 first_log 33 chpt_log 33 last_log 0
partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
ins_verify 0 ins_verify_date '' restore order 0:0
objInfo ''
retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host '' backup_order 93
2010-04-09 17:01:11 26329 26327 (-43342) Cannot read reserved pages from rootdbs object.
2010-04-09 17:01:11 26329 26327 /usr/informix/bin/onbar_d complete, returning 100 (0x64)

thank you for you help.

regards,
Georgi.

Have a look at below post on IIUG

International Informix Users Group

It might help you

regards,

Nitin