onbar: imported restore, point in time?

Hi all. I need restore an old backup of my production servers. Let's talk about two servers: - INFORMIXSERVER=idsold, SERVERNUM=10 - INFORMIXSERVER=idsnew, SERVERNUM=20 Both running identical O.S. and IDS releases. Copied these files from idsold to idsnew: - ixbar.10 to ixbar.20 - oncfg_idsold.10 to oncfg.idsnew.20 - onconfig.ifxold to onconfig.ifxnew. Changed environment variables INFORMIXSERVER to idsnew and ONCONFIG to oncofig.ifxnew. Changed onconfig.ifxnew values: SERVERNUM, DBSERVERNAME and DBSERVERALIASES. Granted permissions in TSM: dsmc set access backup "/ifxold/ifxold/*/*" ifxnew. I've tried "onbar -b -p -t '2014-05-11 00:00:00'", "onbar -r -t '2014-05-11 00:00:00'", and answer is always: "There are no storage spaces/logical logs to backup/restore." At last, restored ifxold to ifxnew: onbar -r. But it restores to last ifxold backup, and I need a backup (not expired) from may-2014. Then I've tried "onbar -r -t...." on just restored server but doesn't work. Any idea about make imported restore at point in time? Thanks in advance.

Any help?, pls

Have you opened a support case with IBM? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Thu, Nov 6, 2014 at 7:55 AM, RAFAEL GOMEZ <rgomezs@gmail.com> wrote: > Any help?, pls > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c266be59d650050730b3f8

Hi Art. Thanks for answer. No I didn't, because it's an unsupported version (IDS 10.00). It's one of our older servers, we have migrated most of databases to IDS 11.70 (with active support) and deleted them, but now we need recover a group of original DDBB from backup. I trusted on IDS+TSM backups and made no more copies, but now I can't recover theese databases. Greetings. Rafael Gómez

I'm not sure about the problem... and I don't understand why you tried to backup (onbar -b...). But if an "onbar -r" works, you can't you simply edit the ixbar file and live just up to the one you want? Unless of course you really need a very specific point in time... Regards On Mon, Nov 3, 2014 at 3:51 PM, RAFAEL GOMEZ <rgomezs@gmail.com> wrote: > Hi all. > > I need restore an old backup of my production servers. Let's talk about two > servers: > > - INFORMIXSERVER=idsold, SERVERNUM=10 > > - INFORMIXSERVER=idsnew, SERVERNUM=20 > > Both running identical O.S. and IDS releases. Copied these files from > idsold > to idsnew: > > - ixbar.10 to ixbar.20 > - oncfg_idsold.10 to oncfg.idsnew.20 > - onconfig.ifxold to onconfig.ifxnew. > > Changed environment variables INFORMIXSERVER to idsnew and ONCONFIG to > oncofig.ifxnew. Changed onconfig.ifxnew values: SERVERNUM, DBSERVERNAME and > DBSERVERALIASES. > > Granted permissions in TSM: dsmc set access backup "/ifxold/ifxold/*/*" > ifxnew. > > I've tried "onbar -b -p -t '2014-05-11 00:00:00'", "onbar -r -t '2014-05-11 > 00:00:00'", and answer is always: "There are no storage spaces/logical > logs to > backup/restore." > > At last, restored ifxold to ifxnew: onbar -r. But it restores to last > ifxold > backup, and I need a backup (not expired) from may-2014. Then I've tried > "onbar -r -t...." on just restored server but doesn't work. > > Any idea about make imported restore at point in time? Thanks in advance. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7bdca6e03f84a00507322a10

Hi Fernando. Sorry my mistake, I wrote I've tried "onbar -b -p -t '2014-05-11 00:00:00'", "onbar -r -t '2014-05-11 00:00:00'" When I really should have written: I've tried "onbar -r -p -t '2014-05-11 00:00:00'", "onbar -r -t '2014-05-11 00:00:00'" Typo mistake. In my ixbar.50: comple1 63983 L 0 91202 0 0 3045378883 2014-05-13 16:05:44 1 0 0 91202 0 - - 63983 1399989944 1399961136 comple1 63984 L 0 91210 0 0 3045400277 2014-05-13 20:05:43 1 0 0 91210 0 - - 63984 1400004342 1399989944 comple1 63985 L 0 91218 0 0 3046138548 2014-05-13 23:05:56 1 0 0 91218 0 - - 63985 1400015156 1400004342 comple1 63986 L 0 91219 0 0 3046278498 2014-05-14 01:05:13 1 0 0 91219 0 - - 63986 1400022312 1400015156 comple1 63987 L 0 91220 0 0 3046286381 2014-05-14 01:07:59 1 0 0 91220 0 - - 63987 1400022478 1400022312 comple1 63988 L 0 91221 0 0 3046312764 2014-05-14 01:12:14 1 0 0 91221 0 - - 63988 1400022733 1400022478 comple1 63989 L 0 91222 0 0 3047695090 2014-05-14 07:52:44 1 0 0 91222 0 - - 63989 1400046763 1400022733 comple1 63990 L 0 91230 0 0 3047698669 2014-05-14 08:05:43 1 0 0 91230 0 - - 63990 1400047542 1400046763 comple1 63991 L 0 91238 0 0 3047730903 2014-05-14 12:05:18 1 0 0 91238 0 - - 63991 1400061918 1400047542 comple1 63992 L 0 91246 0 0 3047735732 2014-05-14 16:05:08 1 0 0 91246 0 - - 63992 1400076308 1400061918 comple1 63993 L 0 91254 0 0 3047761893 2014-05-14 20:05:23 1 0 0 91254 0 - - 63993 1400090723 1400076308 comple1 63994 L 0 91262 0 0 3048487082 2014-05-14 23:04:54 1 0 0 91262 0 - - 63994 1400101494 1400090723 comple1 63995 L 0 91263 0 0 3048657634 2014-05-15 01:06:12 1 0 0 91263 0 - - 63995 1400108771 1400101494 comple1 63996 L 0 91264 0 0 3048680451 2014-05-15 01:10:09 1 0 0 91264 0 - - 63996 1400109008 1400108771 Where comple1 is the original server. Any backup between 2014-05-01 00:00:00 and 2014-05-14 15:00:00 should be valid. I've tried to an exact point in time of ixbar file, "onbar -r -p -t '2014-05-11 01:05:13'", but doesn't work. From my online.log file: 2014-11-03 12:43:10 20493 20491 /opt/informix/bin/onbar_d -r -p -t 2014-05-14 01:05:13 2014-11-03 12:43:16 20493 20491 There are no storage spaces/logical logs to backup/restore. 2014-11-03 12:43:21 20493 20491 (-43140) Due to the previous error, logical restore will not be attempted. 2014-11-03 12:43:21 20493 20491 /opt/informix/bin/onbar_d complete, returning 147 (0x93) I dont't care about error -43140, it raises because no physical restore has been made and so, can't make logical restore. Regards. Rafael Gómez

Unless I'm misreading the ixbar file, there is not backup recorded there as being available prior to May 15, 2014 so you cannot do a point-in-time restore dated May 11, 2014! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Thu, Nov 6, 2014 at 10:42 AM, RAFAEL GOMEZ <rgomezs@gmail.com> wrote: > Hi Fernando. > > Sorry my mistake, I wrote > > I've tried "onbar -b -p -t '2014-05-11 00:00:00'", "onbar -r -t '2014-05-11 > 00:00:00'" > > When I really should have written: > > I've tried "onbar -r -p -t '2014-05-11 00:00:00'", "onbar -r -t '2014-05-11 > 00:00:00'" > > Typo mistake. > > In my ixbar.50: > > comple1 63983 L 0 91202 0 0 3045378883 2014-05-13 16:05:44 1 0 0 91202 0 - > - > 63983 1399989944 1399961136 > comple1 63984 L 0 91210 0 0 3045400277 2014-05-13 20:05:43 1 0 0 91210 0 - > - > 63984 1400004342 1399989944 > comple1 63985 L 0 91218 0 0 3046138548 2014-05-13 23:05:56 1 0 0 91218 0 - > - > 63985 1400015156 1400004342 > comple1 63986 L 0 91219 0 0 3046278498 2014-05-14 01:05:13 1 0 0 91219 0 - > - > 63986 1400022312 1400015156 > comple1 63987 L 0 91220 0 0 3046286381 2014-05-14 01:07:59 1 0 0 91220 0 - > - > 63987 1400022478 1400022312 > comple1 63988 L 0 91221 0 0 3046312764 2014-05-14 01:12:14 1 0 0 91221 0 - > - > 63988 1400022733 1400022478 > comple1 63989 L 0 91222 0 0 3047695090 2014-05-14 07:52:44 1 0 0 91222 0 - > - > 63989 1400046763 1400022733 > comple1 63990 L 0 91230 0 0 3047698669 2014-05-14 08:05:43 1 0 0 91230 0 - > - > 63990 1400047542 1400046763 > comple1 63991 L 0 91238 0 0 3047730903 2014-05-14 12:05:18 1 0 0 91238 0 - > - > 63991 1400061918 1400047542 > comple1 63992 L 0 91246 0 0 3047735732 2014-05-14 16:05:08 1 0 0 91246 0 - > - > 63992 1400076308 1400061918 > comple1 63993 L 0 91254 0 0 3047761893 2014-05-14 20:05:23 1 0 0 91254 0 - > - > 63993 1400090723 1400076308 > comple1 63994 L 0 91262 0 0 3048487082 2014-05-14 23:04:54 1 0 0 91262 0 - > - > 63994 1400101494 1400090723 > comple1 63995 L 0 91263 0 0 3048657634 2014-05-15 01:06:12 1 0 0 91263 0 - > - > 63995 1400108771 1400101494 > comple1 63996 L 0 91264 0 0 3048680451 2014-05-15 01:10:09 1 0 0 91264 0 - > - > 63996 1400109008 1400108771 > > Where comple1 is the original server. > > Any backup between 2014-05-01 00:00:00 and 2014-05-14 15:00:00 should be > valid. > > I've tried to an exact point in time of ixbar file, "onbar -r -p -t > '2014-05-11 01:05:13'", but doesn't work. From my online.log file: > > 2014-11-03 12:43:10 20493 20491 /opt/informix/bin/onbar_d -r -p -t > 2014-05-14 > 01:05:13 > 2014-11-03 12:43:16 20493 20491 There are no storage spaces/logical logs to > backup/restore. > 2014-11-03 12:43:21 20493 20491 (-43140) Due to the previous error, logical > restore will not be attempted. > 2014-11-03 12:43:21 20493 20491 /opt/informix/bin/onbar_d complete, > returning > 147 (0x93) > > I dont't care about error -43140, it raises because no physical restore has > been made and so, can't make logical restore. > > Regards. > > Rafael Gómez > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0122930a36a125050732b2eb

Hi Art. Thanks for your answer. You're right, reading whole ixbar file I can see there is no backup before June, 29 2014, just log backups (I didn't know how to read ixbar). At this date I find: comple1 64327 L 0 92758 0 0 3147801218 2014-06-29 01:07:35 1 0 0 92758 0 - - 64327 1403996854 1403989552 comple1 64328 L 0 92759 0 0 3147808671 2014-06-29 01:09:13 1 0 0 92759 0 - - 64328 1403996952 1403996854 comple1 64329 L 0 92760 0 0 3147811597 2014-06-29 01:10:14 1 0 0 92760 0 - - 64329 1403997012 1403996952 comple1 64330 L 0 92761 0 0 3147824029 2014-06-29 01:12:38 1 0 0 92761 0 - - 64330 1403997156 1403997012 comple1 64331 L 0 92762 0 0 3147836802 2014-06-29 01:17:52 1 0 0 92762 0 - - 64331 1403997471 1403997156 comple1 64332 L 0 92763 0 0 3147845705 2014-06-29 01:25:29 1 0 0 92763 0 - - 64332 1403997927 1403997471 comple1 64333 L 0 92764 0 0 3147868013 2014-06-29 01:35:40 1 0 0 92764 0 - - 64333 1403998539 1403997927 comple1 complebld B 0 92767 0 0 3148006037 2014-06-29 13:00:06 1 64334 -532127140 92767 0 - - 64334 1404039606 1403998539 comple1 compledbs ND 0 92770 0 0 3148006057 2014-06-29 13:00:06 1 64334 -532127140 92770 0 - - 64334 1404039606 1403998539 comple1 documbld B 0 92768 0 0 3148006051 2014-06-29 13:00:06 1 64334 -532127140 92768 0 - - 64334 1404039606 1403998539 comple1 logdbs CD 0 92766 0 0 3148006036 2014-06-29 13:00:06 1 64334 -532127140 92766 0 - - 64334 1404039606 1403998539 comple1 physdbs ND 0 92771 0 0 3148006058 2014-06-29 13:00:06 1 64334 -532127140 92771 0 - - 64334 1404039606 1403998539 comple1 rootdbs R 0 92765 0 0 3148006035 2014-06-29 13:00:06 1 64334 -532127140 92765 0 - - 64334 1404039606 1403998539 comple1 rsn_bld B 0 92769 0 0 3148006056 2014-06-29 13:00:06 1 64334 -532127140 92769 0 - - 64334 1404039606 1403998539 comple1 64334 L 0 92772 0 0 3148006059 2014-06-29 13:12:24 1 0 0 92772 0 - - 64334 1404040344 1403998539 So I suppose I can restore to 2014-06-29 13:00:06 (when rootdbs was copied), the I executed: "onbar -r -p -t '2014-06-29 13:00:06'", but doens't work. Content of bar_act is: 2014-11-07 11:06:17 15141 15139 /opt/informix/bin/onbar_d -r -p -t 2014-06-29 13:00:06 2014-11-07 11:06:23 15141 15139 Successfully connected to Storage Manager. 2014-11-07 11:06:23 15141 15139 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager. 2014-11-07 11:06:23 15141 15139 Object information: bar_objdesc obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 92765 act_type 3 act_status 0 act_start '2014-11-07 11:06:23' act_end '2014-06-29 13:00:06' ins_time 0 rsam_time -532127140 seal_time 1404039606 prev_seal_time 1403998539 level 0 copyid hi:lo 0:3148006035 req_act_id 92765 logstream 0 est_pages hi:lo 0:0 first_log 64334 chpt_log 64334 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 '' 2014-11-07 11:06:23 15141 15139 There are no storage spaces/logical logs to backup/restore. 2014-11-07 11:06:28 15141 15139 (-43140) Due to the previous error, logical restore will not be attempted. 2014-11-07 11:06:28 15141 15139 /opt/informix/bin/onbar_d complete, returning 147 (0x93) When I try with -t '2014-06-30 00:00:00', to get last backup from previous day, I got same error. On the other side, as backups previous to this date are still in TSM, could I get it from TSM and asimilate in IDS? Greetings.

Your command line: onbar -r -p -t '2014-06-29 13:00:06 is specifying a point-in-time (or PIT) restore with the -p or physical restore flag included. Try a full restore without the -p. As to recovering another backup from TSM that is not recorded in the ixbar file, you should be able to do that, I'm not sure how. Have you tried rebuilding the ixbar file? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Fri, Nov 7, 2014 at 5:16 AM, RAFAEL GOMEZ <rgomezs@gmail.com> wrote: > Hi Art. > > Thanks for your answer. You're right, reading whole ixbar file I can see > there > is no backup before June, 29 2014, just log backups (I didn't know how to > read > ixbar). At this date I find: > > comple1 64327 L 0 92758 0 0 3147801218 2014-06-29 01:07:35 1 0 0 92758 0 - > - > 64327 1403996854 1403989552 > comple1 64328 L 0 92759 0 0 3147808671 2014-06-29 01:09:13 1 0 0 92759 0 - > - > 64328 1403996952 1403996854 > comple1 64329 L 0 92760 0 0 3147811597 2014-06-29 01:10:14 1 0 0 92760 0 - > - > 64329 1403997012 1403996952 > comple1 64330 L 0 92761 0 0 3147824029 2014-06-29 01:12:38 1 0 0 92761 0 - > - > 64330 1403997156 1403997012 > comple1 64331 L 0 92762 0 0 3147836802 2014-06-29 01:17:52 1 0 0 92762 0 - > - > 64331 1403997471 1403997156 > comple1 64332 L 0 92763 0 0 3147845705 2014-06-29 01:25:29 1 0 0 92763 0 - > - > 64332 1403997927 1403997471 > comple1 64333 L 0 92764 0 0 3147868013 2014-06-29 01:35:40 1 0 0 92764 0 - > - > 64333 1403998539 1403997927 > comple1 complebld B 0 92767 0 0 3148006037 2014-06-29 13:00:06 1 64334 > -532127140 92767 0 - - 64334 1404039606 1403998539 > comple1 compledbs ND 0 92770 0 0 3148006057 2014-06-29 13:00:06 1 64334 > -532127140 92770 0 - - 64334 1404039606 1403998539 > comple1 documbld B 0 92768 0 0 3148006051 2014-06-29 13:00:06 1 64334 > -532127140 92768 0 - - 64334 1404039606 1403998539 > comple1 logdbs CD 0 92766 0 0 3148006036 2014-06-29 13:00:06 1 64334 > -532127140 92766 0 - - 64334 1404039606 1403998539 > comple1 physdbs ND 0 92771 0 0 3148006058 2014-06-29 13:00:06 1 64334 > -532127140 92771 0 - - 64334 1404039606 1403998539 > comple1 rootdbs R 0 92765 0 0 3148006035 2014-06-29 13:00:06 1 64334 > -532127140 92765 0 - - 64334 1404039606 1403998539 > comple1 rsn_bld B 0 92769 0 0 3148006056 2014-06-29 13:00:06 1 64334 > -532127140 92769 0 - - 64334 1404039606 1403998539 > comple1 64334 L 0 92772 0 0 3148006059 2014-06-29 13:12:24 1 0 0 92772 0 - > - > 64334 1404040344 1403998539 > > So I suppose I can restore to 2014-06-29 13:00:06 (when rootdbs was > copied), > the I executed: "onbar -r -p -t '2014-06-29 13:00:06'", but doens't work. > Content of bar_act is: > > 2014-11-07 11:06:17 15141 15139 /opt/informix/bin/onbar_d -r -p -t > 2014-06-29 > 13:00:06 > 2014-11-07 11:06:23 15141 15139 Successfully connected to Storage Manager. > 2014-11-07 11:06:23 15141 15139 XBSA Error: (BSAGetObject) Backup object > does > not exist in Storage Manager. > 2014-11-07 11:06:23 15141 15139 Object information: bar_objdesc > > obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 92765 act_type 3 > act_status 0 > > act_start '2014-11-07 11:06:23' act_end '2014-06-29 13:00:06' > > ins_time 0 rsam_time -532127140 seal_time 1404039606 prev_seal_time > 1403998539 > level 0 copyid hi:lo 0:3148006035 req_act_id 92765 > > logstream 0 est_pages hi:lo 0:0 first_log 64334 chpt_log 64334 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 '' > 2014-11-07 11:06:23 15141 15139 There are no storage spaces/logical logs to > backup/restore. > 2014-11-07 11:06:28 15141 15139 (-43140) Due to the previous error, logical > restore will not be attempted. > 2014-11-07 11:06:28 15141 15139 /opt/informix/bin/onbar_d complete, > returning > 147 (0x93) > > When I try with -t '2014-06-30 00:00:00', to get last backup from previous > day, I got same error. > > On the other side, as backups previous to this date are still in TSM, > could I > get it from TSM and asimilate in IDS? > > Greetings. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113498828fed630507430ba1