Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Restore instance.

    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.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    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

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    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

  4. #4
    Join Date
    Nov 2004
    Posts
    143
    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

  5. #5
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    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.

  6. #6
    Join Date
    Nov 2004
    Posts
    143
    Have a look at below post on IIUG

    International Informix Users Group

    It might help you

    regards,

    Nitin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •