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，我得找機會試試。
系統(tǒng)在運行，2個用戶庫，有一個用戶庫在繼續(xù)使用中，暫時不便重新啟動。
不知道有什么辦法可以只啟動其中一個用戶庫
請各位指導！

marmot32

換個名字建一個新庫再load?

2BeSybPro

oh, the trace flag is -32768 not -3276

1017of

dataserver -v

zhuanghp

原帖由 1017of 于 2006-1-19 09:25 發(fā)表
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 發(fā)表
oh, the trace flag is -32768 not -3276

我是用status＝-32768  bypass了一個用戶庫，啟動另一個用戶庫的，
online后，這個用戶庫也能select，bcp，
改成status=0，就不能啟動，出最上面寫的錯誤。

你說的-32768應該不是修改RUN_file吧，我只知道用-T參數(shù)來跟蹤，但沒有負數(shù)，
請指導！

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 發(fā)表
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文件里就是這些內(nèi)容。
我等了將近一個小時，沒有任何變化，就當它恢復失敗了，是不是我應該等一晚上看看呢？謝謝你的指導！