muone 发表于 2007-05-17 10:25

informix日志恢复的问题。

我在做informix异机恢复的时候,遇到以下情况,
恢复过程都很顺利。物理恢复完成,在回滚日志的时候提示一个日志找不到,我查了ixbar里面包含的信息和备份时的信息,这个日志是成功备份了的。不知道是什么原因,回滚的日志如果相对只有几个则可以完成整个恢复过程。

我想请问,这样的问题可能是什么原因造成的。下面贴上onbar的出错信息。

2007-05-16 18:10:19 848060794844 /home/informix/bin/onbar_d -r -n 125491
2007-05-16 18:10:19 848060794844 (-43391) Skipped backup/restore of space 'rootdbs'.
2007-05-16 18:12:35 692254848060 Process 692254848060 successfully forked.
2007-05-16 18:12:35 745594848060 Process 745594848060 successfully forked.
2007-05-16 18:12:35 692254848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 725160848060 Process 725160848060 successfully forked.
2007-05-16 18:12:35 688186848060 Process 688186848060 successfully forked.
2007-05-16 18:12:35 704686848060 Process 704686848060 successfully forked.
2007-05-16 18:12:35 819326848060 Process 819326848060 successfully forked.
2007-05-16 18:12:35 745594848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 819326848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 725160848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 688186848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 704686848060 Successfully connected to Storage Manager.
2007-05-16 18:12:38 745594848060 Begin cold level 0 restore plogdbs (Storage Manager copy ID: 1179273950 1179273951).
2007-05-16 18:12:39 692254848060 Begin cold level 0 restore logdbs (Storage Manager copy ID: 1179273949 1179273950).
2007-05-16 18:12:39 725160848060 Begin cold level 0 restore idxdbs1 (Storage Manager copy ID: 1179273951 1179273952).
2007-05-16 18:12:39 704686848060 Begin cold level 0 restore scmiddbs (Storage Manager copy ID: 1179273953 1179273954).
2007-05-16 18:12:39 688186848060 Begin cold level 0 restore quotedbs (Storage Manager copy ID: 1179273952 1179273953).
2007-05-16 18:12:39 692254848060 Completed cold level 0 restore logdbs.
2007-05-16 18:12:39 745594848060 Completed cold level 0 restore plogdbs.
2007-05-16 18:12:39 745594848060 Process 745594848060 completed.
2007-05-16 18:12:39 692254848060 Process 692254848060 completed.
2007-05-16 18:12:40 819326848060 Begin cold level 0 restore workdb1 (Storage Manager copy ID: 1179273956 1179273957).
2007-05-16 18:22:32 725160848060 Completed cold level 0 restore idxdbs1.
2007-05-16 18:22:32 725160848060 Process 725160848060 completed.
2007-05-16 18:24:35 819326848060 Completed cold level 0 restore workdb1.
2007-05-16 18:24:35 819326848060 Process 819326848060 completed.
2007-05-16 18:48:32 704686848060 Completed cold level 0 restore scmiddbs.
2007-05-16 18:48:32 704686848060 Process 704686848060 completed.
2007-05-16 18:50:01 688186848060 Completed cold level 0 restore quotedbs.
2007-05-16 18:50:01 688186848060 Process 688186848060 completed.
2007-05-16 18:50:02 848060794844 Successfully connected to Storage Manager.
2007-05-16 18:50:03 848060794844 Begin restore logical log 125481 (Storage Manager copy ID: 1179276963 1179276964).
2007-05-16 18:54:17 848060794844 Completed restore logical log 125481.
2007-05-16 18:54:18 848060794844 Begin restore logical log 125482 (Storage Manager copy ID: 1179289999 1179290000).
2007-05-16 18:55:49 848060794844 Completed restore logical log 125482.
2007-05-16 18:55:50 848060794844 Begin restore logical log 125483 (Storage Manager copy ID: 1179290018 1179290019).
2007-05-16 18:55:56 848060794844 Completed restore logical log 125483.
2007-05-16 18:55:56 848060794844 Begin restore logical log 125484 (Storage Manager copy ID: 1179300734 1179300735).
2007-05-16 18:56:25 848060794844 Completed restore logical log 125484.
2007-05-16 18:56:26 848060794844 Begin restore logical log 125485 (Storage Manager copy ID: 1179308522 1179308523).
2007-05-16 18:56:56 848060794844 Completed restore logical log 125485.
2007-05-16 18:56:56 848060794844 Begin restore logical log 125486 (Storage Manager copy ID: 1179312032 1179312033).
2007-05-16 18:57:37 848060794844 Completed restore logical log 125486.
2007-05-16 18:57:39 848060794844 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
2007-05-16 18:57:39 848060794844 Object information: bar_objdesc
   obj_id 0 obj_name '125487' obj_type 'L' act_id 0 act_type 2 act_status 0
   act_start '2007-05-16 18:57:37'act_end '2007-05-16 10:42:17'
   ins_time 0 rsam_time 0 level 0 copyid hi:lo 1179315729:1179315730 req_act_id 121349
   logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 0 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 ''
2007-05-16 18:57:39 848060794844 (-43258) ON-Bar could not get logical log 125487 from the storage manager.
2007-05-16 18:57:40 848060794844 (-43168) ON-Bar suspended the logical restore on log 125487 (expected to
restore to 125491).
2007-05-16 18:57:45 848060794844 /home/informix/bin/onbar_d complete, returning 100 (0x64)
2007-05-16 18:58:32 688210725242 /home/informix/bin/onbar_d -r -l
2007-05-16 18:58:35 688210725242 Successfully connected to Storage Manager.
2007-05-16 18:58:35 688210725242 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
2007-05-16 18:58:35 688210725242 Object information: bar_objdesc
   obj_id 0 obj_name '125487' obj_type 'L' act_id 0 act_type 2 act_status 0
   act_start '2007-05-16 18:58:35'act_end '2007-05-16 10:42:17'
   ins_time 0 rsam_time 0 level 0 copyid hi:lo 1179315729:1179315730 req_act_id 121349
   logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 0 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 ''
2007-05-16 18:58:35 688210725242 (-43258) ON-Bar could not get logical log 125487 from the storage manager.
2007-05-16 18:58:35 688210725242 (-43168) ON-Bar suspended the logical restore on log 125487 (expected to
restore to 2147483647).
2007-05-16 18:58:40 688210725242 /home/informix/bin/onbar_d complete, returning 100 (0x64)

czw1413_cn 发表于 2007-05-17 20:18

lianyong 发表于 2007-05-19 00:18

1楼:
你用的是什么备份设备(带库)?备份软件是哪一种?
从日志看你的恢复过程是指定恢复到某个逻辑日志? 但又报存储管理器种找不到其中某个逻辑日志,奇怪的很。
难到你的逻辑日志是由另外单独的备份设备做备份?
页: [1]
查看完整版本: informix日志恢复的问题。