sybase恢复用户库失败

zhuanghp

SOLARIS8 + SYBASE 12.5

恢复用户库的时候，出一些信息，请教如何解决:
---------------------------------------------------------------------------------------------------------------
00:00000:00001:2006/01/16 18:06:46.74 kernel  current process (0x1b001b) infected with 11
00:00000:00001:2006/01/16 18:06:46.75 kernel  Address 0x000000008028d85c (pg_gam_extent_count+0x34), siginfo (code, address) = (1, 0x0000000000000000)
00:00000:00001:2006/01/16 18:06:46.75 kernel  ************************************
00:00000:00001:2006/01/16 18:06:46.75 kernel  curdb = 4 pstat = 0x1000 lasterror = 0
00:00000:00001:2006/01/16 18:06:46.75 kernel  preverror = 0 transtate = 1
00:00000:00001:2006/01/16 18:06:46.75 kernel  curcmd = 0 program =                              
00:00000:00001:2006/01/16 18:06:46.77 kernel  pc: 0x0000000080717fa0 pcstkwalk+0x28(0x0000000201e3f728, 0x0000000201e3eea0, 0x000000000000270f, 0x0000000000000002, 0xfffffffffffffff
00:00000:00001:2006/01/16 18:06:46.77 kernel  pc: 0x0000000080717e88 ucstkgentrace+0x1c8(0x000000000000270f, 0x00000000001b001b, 0x0000000000000000, 0x000000021a2e94e0, 0x00000002123b9c0
00:00000:00001:2006/01/16 18:06:46.77 kernel  pc: 0x00000000806d3514 ucbacktrace+0xac(0x0000000000000000, 0x0000000000000001, 0x000000000000001e, 0x00000002123cd9b4, 0x0000000200000000)
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0x00000000801da524 terminate_process+0x101c(0x00000002123b9c08, 0xffffffffffffffff, 0x0000000000000000, 0x0000000201e3fb20, 0x0000000000000001)
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0x00000000806eadf0 kisignal+0x140(0x000000000000000b, 0x0000000201e40550, 0x0000000201e40270, 0x0000000000000000, 0x0000000000000000)
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0xffffffff7f017690 _setitimer+0xb4(0x000000000000000b, 0x0000000201e40550, 0x0000000201e40270, 0x00000000806eacb0, 0x0000000000000000)
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0xffffffff7f0111d8 sema_post+0x530(0x000000000000000b, 0xffffffff7da00000, 0x0000000000000001, 0xffffffff7f11cba0, 0xffffffff7f11ca40)
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0xffffffff7f0113c4 sema_post+0x71c(0xffffffff7da00000, 0x0000000201e40270, 0xffffffff7f11a000, 0x0000000201e40550, 0x0000000201e40550)
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0x000000008028d854 pg_gam_extent_count+0x2c(0x00000002123bad58, 0x0000000000000048, 0x0000000211cfecc8, 0x0000000201e408f8, 0x0000000201e408e
00:00000:00001:2006/01/16 18:06:46.78 kernel  pc: 0x0000000080303a00 th__gam_extent_count+0x68(0x0000000211cfeac0, 0x0000000211cfecc8, 0x0000000201e408f8, 0x0000000201e408e8, 0x000000008030205
00:00000:00001:2006/01/16 18:06:46.79 kernel  [Handler pc: 0x00000000802216d8 std_handle installed by the following function:-]
00:00000:00001:2006/01/16 18:06:46.79 kernel  pc: 0x0000000080302bdc th__count_unreserved_space+0x67c(0x0000000201e40a7c, 0x000000000b10c1ff, 0x0000000000000000, 0x0000000000000000, 0x0000000000000001)
00:00000:00001:2006/01/16 18:06:46.79 kernel  pc: 0x0000000080302058 th_fill_freespaceinfo+0x2d8(0x0000000000000000, 0x0000000000001180, 0x0000000211cffc40, 0xffffffffffffffff, 0x000000000b10c1ff)
00:00000:00001:2006/01/16 18:06:46.79 kernel  [Handler pc: 0x00000000803f5fc0 rec_handle installed by the following function:-]
00:00000:00001:2006/01/16 18:06:46.79 kernel  pc: 0x00000000803f30dc recovery+0xc08(0x0000000000000000, 0x000000021ab3d370, 0x0000000081107800, 0x00000002123b9c08, 0x0000000000004750)
00:00000:00001:2006/01/16 18:06:46.79 kernel  [Handler pc: 0x00000000803f5fc0 rec_handle installed by the following function:-]
00:00000:00001:2006/01/16 18:06:46.79 kernel  pc: 0x00000000803f183c dorecover+0x2a8(0x0000000000000001, 0x0000000211ce9b80, 0x00000002005088c0, 0x0000000000000000, 0x0000000200508a40)
00:00000:00001:2006/01/16 18:06:46.79 kernel  end of stack trace, spid 1, kpid 1769499, suid 0

－－－－－－－－－－－－－－－－－－－－－－－－－
本机有2个用户库，第一个用户库恢复失败后，我BYPASS了第一个用户库，启动第二个用户库，成功。

但第一个用户库恢复过程中，就出上面错误，请高手指点一二，谢谢。

2BeSybPro

select dbid,name from sysdatabases where dbid=4
put the flag -3276 in RUN_SERVER file and try again

zhuanghp

谢谢2BeSybPro，我得找机会试试。
系统在运行，2个用户库，有一个用户库在继续使用中，暂时不便重新启动。
不知道有什么办法可以只启动其中一个用户库
请各位指导！

marmot32

换个名字建一个新库再load?

2BeSybPro

oh, the trace flag is -32768 not -3276

1017of

dataserver -v

zhuanghp

原帖由 1017of 于 2006-1-19 09:25 发表
dataserver -v

Adaptive Server Enterprise/12.5.0.3/EBF 10689 IR/P/Sun_svr4/OS 5.8/rel12503/1915/64-bit/FBO/Thu Jan 23 16:05:19 2003

Confidential property of Sybase, Inc.
Copyright 1987, 2003
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA

zhuanghp

原帖由 2BeSybPro 于 2006-1-19 04:58 发表
oh, the trace flag is -32768 not -3276

我是用status＝-32768  bypass了一个用户库，启动另一个用户库的，
online后，这个用户库也能select，bcp，
改成status=0，就不能启动，出最上面写的错误。

你说的-32768应该不是修改RUN_file吧，我只知道用-T参数来跟踪，但没有负数，
请指导！

1017of

kernel process infect with 11 could be get server response abnormally,but I don't think the lastest information you left here is about recovery failed.you might check errorlog more,maybe there would be more logs about recovery.

zhuanghp

原帖由 1017of 于 2006-1-19 14:19 发表
kernel process infect with 11 could be get server response abnormally,but I don't think the lastest information you left here is about recovery failed.you might check errorlog more,maybe there woul ...

log文件里就是这些内容。
我等了将近一个小时，没有任何变化，就当它恢复失败了，是不是我应该等一晚上看看呢？谢谢你的指导！