免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3609 | 回复: 8
打印 上一主题 下一主题

informix恢复报错 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2012-04-23 19:37 |只看该作者 |倒序浏览
本帖最后由 yebiao123 于 2012-04-23 19:38 编辑

19:44:16  Checkpoint Completed:  duration was 0 seconds.
19:44:16  Fri Apr 20 - loguniq 183091, logpos 0x55ecb634, timestamp: 0x5d2b6e88 Interval: 318933

19:44:16  Maximum server connections 0
19:44:16  Logical Recovery Started.
19:44:16  200 recovery worker threads will be started.
19:44:17  Dynamically allocated new virtual shared memory segment (size 2048000KB)
19:44:17  Memory sizes:resident:11920384 KB, virtual:10240000 KB, no SHMTOTAL limit
19:44:17  Dynamically allocated new virtual shared memory segment (size 2048000KB)
19:44:17  Memory sizes:resident:11920384 KB, virtual:12288000 KB, no SHMTOTAL limit
19:44:17  Checkpoint Completed:  duration was 0 seconds.
19:44:17  Fri Apr 20 - loguniq 183091, logpos 0x55ecb634, timestamp: 0x5d2b6eaa Interval: 318933

19:44:17  Maximum server connections 0
19:44:17  Start Logical Recovery - Start Log 183091, End Log ?
19:44:17  Starting Log Position - 183091 0x55ecb634
19:44:17  Clearing the physical and logical logs has started
19:47:21  Cleared 28608 MB of the physical and logical logs in 183 seconds
19:47:21  rsrecvr.c 4673 set EOF
19:47:21  stack trace for pid 3069 written to /tmp/af.48f4cc9
19:47:21  Assert Failed: No Exception Handler
19:47:21  IBM Informix Dynamic Server Version 11.50.FC8   
19:47:21   Who: Session(17, informix@xjzhdb, 0, 3eaaacf1
                Thread(167, logrecover, 3eaa69398, 10)
                File: mtex.c Line: 491
19:47:21   Results: Exception Caught. Type: MT_EX_OS, Context: mem
19:47:21   Action: Please notify IBM Informix Technical Support.
19:47:21   See Also: /tmp/af.48f4cc9
19:47:22  No logical log restore will be performed.
19:47:22  A Logical Restore is active.

19:47:22  Cannot change to Quiescent Mode.
19:47:31  mtex.c, line 491, thread 167, proc id 3069, No Exception Handler.
19:47:31  Fatal error in ADM VP at mt.c:14062
19:47:31  Unexpected virtual processor termination, pid = 3069, exit = 0x100

19:47:31  PANIC: Attempting to bring system down


############################################################


上面是我Online.log文件里的报错,有高手能看看不?数据库无法到Quiescent 模式。

论坛徽章:
0
2 [报告]
发表于 2012-04-23 19:40 |只看该作者
自己顶顶,高手啊,求救!!!!!!!!!!!!!!!!!!

论坛徽章:
0
3 [报告]
发表于 2012-04-23 19:54 |只看该作者
2012-04-20 19:34:18 2867  2865 Completed cold level 0 restore dpmdbs5.
2012-04-20 19:35:51 2867  2865 Begin cold level 0 restore rcounterrmdbs01 (Storage Manager copy ID: 1334535974 1334536015).
2012-04-20 19:36:04 2867  2865 Completed cold level 0 restore rcounterrmdbs01.
2012-04-20 19:38:10 2867  2865 Begin cold level 0 restore rcounterrmdbs02 (Storage Manager copy ID: 1334535987 1334536029).
2012-04-20 19:38:23 2867  2865 Completed cold level 0 restore rcounterrmdbs02.
2012-04-20 19:41:18 2867  2865 Begin cold level 0 restore llogdbs_n (Storage Manager copy ID: 1334536000 1334536043).
2012-04-20 19:41:18 2867  2865 Completed cold level 0 restore llogdbs_n.
2012-04-20 19:44:12 2867  2865 Begin cold level 0 restore plogdbs_n (Storage Manager copy ID: 1334536001 1334536045).
2012-04-20 19:44:12 2867  2865 Completed cold level 0 restore plogdbs_n.
2012-04-20 19:44:16 2867  2865 Completed whole system restore.
2012-04-20 19:47:22 2867  2865 Completed logical restore.
2012-04-20 19:47:22 2867  2865 (-43080) Process 2867 received signal 15. Process will exit after cleanup.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 2867  2865 /opt/informix/bin/onbar_d complete, returning 0 (0x00)


##################################################################
这一部分是bar_act.log文件的最后部分,谢谢啊!

论坛徽章:
11
金牛座
日期:2015-03-19 16:56:22数据库技术版块每日发帖之星
日期:2016-08-02 06:20:00数据库技术版块每日发帖之星
日期:2016-04-24 06:20:00数据库技术版块每日发帖之星
日期:2016-04-13 06:20:00IT运维版块每日发帖之星
日期:2016-04-13 06:20:00数据库技术版块每日发帖之星
日期:2016-02-03 06:20:00数据库技术版块每日发帖之星
日期:2015-08-06 06:20:00季节之章:春
日期:2015-03-27 15:54:57羊年新春福章
日期:2015-03-27 15:54:37戌狗
日期:2015-03-19 16:56:41数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
4 [报告]
发表于 2012-04-23 21:21 |只看该作者
也许输出af能看出什么来。。。。online.log基本上看不出东西。

不过你可以考虑修改参数STACKSIZE 为512 ,然后再重启数据库看下。。

论坛徽章:
0
5 [报告]
发表于 2012-04-23 21:27 |只看该作者
我是在恢复的时候出现的这些,明天过去看看用一下您说的方法,谢谢哈。我QQ:279328691,加我下,谢谢!回复 4# liaosnet


   

论坛徽章:
0
6 [报告]
发表于 2012-04-24 08:27 |只看该作者
提示: 作者被禁止或删除 内容自动屏蔽

论坛徽章:
0
7 [报告]
发表于 2012-04-24 08:37 |只看该作者
什么意思,老大?说清楚点啊?回复 6# piles


   

论坛徽章:
0
8 [报告]
发表于 2012-04-24 19:56 |只看该作者
兄弟们再问问,Informix在不做逻辑日志恢复时,能做恢复吗?

论坛徽章:
0
9 [报告]
发表于 2012-04-25 08:14 |只看该作者
提示: 作者被禁止或删除 内容自动屏蔽
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP