提示说 xlshop 库脱机,当然不能使用了作者: zhang168869 时间: 2005-07-17 17:01 标题: 紧急求助！！！sybase 11.9.2数据库不能打开！！！！ 各位大侠！！！
我的sybase 11.9.2 运行desdit程序ＰＩＮＧ命令服务端是成功的，sybase服务也是启动的，但在客户端运行程序报如下错误：
“Database "xlshop" is currently offline.Please wait and try your command again later.
操作系统为：sco operserver 5.0.5,各位大侠如何才能使数据库ＯＮＬＩＮＥ，请解解决方案。
谢谢！！！
错误日志：
00:05/07/17 11:04:11.18 server Error: 625, Severity: 21, State: 1
00:05/07/17 11:04:11.19 server Could not retrieve row from logical page 1241999 via RID because the entry in the offset table for that RID is less than or equal to 0.
00:05/07/17 11:04:11.19 server Unable to proceed with the recovery of dbid <5>; because of previous errors. Continuing with the next database.
00:05/07/17 11:04:11.19 server Recovery complete.
00:05/07/17 11:04:11.19 server SQL Server's default sort order is:
00:05/07/17 11:04:11.19 server 'bin_iso_1' (ID = 50)
00:05/07/17 11:04:11.19 server on top of default character set:
00:05/07/17 11:04:11.19 server 'iso_1' (ID = 1).
00:05/07/17 11:04:27.92 server WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #0 with dbid 1 and objid 30. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:05/07/17 11:04:27.92 server WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #1 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:05/07/17 11:04:27.92 server WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #2 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:05/07/17 11:04:27.92 server WARNING: spid 1, with suid 0 and curdbid 5 has active XDES #0 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1, xstatus = 0x8, xmode = 0x0.
00:05/07/17 11:04:27.92 server WARNING: spid 1, with suid 0 and curdbid 5 has active XDES #1 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1, xstatus = 0x8, xmode = 0x0.
00:05/07/17 11:04:27.92 server Contact Sybase Technical Support.作者: hiaw 时间: 2005-07-17 18:00 标题: 紧急求助！！！sybase 11.9.2数据库不能打开！！！！ 这一个错误可能由一个硬件问题所引起.
数据库本身不太可能被损坏.
请首先检查你的硬件,然后重启server并运行dbcc诊断