免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › IT运维 › 存储备份 › informix恢复时遇到的问题
最近访问板块 发新帖
查看: 2066 | 回复: 3
打印 上一主题 下一主题

[备份软件] informix恢复时遇到的问题 [复制链接]

muone

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2007-05-17 10:26 |只看该作者 |倒序浏览
我在做informix异机恢复的时候，遇到以下情况，
恢复过程都很顺利。物理恢复完成，在回滚日志的时候提示一个日志找不到，我查了ixbar里面包含的信息和备份时的信息，这个日志是成功备份了的。不知道是什么原因，回滚的日志如果相对只有几个则可以完成整个恢复过程。

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

2007-05-16 18:10:19 848060  794844 /home/informix/bin/onbar_d -r -n 125491
2007-05-16 18:10:19 848060  794844 (-43391) Skipped backup/restore of space 'rootdbs'.
2007-05-16 18:12:35 692254  848060 Process 692254  848060 successfully forked.
2007-05-16 18:12:35 745594  848060 Process 745594  848060 successfully forked.
2007-05-16 18:12:35 692254  848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 725160  848060 Process 725160  848060 successfully forked.
2007-05-16 18:12:35 688186  848060 Process 688186  848060 successfully forked.
2007-05-16 18:12:35 704686  848060 Process 704686  848060 successfully forked.
2007-05-16 18:12:35 819326  848060 Process 819326  848060 successfully forked.
2007-05-16 18:12:35 745594  848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 819326  848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 725160  848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 688186  848060 Successfully connected to Storage Manager.
2007-05-16 18:12:35 704686  848060 Successfully connected to Storage Manager.
2007-05-16 18:12:38 745594  848060 Begin cold level 0 restore plogdbs (Storage Manager copy ID: 1179273950 1179273951).
2007-05-16 18:12:39 692254  848060 Begin cold level 0 restore logdbs (Storage Manager copy ID: 1179273949 1179273950).
2007-05-16 18:12:39 725160  848060 Begin cold level 0 restore idxdbs1 (Storage Manager copy ID: 1179273951 1179273952).
2007-05-16 18:12:39 704686  848060 Begin cold level 0 restore scmiddbs (Storage Manager copy ID: 1179273953 1179273954).
2007-05-16 18:12:39 688186  848060 Begin cold level 0 restore quotedbs (Storage Manager copy ID: 1179273952 1179273953).
2007-05-16 18:12:39 692254  848060 Completed cold level 0 restore logdbs.
2007-05-16 18:12:39 745594  848060 Completed cold level 0 restore plogdbs.
2007-05-16 18:12:39 745594  848060 Process 745594  848060 completed.
2007-05-16 18:12:39 692254  848060 Process 692254  848060 completed.
2007-05-16 18:12:40 819326  848060 Begin cold level 0 restore workdb1 (Storage Manager copy ID: 1179273956 1179273957).
2007-05-16 18:22:32 725160  848060 Completed cold level 0 restore idxdbs1.
2007-05-16 18:22:32 725160  848060 Process 725160  848060 completed.
2007-05-16 18:24:35 819326  848060 Completed cold level 0 restore workdb1.
2007-05-16 18:24:35 819326  848060 Process 819326  848060 completed.
2007-05-16 18:48:32 704686  848060 Completed cold level 0 restore scmiddbs.
2007-05-16 18:48:32 704686  848060 Process 704686  848060 completed.
2007-05-16 18:50:01 688186  848060 Completed cold level 0 restore quotedbs.
2007-05-16 18:50:01 688186  848060 Process 688186  848060 completed.
2007-05-16 18:50:02 848060  794844 Successfully connected to Storage Manager.
2007-05-16 18:50:03 848060  794844 Begin restore logical log 125481 (Storage Manager copy ID: 1179276963 1179276964).
2007-05-16 18:54:17 848060  794844 Completed restore logical log 125481.
2007-05-16 18:54:18 848060  794844 Begin restore logical log 125482 (Storage Manager copy ID: 1179289999 1179290000).
2007-05-16 18:55:49 848060  794844 Completed restore logical log 125482.
2007-05-16 18:55:50 848060  794844 Begin restore logical log 125483 (Storage Manager copy ID: 1179290018 1179290019).
2007-05-16 18:55:56 848060  794844 Completed restore logical log 125483.
2007-05-16 18:55:56 848060  794844 Begin restore logical log 125484 (Storage Manager copy ID: 1179300734 1179300735).
2007-05-16 18:56:25 848060  794844 Completed restore logical log 125484.
2007-05-16 18:56:26 848060  794844 Begin restore logical log 125485 (Storage Manager copy ID: 1179308522 1179308523).
2007-05-16 18:56:56 848060  794844 Completed restore logical log 125485.
2007-05-16 18:56:56 848060  794844 Begin restore logical log 125486 (Storage Manager copy ID: 1179312032 1179312033).
2007-05-16 18:57:37 848060  794844 Completed restore logical log 125486.
2007-05-16 18:57:39 848060  794844 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
2007-05-16 18:57:39 848060  794844 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 848060  794844 (-4325 ON-Bar could not get logical log 125487 from the storage manager.
2007-05-16 18:57:40 848060  794844 (-4316 ON-Bar suspended the logical restore on log 125487 (expected to
restore to 125491).
2007-05-16 18:57:45 848060  794844 /home/informix/bin/onbar_d complete, returning 100 (0x64)
2007-05-16 18:58:32 688210  725242 /home/informix/bin/onbar_d -r -l
2007-05-16 18:58:35 688210  725242 Successfully connected to Storage Manager.
2007-05-16 18:58:35 688210  725242 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
2007-05-16 18:58:35 688210  725242 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 688210  725242 (-4325 ON-Bar could not get logical log 125487 from the storage manager.
2007-05-16 18:58:35 688210  725242 (-4316 ON-Bar suspended the logical restore on log 125487 (expected to
restore to 2147483647).
2007-05-16 18:58:40 688210  725242 /home/informix/bin/onbar_d complete, returning 100 (0x64)
恢复, 恢复
hcjia

论坛徽章:
0
2楼 [报告]
发表于 2007-05-17 12:53 |只看该作者
是用legato 备份的吗？备份的log 和数据库是不存在不同的pool中吗??以前遇到这样的问题,是相关的log 找不到了,但不是很清楚你的情况!!
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
muone

论坛徽章:
0
3楼 [报告]
发表于 2007-05-17 13:14 |只看该作者
谢谢以上的恢复，问题已经解决了。使用legato 备份的出错的原因是index 信息量太大了。用nsrck把服务器的index信息做了恢复和一致性检测了，日志恢复成功。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
hcjia

论坛徽章:
0
4楼 [报告]
发表于 2007-05-17 16:14 |只看该作者
哈！解决就好！legato 的index信息要经常做一致性检测了!!
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP