拜求各位极品高手。关于server系统恢复问题

lqg64150

环境：
    windows 2002 server 下
    sybase120系统非法当机。启动系统后发现sql服务器已无法启动。查看错误日志为：
00:00000:00001:2004/01/17 22:12:25.23 server  Opening Master Database ...
00:00000:00001:2004/01/17 22:12:25.62 server  Loading SQL Server's default sort order and character set
00:00000:00001:2004/01/17 22:12:25.62 server  Loaded default Unilib conversion handle.
00:00000:00002:2004/01/17 22:12:25.62 kernel  network name dthlgs888, type ether, port 5000
00:00000:00001:2004/01/17 22:12:25.71 server  Recovering database 'master'
00:00000:00001:2004/01/17 22:12:26.25 server  Checking external objects.
00:00000:00001:2004/01/17 22:12:26.26 server  Space available in the log segment has fallen critically low in database 'master'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00001:2004/01/17 22:12:26.43 server  Database 'master' is now online.
00:00000:00001:2004/01/17 22:12:26.46 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/01/17 22:12:26.60 server  Error: 834, Severity: 20, State: 4
00:00000:00001:2004/01/17 22:12:26.60 server  Illegal attempt to clean buffer: BUF pointer = '0x4B8D8768', MASS pointer = '0x4B8D8768', (Buf#: '0'), page ptr = '0x49AE1800', dbid = '1', Mass virtpage = '124', Buffer page = '120', Mass status = '0x4001000', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache'.
00:00000:00001:2004/01/17 22:12:26.60 kernel  ************************************
00:00000:00001:2004/01/17 22:12:26.60 kernel  curdb = 1 pstat = 0x1000 lasterror = 834
00:00000:00001:2004/01/17 22:12:26.60 kernel  preverror = 0 transtate = 1
00:00000:00001:2004/01/17 22:12:26.60 kernel  curcmd = 0 program =                              
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01D9F954, 0x77E6615B, 0x77E67D60, 0xFFFFFFFF)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x009EF654 os_get_cur_stk_desc+ 0xf1 (0x01D9F954, 0x01D9F70C, 0x0000270F, 0x00000002)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x009C893F pcstkwalk+ 0x204 (0x000B000B, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x009C85C9 ucstkgentrace+ 0x1f9 (0x000B000B, 0x00000001, 0x00000000, 0x00000000)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x00998D18 ucbacktrace+ 0x88 (0x00000000, 0xFFFFFFFF, 0x01D9FC9C, 0x0045C74C)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x004060A7 terminate_process+ 0xb11 (0x01D9FD08, 0x0045C5C1, 0x00000008, 0x00000022)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x0045C769 close_network+ 0xc (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x0045C74C hdl_default+ 0x38 (0x00000008, 0x00000022, 0x00000014, 0x00000004)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x0045C5C1 ex_raise+ 0x309 (0x00000000, 0x20DC4DE0, 0x00000000, 0x00000000)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x00543090 cm_dbclean+ 0x1be (0x20DC4DE0, 0x2040E0D0, 0x20DC4DE0, 0x01D9FF7C)
00:00000:00001:2004/01/17 22:12:29.42 kernel  pc: 0x004D37BF buf_online_database+ 0xe8 (0x00000000, 0x00000000, 0x00000001, 0x00000000)
00:00000:00001:2004/01/17 22:12:29.43 kernel  pc: 0x00622181 masterrecover+ 0xd9 (0x00000000, 0x00000000, 0x00000000, 0x2001C57C)
00:00000:00001:2004/01/17 22:12:29.43 kernel  pc: 0x00403FDC dsinit+ 0x92c (0x2001C57C, 0x00000000, 0x00000000, 0x2001C57C)
00:00000:00001:2004/01/17 22:12:29.45 kernel  pc: 0x009E7A87 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2004/01/17 22:12:29.45 kernel  pc: 0x77E6758A KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2004/01/17 22:12:29.45 kernel  end of stack trace, spid 1, kpid 720907, suid 0
00:00000:00003:2004/01/17 22:12:29.54 kernel  udstartio: vdn 1 has not been set up
00:00000:00003:2004/01/17 22:12:29.57 server  Error: 840, Severity: 17, State: 1
00:00000:00003:2004/01/17 22:12:29.57 server  Device 'sysprocsdev' (with physical name 'c:\sybase\data\sybprocs.dat', and virtual device number 1) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
00:00000:00003:2004/01/17 22:12:29.70 server  Error: 2812, Severity: 16, State: 5
00:00000:00003:2004/01/17 22:12:29.70 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
由于没有对master进行后备，所以只能在OS级将旧master.dat文件硬拷到新建的server上。可是还是无法启动。错误日志为：
00:00000:00003:2004/01/17 22:12:29.57 server  Device 'sysprocsdev' (with physical name 'c:\sybase\data\sybprocs.dat', and virtual device number 1) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
00:00000:00003:2004/01/17 22:12:29.70 server  Error: 2812, Severity: 16, State: 5
00:00000:00003:2004/01/17 22:12:29.70 server  Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
与上次一样。我估计是master内关于记录sybprocs.dat的记录有问题.但不知如何可以解决。
请各位极品高手救我

chenfeng825

是否使用了replication server，如果是，用发生834错误的master.dat启动，启动前关闭replication server进程!
还有确定sysprocsdev的磁盘文件是否正常，

psgg

单用户启动可以吗？
好象是MASTER 日志满！！！


  对否？？？

lqg64150

现已能用单用户模式启动SERVER，请问各位高手下一步该如何处理？

小无赖

我想应该是master库中信息与现在的sybprocs.dat设备文件不匹配，把旧的sybprocs.dat拷回来试试。如果不行的话可以把sysprocsdev设备删除，再把sybsystemprocs库删除,然后创建一个新的sysprocsdev设备，用Sybase\scripts下的instmstr脚本重建sybsystemprocs库。

恢复sybsystemprocs数据库的方法可以参见系统管理指南第二卷中的第28章恢复系统数据库中的恢复sybsystemprocs库一节。