Oninit cdi / Archive
Talk to an expert →

ONBAR point-in-time recovery fails

Posted in 2009

Topics: Backup & Restore, Storage & Space Management

JIMMY JONSSON — — source: IIUG Forums & Mailing Lists

My customer had a batchjob that went wrong and corrupted a couple of tables a week ago. I am now trying to restore the database onto another server to recover the tables that got wiped out. By looking into the file ixbar.0 i have figured out that i need to restore the database to log number 23754. The physical restore runs ok, but when i run the logical restore the following messages show up in the bar_act.log file: 2009-08-24 13:22:50 15607 15605 /opt/IBM/informix/bin/onbar_d -r -l -n 23754 2009-08-24 13:22:50 15607 15605 bar_build_timeline: target time 1250244000 2009-08-24 13:22:54 15607 15605 Successfully connected to Storage Manager. 2009-08-24 13:22:54 15607 15605 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager. 2009-08-24 13:22:54 15607 15605 Object information: bar_objdesc obj_id 0 obj_name 'root' obj_type 'R' act_id 6979 act_type 2 act_status 0 act_start '2009-08-24 13:22:54' act_end '2009-08-13 19:00:18' ins_time 0 rsam_time -967717293 seal_time 1250182818 prev_seal_time 1250175809 level 0 copyid hi:lo 0:92643891 req_act_id 6979 logstream 0 est_pages hi:lo 0:0 first_log 23754 chpt_log 23754 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 196 2009-08-24 13:22:54 15607 15605 (-43342) Cannot read reserved pages from rootdbs object. 2009-08-24 13:22:54 15607 15605 /opt/IBM/informix/bin/onbar_d complete, returning 100 (0x64) I cannot find any information about this error. Is this procedure the right one: onbar -r -p -n 23754 onbar -r -l -n 23754 Regards Jimmy Jonsson

↪ replying to JIMMY JONSSON
Andrew Grantham — — source: IIUG Forums & Mailing Lists

Jimmy, Did you copy over the ixbar file to the server you are restoring the instance onto? Also are your logical logs being backed up? If so how? Using onbar? To the black hole /dev/null? Regards > To: ids@iiug.org > From: > Subject: ONBAR point-in-time recovery fails [16773] > Date: Mon, 24 Aug 2009 07:59:24 -0400 > > My customer had a batchjob that went wrong and corrupted a couple of tables a > week ago. I am now trying to restore the database onto another server to > recover the tables that got wiped out. > > By looking into the file ixbar.0 i have figured out that i need to restore the > database to log number 23754. The physical restore runs ok, but when i run the > logical restore the following messages show up in the bar_act.log file: > > 2009-08-24 13:22:50 15607 15605 /opt/IBM/informix/bin/onbar_d -r -l -n 23754 > 2009-08-24 13:22:50 15607 15605 bar_build_timeline: target time 1250244000 > 2009-08-24 13:22:54 15607 15605 Successfully connected to Storage Manager. > 2009-08-24 13:22:54 15607 15605 XBSA Error: (BSAGetObject) Backup object does > not exist in Storage Manager. > 2009-08-24 13:22:54 15607 15605 Object information: bar_objdesc > > obj_id 0 obj_name 'root' obj_type 'R' act_id 6979 act_type 2 act_status 0 > > act_start '2009-08-24 13:22:54' act_end '2009-08-13 19:00:18' > > ins_time 0 rsam_time -967717293 seal_time 1250182818 prev_seal_time 1250175809 > level 0 copyid hi:lo 0:92643891 req_act_id 6979 > > logstream 0 est_pages hi:lo 0:0 first_log 23754 chpt_log 23754 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 196 > 2009-08-24 13:22:54 15607 15605 (-43342) Cannot read reserved pages from > rootdbs object. > 2009-08-24 13:22:54 15607 15605 /opt/IBM/informix/bin/onbar_d complete, > returning 100 (0x64) > > I cannot find any information about this error. > > Is this procedure the right one: > > onbar -r -p -n 23754 > onbar -r -l -n 23754> > Regards > Jimmy Jonsson > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Windows Live Messenger: Celebrate 10 amazing years with free winks and emoticons. http://clk.atdmt.com/UKM/go/157562755/direct/01/

↪ replying to JIMMY JONSSON
Art Kagel — — source: IIUG Forums & Mailing Lists

Jimmy, I don't know what that message is about specifically, except to say that the local onbar configuration on the machine you are restoring to doesn't know about whatever logical log backup was performed after this archive was taken. However, you DO NOT have to restore the server to be able to recover the data from the archive. You can use the table level data restore feature of the archecker utility to extract the data from the damaged tables and directly insert the data to the original tables or to a set of staging tables where you can filter the results further. See CHapter 17 of the Backup and Restore Guide for details on table level restore using archecker. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Aug 24, 2009 at 7:59 AM, <> wrote: > My customer had a batchjob that went wrong and corrupted a couple of tables > a > week ago. I am now trying to restore the database onto another server to > recover the tables that got wiped out. > > By looking into the file ixbar.0 i have figured out that i need to restore > the > database to log number 23754. The physical restore runs ok, but when i run > the > logical restore the following messages show up in the bar_act.log file: > > 2009-08-24 13:22:50 15607 15605 /opt/IBM/informix/bin/onbar_d -r -l -n > 23754 > 2009-08-24 13:22:50 15607 15605 bar_build_timeline: target time 1250244000 > 2009-08-24 13:22:54 15607 15605 Successfully connected to Storage Manager. > 2009-08-24 13:22:54 15607 15605 XBSA Error: (BSAGetObject) Backup object > does > not exist in Storage Manager. > 2009-08-24 13:22:54 15607 15605 Object information: bar_objdesc > > obj_id 0 obj_name 'root' obj_type 'R' act_id 6979 act_type 2 act_status 0 > > act_start '2009-08-24 13:22:54' act_end '2009-08-13 19:00:18' > > ins_time 0 rsam_time -967717293 seal_time 1250182818 prev_seal_time > 1250175809 > level 0 copyid hi:lo 0:92643891 req_act_id 6979 > > logstream 0 est_pages hi:lo 0:0 first_log 23754 chpt_log 23754 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 196 > 2009-08-24 13:22:54 15607 15605 (-43342) Cannot read reserved pages from > rootdbs object. > 2009-08-24 13:22:54 15607 15605 /opt/IBM/informix/bin/onbar_d complete, > returning 100 (0x64) > > I cannot find any information about this error. > > Is this procedure the right one: > > onbar -r -p -n 23754 > onbar -r -l -n 23754> > Regards > Jimmy Jonsson > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bf548868cb40471e3cc2c

Glossary