yebiao123 发表于 2012-04-23 19:37

informix恢复报错

本帖最后由 yebiao123 于 2012-04-23 19:38 编辑

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

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

19:44:17Maximum server connections 0
19:44:17Start Logical Recovery - Start Log 183091, End Log ?
19:44:17Starting Log Position - 183091 0x55ecb634
19:44:17Clearing the physical and logical logs has started
19:47:21Cleared 28608 MB of the physical and logical logs in 183 seconds
19:47:21rsrecvr.c 4673 set EOF
19:47:21stack trace for pid 3069 written to /tmp/af.48f4cc9
19:47:21Assert Failed: No Exception Handler
19:47:21IBM Informix Dynamic Server Version 11.50.FC8   
19:47:21   Who: Session(17, informix@xjzhdb, 0, 3eaaacf18)
                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:22No logical log restore will be performed.
19:47:22A Logical Restore is active.

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

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


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


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

yebiao123 发表于 2012-04-23 19:40

自己顶顶，高手啊，求救！！！！！！！！！！！！！！！！！！

yebiao123 发表于 2012-04-23 19:54

2012-04-20 19:34:18 28672865 Completed cold level 0 restore dpmdbs5.
2012-04-20 19:35:51 28672865 Begin cold level 0 restore rcounterrmdbs01 (Storage Manager copy ID: 1334535974 1334536015).
2012-04-20 19:36:04 28672865 Completed cold level 0 restore rcounterrmdbs01.
2012-04-20 19:38:10 28672865 Begin cold level 0 restore rcounterrmdbs02 (Storage Manager copy ID: 1334535987 1334536029).
2012-04-20 19:38:23 28672865 Completed cold level 0 restore rcounterrmdbs02.
2012-04-20 19:41:18 28672865 Begin cold level 0 restore llogdbs_n (Storage Manager copy ID: 1334536000 1334536043).
2012-04-20 19:41:18 28672865 Completed cold level 0 restore llogdbs_n.
2012-04-20 19:44:12 28672865 Begin cold level 0 restore plogdbs_n (Storage Manager copy ID: 1334536001 1334536045).
2012-04-20 19:44:12 28672865 Completed cold level 0 restore plogdbs_n.
2012-04-20 19:44:16 28672865 Completed whole system restore.
2012-04-20 19:47:22 28672865 Completed logical restore.
2012-04-20 19:47:22 28672865 (-43080) Process 2867 received signal 15. Process will exit after cleanup.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 SQL -349        Database not selected yet.
2012-04-20 19:47:23 28672865 /opt/informix/bin/onbar_d complete, returning 0 (0x00)


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

liaosnet 发表于 2012-04-23 21:21

也许输出af能看出什么来。。。。online.log基本上看不出东西。

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

yebiao123 发表于 2012-04-23 21:27

我是在恢复的时候出现的这些，明天过去看看用一下您说的方法，谢谢哈。我QQ:279328691，加我下，谢谢！回复 4# liaosnet


   

piles 发表于 2012-04-24 08:27

yebiao123 发表于 2012-04-24 08:37

什么意思，老大？说清楚点啊？回复 6# piles


   

yebiao123 发表于 2012-04-24 19:56

兄弟们再问问，Informix在不做逻辑日志恢复时，能做恢复吗？

cj_gameboy 发表于 2012-04-25 08:14

页: [1]
查看完整版本: informix恢复报错